2910651 - ASE Error SQL156 "Incorrect syntax near the keyword 'max'" in SP_DBH_ALERT_COLLECTOR - SAP ASE for BS

• 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...

• 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 

SAP Adaptive Server Enterprise 16.0 ; SAP ERP 6.0 ; SAP NetWeaver 7.1 ; SAP NetWeaver 7.2 ; SAP NetWeaver 7.3 ; SAP NetWeaver 7.4 ; SAP NetWeaver 7.5 ; SAP Solution Manager 7.1 ; SAP Solution Manager 7.2

SQL156, Incorrect syntax, DBACOCKPIT, 'max', SP_DBH_ALERT_COLLECTOR , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , Problem