2573665 - st22 dump DBIF_REPO_SQL_ERROR with 3989 while accessing program | SAP Knowledge Base Article

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 ONE Support launchpad (Login required).

Search for additional results

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