SAP Knowledge Base Article - Preview

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

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

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

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.