Skip to Content

DBIF_RSQL_SQL_ERROR

Hi

In my one of process chain failed due to short dump at DTP Level.

it Showing Runtime error : DBIF_RSQL_SQL_ERROR

Can any body help me what is root Cause for this.

Thanks,

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on May 04, 2011 at 06:33 AM

    Hi,

    This dump is due to table space. Ask your basis consultant to increase table space. There are lot of discussions on this in this forum.

    Thanks,

    V.Senthil

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 04, 2011 at 07:06 AM

    Hi

    You get this error due to various reasons. Mostly if there are any deadlocks or table space issues or lack of memory to process. Please go thru the short dump properly and paste the error message to help you furthur.

    Thanks

    Srikanth

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 04, 2011 at 07:45 AM

    Hi....

    What is the whole error message ? is it "DBIF_RSQL_SQL_ERROR

    CX_SY_OPEN_SQL_DB"

    If yes....then it is a deadlock issue.......index problem......

    Are you loading a cube ? If yes........then check whether Drop Index and create index steps are included in the Process Chain or not.......

    the flow should be :

    Start process

    /

    Drop Index

    /

    DTP

    /

    Create Index

    If it is a DSO...then ask the Basis Team to check the Bitmap Index....and recreate it....

    Check the SAP note : 631668 for details..

    Regards,

    Debjani..

    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.