Symptom
- When accessing to the Dashboard from "Database <SID>" tab of DBACockpit, this error is returned on top of the window:
Exception CX_DBA_ADBC in program SAPMHTTP line 0
Kernel Error ID:
WP ID: 19
WP PID: 4564
Application Server: <XXX>
SYSID: FRQ
SY-SUBRC: 0
SQL statement: select count(*) from sybmgmtdb..js_history j, master..sysprocesses p where p.kpid = and p.spid = j.jsh_spid
Database: +++SYBADM
caused by
Exception CX_SQL_EXCEPTION in class CL_SYB_RDI_QUERY
Kernel Error ID:
DB Error: Yes
SQL Code: 102
SQL Message: [ASE Error SQL156][SAP][ASE ODBC Driver][Adaptive Server Enterprise]Incorrect syntax near the keyword 'and'.
[ASE Error SQL102:42000][SAP][ASE ODBC Driver][Adaptive Server Enterprise]Incorrect syntax near 'p'.
- Error is also reported on SM21 and details in related developper trace files shows:
C ERROR: -1 in function StartSelect (execute) [line 27159]
C (156) [ZZZZZ] [SAP][ASE ODBC Driver][Adaptive Server Enterprise]Incorrect syntax near the keyw
C ord 'and'.
C
C sql statement is ==> select count(*) from sybmgmtdb..js_history j, master..sysprocesses p where p.kpi
C d = and p.spid = j.jsh_spid
C /* R3:CL_SQL_STATEMENT==============CP:500 T:js_hi
C story M:002 */
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 15.7 for Business Suite
- SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
- SAP NetWeaver (NW) - All versions
Product
Keywords
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.