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