Runtime Error - DBIF_RSQL_INVALID_CURSOR

[Former Member]

Hi,

I am trying to load the data in DSO using Function Module based DataSrc. It is working fine in Dev system but it is giving error in Qas system, I am getting a short dump while running an extractor for BW.

Here is the error:

Runtime Errors         DBIF_RSQL_INVALID_CURSOR

Exception              CX_SY_OPEN_SQL_DB

Please find attached the screen-shot of ST22 dump. I tried researching in SCN, but was not able to find much on this. Please advise.

Regards,

Harpreet

[RaymondGiuseppi]

I suppose the Quality assurance system has much more data than the development one, so the FM is, at least, called twice, and you did not open your cursor with option WITH HOLD /or/ the cursor was not defined as a STATICS variable /or/ you called a tool that closed the cursor in your code, so at second call the FETCH statement raise the error ?

But if you read data from an InfoObject, I'm almost sure you don't need to build a customer generic FM datasource. Ask at correct space like Data Warehousing for "generate export datasouce".

Regards,

Raymond