SAP Knowledge Base Article - Preview

2215662 - Error 102 "Incorrect syntax near '%.*s'" when executing run_update_index_stats.sql - SAP ASE for Business Suite

Symptom

  • You are trying to run the script run_update_index_stats.sql as per KBA 1757691 to perform update index statistics for all tables in the <SID> database.
  • This generates the following errors:

Msg 102, Level 15, State 181:
Server 'SID', Line 2:
Incorrect syntax near 'go'.
Msg 102, Level 15, State 181:
Server 'SID', Line 5:
Incorrect syntax near 'go'.
Msg 102, Level 15, State 181:
Server 'SID', Line 9:
Incorrect syntax near 'go'.
Msg 102, Level 15, State 181:
Server 'SID', Line 24:
Incorrect syntax near 'go'.
Msg 102, Level 15, State 181:
Server 'SID', Line 26:
Incorrect syntax near 'go'.
Msg 102, Level 15, State 181:
Server 'SID', Line 33:
Incorrect syntax near 'go'.
Msg 134, Level 15, State 1:
Server 'SID', Line 35:
The variable name '@cmd' has already been declared.  Variable names must be
unique within a query batch or stored procedure.
Msg 102, Level 15, State 181:
Server 'SID', Line 48:
Incorrect syntax near 'go'.


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 15.7 and 16.0 for Business Suite

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

dos2unix , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.