SAP Knowledge Base Article - Preview

2573665 - st22 dump DBIF_REPO_SQL_ERROR with 3989 while accessing program

Symptom

Every day around 00:30:00 this short dump appear in st22:

  Category Resource Shortage
  Runtime Errors DBIF_REPO_SQL_ERROR

  Short Text
  SQL error 3989 while accessing program "CX_SY_OPEN_SQL_DB=============CP" part "LOAD".

  What happened?
  Database error text: "New request is not allowed to start because it should come with valid transaction descriptor."

 Information on where terminated
 The termination occurred in ABAP program "SAPLSBPT", in "DO_TBTCO_CONSISTENCY_CHECK". The main program was "RSBTCCNS".

Database Interface Information

C 1 ERROR: -1 in function StartSelect (execute) [line 16456] [D:/depot/bas/745_REL/src/dbs/mss/slo
C 1 (1205) [40001] [Microsoft][SQL Server Native Client 11.0][SQL Server]Transaction (Process ID 6
C 1 pid[14156] Deadlock in StartSelect - D:/depot/bas/745_REL/src/dbs/mss/slodbc.c line 16456 Tran
C 1 Error 99 (dbcode 1205) in StartSelect [D:/depot/bas/745_REL/src/dbs/mss/slodbc.c#16457]
C 1 StartSelect,WritePrepStatementToDevTrace: statement id does not match prepared statement. Not
B E ***LOG BYO=> deadlock aborts transaction [dbsh#1206]
B 1 SQL code: 1205, SQL text: Transaction (Process ID 67) was deadlocked on lock resources with an
B E ***LOG BY4=> sql error 1205 performing FET on table TBTCP [dbdbslst#4806]
B E ***LOG BY0=> Transaction (Process ID 67) was deadlocked on lock resources with another process
C 1 ERROR: -1 in function StartSelect (execute) [line 16456] [D:/depot/bas/745_REL/src/dbs/mss/slo
C 1 (3989) [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]New request is not allowe
C 1 Error 99 (dbcode 3989) in StartSelect [D:/depot/bas/745_REL/src/dbs/mss/slodbc.c#16457]
C 1 StartSelect: stmt of 6 REPOLOAD 1865 20170512211246 [D:/depot/
C 1 SELECT TOP 1 "UNAM" ,"UDAT" ,"UTIME" ,"L_DATALG" ,"Q_DATALG" ,"SDAT" ,"STIME" ," [D:/depot/bas
C 1 MINOR_VERS" ,"MAJOR_VERS" FROM "REPOLOAD" WHERE "PROGNAME" = ? AND "R3STATE" = ? [D:/depot/bas
C 1 AND "MACH" = ? AND "MAJOR_VERS" = ? [D:/depot/bas/745_REL/src/dbs/mss/slodbc.c#23560]
C 1 /* R3:REP1:0 T:REPOLOAD M:400 */ [D:/depot/bas/745_REL/src/dbs/mss/slodbc.c#23560]
B 1 DBREPO: report table: 'REPOLOAD ' [D:/depot/bas/745_REL/src/krn
B 1 DBREPO: program: 'CX_SY_OPEN_SQL_DB=============CP ' [D:/depot/bas/745_REL/src/krn/dbi/
B 1 DBREPO: state: A, lang = *, mach = 562 [D:/depot/bas/745_REL/src/krn/dbi/dbeu/dbrepo.c#3101]
B E ***LOG BY4=> sql error 3989 performing SEL on table REPOLOAD [dbrepo#3101]
B E ***LOG BY0=> New request is not allowed to start because it should come with valid transaction


Read more...

Environment

  • SQL Server database;
  • Netweaver system;

Product

SAP NetWeaver all versions

Keywords

DBIF_REPO_SQL_ERROR, SQL error 3989, 3989, sql error 1205 performing FET on table TBTCP,
New request is not allowed to start because it should come with valid transaction descriptor , KBA , BC-DB-MSS , SQL Server in SAP NetWeaver Products , 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.