runtime error DBIF_RSQL_SQL_ERROR

[#1]

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.

[Former Member]

Hi,

Please check SM21 log and post the error log details.

Thanks,

-J