on 10-22-2015 10:07 PM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Please check SM21 log and post the error log details.
Thanks,
-J
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.