Skip to Content
avatar image
Former Member

runtime error DBIF_RSQL_SQL_ERROR

Dear Experts,

I am extracting data from PSA ( data source 2LIS_03_BF ) to Info Cube 0RT_C37.

In the PSA the no of records are 9,82,316 in one request.

While I am extracting this request from PSA to Info Cube 0RT_C37, the DTP finished successfully ( Transferred records : 9,82,316

and added records : 7,36,269 ).

But the problem is, if we go to the DTP monitor screen for this request showing given below 2 error messages.

1. Updating to InfoCube 0RT_C37

2.Dump: Internal session terminated with runtime error DBIF_RSQL_SQL_ERROR (see ST22). Please find the given below screen shot for the same.


In ST22 the error message is :


Runtime Errors         DBIF_RSQL_SQL_ERROR

Except.                CX_SY_OPEN_SQL_DB

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

For Your Information the DTP request status is Green, Compression and Rollup done successfully.

In this case, please suggest me , will it be any problem / mismatch in the added records?. and how can we cross check the added records correct or not.

Thanks,

Suresh.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    Oct 23, 2015 at 01:43 AM

    Hi Suresh,

    I am afraid that the short dump is caused by a full table space. Please check or get in touch with an SAP Basis Administrator. The table space has to be extended.

    Afterwards, remove the failed load and start again.

    By the way, I am surprised that the status of the load is green. Normally, it should turn red in case of any errors like a short dump. I don't have an explanation for this yet.

    Best regards,

    Sander

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 23, 2015 at 02:11 AM

    Hi Suresh,

    This would be because the transaction log for database might be full , in this case you should see more than one dump (DBIF**) in your system on the same day when you had this issue (if you have couple of jobs running in process chains). you check it from ST22.

    anyway, in such cases, some time DTP status remain yellow, did you check if some one might have forcefully changed to green? which allowed to run the compress and roll up . if possible, please post your DTP details tab screen shot.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 26, 2015 at 11:52 AM

    Hi,

    Please check SM21 log and post the error log details.

    Thanks,

    -J

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 26, 2015 at 12:03 PM

    Hello Suresh,

    This is generic error.

    1) Activate cube through this program RSDG_CUBE_ACTIVATE in SE38.

       reload the cube .then also if doesnt load it would case of spcial chars..

    2)  chck in DB02 for tablespace , if  it is full ask basis to extend.

    3) many times this type of error comes because while we trying to load to info provider other process is locking the same info provider.

    Regards,

    Hitesh

    Add comment
    10|10000 characters needed characters exceeded