Question Re: runtime error DBIF_RSQL_SQL_ERROR in Technology Q&A

runtime error DBIF_RSQL_SQL_ERROR

Former Member — Thu, 22 Oct 2015 21:07:32 GMT

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.

Re: runtime error DBIF_RSQL_SQL_ERROR

sander_vanwilligen — Fri, 23 Oct 2015 01:43:17 GMT

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

Re: runtime error DBIF_RSQL_SQL_ERROR

Former Member — Fri, 23 Oct 2015 02:11:39 GMT

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.

Re: runtime error DBIF_RSQL_SQL_ERROR

Former Member — Mon, 26 Oct 2015 11:52:08 GMT

Hi,

Please check SM21 log and post the error log details.

Thanks,

-J

Re: runtime error DBIF_RSQL_SQL_ERROR

former_member183519 — Mon, 26 Oct 2015 12:03:28 GMT

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