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
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, deadlock , 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.
SAP Knowledge Base Article - Preview