on 12-04-2013 12:15 AM
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.