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 for Me (Login required).

Search for additional results

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