SAP Knowledge Base Article - Preview

3253208 - ASE Error SQL102 Incorrect syntax near 'sl' EXEC saptools..SP_DBH_ALERT_COLLECTOR

Symptom

  • In DBACOCKPIT -> Configuration -> DBA Cockpit Framework -> Data Collectors , following error can be seen in the object log of the 'Alert Collector'
    Server message: 
    Msg 102, Level 15, State 181: 
    Server '<SID>', Line 1:
    Incorrect syntax near 'sl'. 
    Start of routine: saptools..SP_DBH_ALERT_COLLECTOR (Log Level: 3) 
  • Running the stored procedure directly in isql get same error 102:

1> EXEC saptools..SP_DBH_ALERT_COLLECTOR
2> go
Msg 102, Level 15, State 181:
Server '<SID>', Line 1:
Incorrect syntax near 'sl'.
(return status = 0)

  • Error starts to happen after patching BALDR version 20220829141411 based on note 2502193 - SYB: BALDR - New Monitoring Persistency Layer for SAP ASE

1> select * from DBH_CONFIG where [KEY] like "%BALDR_VER%"
2> go
 DFT                                  KEY                              VALUE                    
 ------------------------------------ -------------------------------- ----------------------------
 20220829141411                       BALDR_VERSION                    20220829141411           

(1 row affected)


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
  • SAP Solution Manager (SOLMAN) 7.2
  • SAP NetWeaver (NW) - All versions 

Product

SAP Adaptive Server Enterprise 16.0 ; SAP Solution Manager 7.2

Keywords

SQL102, Incorrect syntax near 'sl',  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.