SQL error 3989 occurred when accessing program (Dump: DBIF_REPO_SQL_ERROR)

[Former Member]

Hello,

My SAP system shows in ST22 a short-dump related with a Job SAP_BTC_TABLE_CONSISTENCY_CHECK (RSBTCCNS, variant SAP&AUTOREPYES), this is the job log:

In ST22 as I said before, I see the short-dump DBIF_REPO_SQL_ERROR (Program: SAPLSBPT):

The details of this error:

Category              Resource Shortage

Runtime Errors     DBIF_REPO_SQL_ERROR

Date and Time      03.12.2013 00:30:15

Short text:

SQL error 3989 occurred when accessing program

Error analysis:

Error Text of the Database: "New request is not allowed to start because it should come with valid transaction descriptor."

Triggering SQL Statement: "CX_SY_OPEN_SQL_DB=============CP "

How to correct the error:

Internal call code.........: "[REPO/*/43/LOAD/CX_SY_OPEN_SQL_DB=============CP]"

Please check the entries in the system log (Transaction SM21).

If the error occures in a non-modified SAP program, you may be able to find an interim solution in an SAP Note.

If you have access to SAP Notes, carry out a search with the following keywords:

"DBIF_REPO_SQL_ERROR" " "

"SAPLSBPT" or "LSBPTFXX"

"DO_TBTCO_CONSISTENCY_CHECK"

I tried to found a solution and I read some SAP notes for that purpose like the following ones:

1440439 - New Standard Jobs (2)

1549293 - SM65: Consistency check improvements

I also read the following blog post:

Can you help me please to understand this problem and how can I correct this issue!!?

Thank you

Kind regards,

samid raif

[Former Member]

please check if you are not running this job parallely when job with report RSBTCDEL2 runs.

Can you try to do this and see if it works :

SM65 choose "Goto -> Additional tests". Select "Consistency check DB tables" and "Remove inconsistencies". Choose "Execute".

best regards

ashish