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 ONE Support launchpad (Login required).

Search for additional results

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