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

[Sriram2009 · Accepted solution]

Hi

Kindly refer the SAP Notes

https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/sno/ui_entry/entry.htm?param=69765F6D6F6465...

1893670 - Problems with RSBTCCNS (SM65)

Regards

Ram

[Former Member · Accepted solution]

Hello Sriram,

I read that SAP note (1893670) and I implemented it, but it continues to show me the same error.

Any tips?

Kind regards,

samid raif

[joo_migueldimas · Accepted solution]

Hello raif,

Some weeks ago I faced a similar error, what I did to solve was... first check the jobs SAP_BTC_TABLE_CONSISTENCY_CHECK (RSBTCCNS) and SAP_REORG_JOBS (RSBTCDEL2) and check if they are schedule at the same time. If so, try to schedule again that two jobs with different hours of running start so they won't be overlapped in their execution!

After that please check if the error is shown again.

I´ll wait for some feedback.

Kind regards,

João Dimas

[Former Member · Accepted solution]

Hello João,

I did exactly what you recommended and now I think the problem/error is solved. I scheduled again those two SAP jobs with different hours of running start, the SAP_REORG_JOBS (RSBTCDEL2) start daily at 00:40 and the job SAP_BTC_TABLE_CONSISTENCY_CHECK (RSBTCCNS) start daily at 00:30.

Now it seems to me that everything is working fine without errors in ST22

Thank you very much,

BR,

samid raif

[former_member45419]

Hello raif,

pls check below threads for similar error

http://scn.sap.com/thread/1409678

http://scn.sap.com/thread/1353280

DBIF_REPO_SQL_ERROR In ST22 Dump - Toolbox for IT Groups

Regards

Nayeem

[ashish_vikas]

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

[Former Member]

Hi,

Can you please check this note as it says that you done need to run this.

1626758 - Background consistency check no longer runs as job

But this note suggest that no more it locks the table

1549293 - SM65: Consistency check improvements

Try to run the program manually and see if it works.

Thanks

Rishi Abrol