SAP Knowledge Base Article - Preview

2805074 - Error 8201 reported in ASE error log with objid=0 and dbid=0 - SAP ASE for Business Suite

Symptom

  •  The following error is being reported in the ASE error log file:

00:0006:00000:00499:YYYY/DD/MM 14:57:09.06 server Error: 8201, Severity: 26, State: 6
00:0006:00000:00499:YYYY/DD/MM 14:57:09.06 server Keep count of descriptor (objid=0, dbid=0) was expected to be 1. Instead 0 was found.

  • No stacktrace reported following that message.
  • The message refers to objid=0, dbid=0 , so we don't know from which database was the impacted object. 
  • When trying to crossmatch with SM21 log, at the same time this is reported:

14:57:09 DIA 018 000 D062248 BY 2 Database error 21 at OPC
14:57:09 DIA 018 000 D062248 BY 0 > [ASE Error SQL21][SAP][ASE ODBC Driver][Adaptive Server
14:57:09 DIA 018 000 D062248 BY 0 > Enterprise]WARNING - Fatal Error 8201 occurred at Jun 11 201
14:57:09 DIA 018 000 D062248 BY 0 > 2:57PM. Please note the error and time, and contact a user
14:57:09 DIA 018 000 D062248 BY 0 > with System Administrator (SA) authorization.
14:57:09 DIA 018 000 D062248 AB 0 Runtime error "DBIF_DSQL2_SQL_ERROR" occurred.
14:57:10 DIA 018 000 D062248 AB 1 > Short dump "190611 145625 spwdfvml0912_TDM_00 D062248 " created.

  • Checking the related developer trace file (dev_w18 in this case):

C Tue Jun 11 14:57:09 2019
C ERROR: -1 in function StartSelect (execute) [line 22935]
C (21) [ZZZZZ] [SAP][ASE ODBC Driver][Adaptive Server Enterprise]WARNING - Fatal Error 8201 occ
C urred at Jun 11 2019 2:57PM. Please note the error and time, and contact a use
C r with System Administrator (SA) authorization.
C
C sql statement is ==> SELECT top 1 index_col ( ? , ? , ? , ? ) FROM sysindexes
C /* R3:SDB1FSYB:334 T:s
C ysindexes M:000 */
C
C dbdssyb: DBSL99 SQL21
C [ASE Error SQL21][SAP][ASE ODBC Driver][Adaptive Server Enterprise]WARNING - Fatal Error 8201 occurred at Jun 11 2019 2:57PM. P
C
B ***LOG BY2=> sql error 21 performing OPC [dbds 398]
B ***LOG BY0=> [ASE Error SQL21][SAP][ASE ODBC Driver][Adaptive Server Enterprise]WARNING - Fatal Error 8201 occurred at Jun 11 201
[dbds 398]
A TH VERBOSE LEVEL FULL
A ** RABAX: level LEV_RX_PXA_RELEASE_MTX entered.

...
...

...

ABAP Program SDB1FSYB .
A Source SDB1FSYB Line 303.
A Error Code DBIF_DSQL2_SQL_ERROR.
A Module $Id: //bas/721_STACK/src/krn/runt/abexsql.c#1 $ SAP.
A Function DsqlErrorHandler Line 2111.


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16.0 SP03 P06 for Business Suite
  • SAP NetWeaver (NW) - All versions 

Product

SAP ERP 6.0

Keywords

8201, descriptor, "open objects", SQL21, "number of open partitions", "number of open indexes", "number of open objects" , KBA , BW-SYS-DB-SYB , BW 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 ONE Support launchpad (Login required).

Search for additional results

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