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.
SAP Knowledge Base Article - Preview