SAP Knowledge Base Article - Preview

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

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