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