Skip to Content
avatar image
Former Member

BI JOB failing with dump DBIF_RSQL_SQL_ERROR exception CX_SY_OPEN_SQL_DB

Hi All,

One of our BI Jobs is failing with the runtime error (DBIF_RSQL_SQL_ERROR exception CX_SY_OPEN_SQL_DB). In SM21 i can see lot of logs saying "BREAKPOINT REACHED". In SM37 i can see this message "Overlapping check with archived data areas for InfoProvider ZCBJCMD0". We are on latest support pack SPS16 (BW 18). Could anybody guide me how i can proceed.

Thanks

Raj

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    Oct 16, 2008 at 01:38 AM

    Any replies please

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Matt,

           Your answer helped me if fixing the data load issue. I had to drop the indices and run the DTP and the load got through successfully.

      Wish I could award you more than 2 points by clicking on LIKE.

      Thank you :-)

      Regards,

        Manohar. D

  • avatar image
    Former Member
    Oct 16, 2008 at 05:55 AM

    Hello Raj,

    Kindly visit this note 1236334 and apply the necessary correction its a program error.

    Regards

    Vivek

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 13, 2012 at 01:19 PM

    Thanks Matt.

    Little tips, if you can't mark the Update Subsequently in Data Targets option because it's desable, go into the InfoPackages via a Process chain and the option is availaible.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 24, 2015 at 11:59 PM

    Hi everyone,

    Note was created for solve this type of errors and dumps:

    1946893 - ORA-00060 Deadlock in Cube load

    Regards,

    Janaina

    Add comment
    10|10000 characters needed characters exceeded