cancel
Showing results for 
Search instead for 
Did you mean: 

runtime error DBIF_RSQL_SQL_ERROR

Former Member
0 Kudos

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.

Accepted Solutions (1)

Accepted Solutions (1)

sander_vanwilligen
Active Contributor
0 Kudos

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

Answers (3)

Answers (3)

former_member183519
Contributor
0 Kudos

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

Former Member
0 Kudos

Hi,

Please check SM21 log and post the error log details.

Thanks,

-J

Former Member
0 Kudos

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.