Runtime Error - DBIF_RSQL_INVALID_CURSOR

Former Member — Wed, 27 Feb 2013 11:16:48 GMT

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

Re: Runtime Error - DBIF_RSQL_INVALID_CURSOR

RaymondGiuseppi — Thu, 28 Feb 2013 13:00:04 GMT

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

topic Runtime Error - DBIF_RSQL_INVALID_CURSOR in Application Development and Automation Discussions

Runtime Error - DBIF_RSQL_INVALID_CURSOR

Re: Runtime Error - DBIF_RSQL_INVALID_CURSOR