DUMP ANALYSIS- DBIF_RSQL_INTERNAL_ERROR when reading data from infocube

[former_member220155]

HI ALL,

When i am trying to read the data from an info provider RSDRI_INFOPROV_READ.

the runtime error which is comig is DBIF_RSQL_INTERNAL_ERROR

it is throwing a dump which says An internal error in the database interface occurred during access to

the data of table "RSMDATASTATE ".

the lines at which it is dumping are

SELECT SINGLE * FROM RSMDATASTATE

INTO E_S_DATASTATE

WHERE INFOCUBE = I_INFOCUBE

I checked in the table RSMDATASTATE it is having an entry for the required infoprovider.

Please suggest me if anybody across this error in the past.

is there anything to do with cube settings rool ups and compression or something. Please suggeste me.

Thanks in advance

Best regards

SG

[sven_mader2 · Accepted solution]

Hi,

what is the detail error message? SQL error is not enought to know the problem.

this is a simple select. the the abap structure different to the database structure - check the database structure in SE11?

Sven

[former_member220155]

Thanks for your reply.

Solved the issue myself.

[Former Member]

You are trying to read all the values of table RSMDATASTATE into E_S_DATASTATE . check whether E_S_DATASTATE has all thefields as RSMDATASTATE and also in the same sequence , otherwise it will throw a dump

[Former Member]

check this thread...

[;

--- thanks...