Symptom
- In SM21 and the corresponding developer trace of solution manager or the managed system we see ASE Error SQL156
C ERROR: -1 in function ExeNormalModify (execute) [line 32861]
C (156) [ZZZZZ] [SAP][ASE ODBC Driver][Adaptive Server Enterprise]Incorrect syntax near the keyw
C ord 'max'.
C
C sql statement is ==> EXEC saptools..SP_DBH_ALERT_COLLECTOR ? ,? ,? ,?
C invalid syntax near keyword 'max': <EXEC saptools..SP_DBH_ALERT_COLLECTOR ? ,? ,? ,? >
C dbdssyb: DBSL99 SQL156
C [ASE Error SQL156][SAP][ASE ODBC Driver][Adaptive Server Enterprise]Incorrect syntax near the keyword 'max'.
C
B ***LOG BY2=> sql error 156 performing EXE [dbds 301]
B ***LOG BY0=> [ASE Error SQL156][SAP][ASE ODBC Driver][Adaptive Server Enterprise]Incorrect syntax near the keyword 'max'.
[dbds 301]
C
- In DBACOCKPIT -> Configuration -> DBA Cockpit Framework -> Data Collectors , we see the following errors in the object log of the 'Alert Collector'
04/02/2020 05:41:36 Start of routine: saptools..SP_DBH_ALERT_COLLECTOR (Log Level: 3)
04/02/2020 05:30:03 Server message:
04/02/2020 05:30:03 Msg 156, Level 15, State 2:
04/02/2020 05:30:03 Server '<SID>', Line 1:
04/02/2020 05:30:03 Incorrect syntax near the keyword 'max'.
04/02/2020 05:30:02 Start of routine: saptools..SP_DBH_ALERT_COLLECTOR (Log Level: 3)
04/02/2020 05:25:40 Start of routine: saptools..SP_DBH_ALERT_COLLECTOR (Log Level: 3)
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 15.7 for Business Suite
- SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
- SAP Solution Manager (SOLMAN) 7.1
- SAP Solution Manager (SOLMAN) 7.2
- SAP NetWeaver (NW) - All versions
Product
Keywords
SQL156, Incorrect syntax, DBACOCKPIT, 'max', SP_DBH_ALERT_COLLECTOR , 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 for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.