Skip to Content
author's profile photo Former Member
Former Member

Runtime error DBIF_RSQL_SQL_ERROR when executing DTP

Hi all,

We have recently upgraded our BW solution from SAPKW70020 to SAPKW70023. After this upgrade we are experiencing runtime errors when executing a DTP. We have a process chain set up that loads data using three different datasources into three different DSO's. They are executed in parallel.

One of DTPs that loads data into the DSO fails with the runtime error DBIF_RSQL_SQL_ERROR and the exception CX_SY_OPEN_SQL_DB:

Short text: SQL error in the database when accessing a table.

What happened?: The database system detected a deadlock and avoided it by rolling back your transaction.

What can you do?: If possible (and necessary), repeat the last database transaction in the hope that locking the object will not result in another deadlock.

Error analysis: An exception occurred that is explained in detail below. The exception, which is assigned to class 'CX_SY_OPEN_SQL_DB', was not caught in procedure "DD_DD04T_RANGE_DEL" "(FORM)", nor was it propagated by a RAISING clause. Since the caller of the procedure could not have anticipated that the exception would occur, the current program is terminated.

The reason for the exception is: The database system recognized that your last operation on the database would have led to a deadlock. Therefore, your transaction was rolled back to avoid this.

ORACLE always terminates any transaction that would result in deadlock. The other transactions involved in this potential deadlock are not affected by the termination.

If I delete data from the DSO and load manually, everything works ok.

The process chain was running without errors before the upgrade.

Has anyone experienced this problem?

Does anyone know what the table DD04T contain and why this is accessed during the DTP?

Thanks for your help:)

Best regards,

Linda

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Feb 24, 2010 at 01:59 PM

    I forgot to mention the datasources in use. They are:

    - 0FI_GL_10 General Ledger: Leading Ledger Balances

    - 3FI_GL_L1_TT General Ledger: Non-leading Ledger local GAAP L1

    - 3FI_GL_L2_TT General Ledger: Non-leading Ledger tax GAAP L2

    It is for the last one, 3FI_GL_L2_TT, that the DTP loading data from PSA to DSO fails.

    We have several other process chain set up to run every night, and they all run ok.

    BR,

    Linda

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 24, 2010 at 02:02 PM

    Hi Linda,

    I had the same problem and used note 750033, it worked fine. I set the named parameter up to 40.

    BR

    Benni

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Feb 14, 2014 at 09:17 PM

    Hello,

    If you face this issue please do the following steps :

    path : Double click your DTP -->Click on "Go To"-->Click on " Settings for Batch manager"--> put "Number of Processes (Parallel Processin)" as 2 or 1--Then save.

    Run your DTP & it will work.

    Thanks,

    Koushik

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 24, 2020 at 01:03 PM

    Hello,

    If you face this issue please do the following steps :

    path : Double click your DTP -->Click on "Go To"-->Click on " Settings for Batch manager"--> put "Number of Processes (Parallel Processin)" as 2 or 1--Then save.

    Run your DTP & it will work.

    Thanks,

    Koushik

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.