SAP Knowledge Base Article - Preview

2497511 - ASE Error SQL102 "Incorrect syntax near 'p'" reported from DBACockpit Dashboard

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

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; SAP NetWeaver all versions

Keywords

KBA , BC-DB-SYB , SAP Business Suite on Sybase ASE Database Platform , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.