Skip to Content
author's profile photo
M Reddy

DBIF_RSQL_SQL_ERROR

Posted on May 04, 2011 at 06:00 AM 2 Views

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,

BW (SAP Business Warehouse)
Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • author's profile photo
    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 comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Sri BW
    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 comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    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 comment
    10|10000 characters needed characters exceeded