Error occured while loading from Infopackage: An error occured in source system.

[Former Member]

Hi all,

Below is the error message we are getting while loading from Infopackage in process chain : Production System.

Further analysis done are:

There are no Idocs or trfc struck in source system.

RSA3 is good.

ST22 dump error details is DBIF_RSQL_INVALID_CURSOR

Source system connection is good.

Datasource is active & replicated.

Its a generic datasource based on function Module.

Please suggest us with solutions.

[MGrob · Accepted solution]

Hi

I agree with Anshu looks like your FM module is not working properly. The dump reason is caused b procedure to commit. This closes then your current cursor and you get DBIF_RSQL_INVALID_CURSOR.

hope it helps

Martin

[former_member185177]

Hi Aravind, 

The error should be in FM.

Check the FM if you have used OPEN CURSOR and FETCH CURSOR and you need to use CLOSE CURSOR.

In continuation, check the data declaration there you need declare the cursor using statics key word.  

STATICS : s_cursor type cursor. 

Hope it solves your problem. 

Regards,

Krishna Chaitanya.

[former_member185177]

Hi Aravind,  The error should be in FM. Check the FM if you have used OPEN CURSOR and FETCH CURSOR and you need to use CLOSE CURSOR. In continuation, check the data declaration there you need declare the cursor using statics key word.   STATICS : s_cursor type cursor.  Hope it solves your problem.  Regards, Krishna Chaitanya.

[anshu_lilhori]

Hi Krishna,

One suggestion if you don't mind..

Can you give the replies in different paragraph rather than combining all into one.It makes more easy to understand.

I hope you will also feel the same.

Regards,

AL

[Former Member]

Go to process chain tab in menu bar--> select Attribute--->execution user--> select current user this may resolve your issue

[former_member182470]

You can get rid of this problem by implementing SAP Note: 1606565

[former_member182470]

Hi Aravind,

Is your problem still not resolved? The Note which I gave you is a perfect solution. We applied and resolved the issue.

Regards,

Suman

[Former Member]

Hi Suman,

The issue is not yet resolved. We are checking sap notes to implement.

I will get back to you all with correct resolution when the issue is resolved.

Regards,

Aravind.

[Former Member]

Hi Aravind,

You can get the exact info where the extractor is getting terminated with the help of short dump details. can you post the short dump details like ...

Error analysis

How to correct the error

Source Code Extract

So that we can provide you the exact point where its throwing the dump.

Can you tell whats the data volume of the extractor?

Are you performing a FULL or INIT load?

Can you tell us the data packet size you are using to extract in infopackage?

Can you tell us in RSA3 what are the parameters you are using here

Data Records / Calls

Display Extr. Calls

If you are running for

Data Records / Calls - 100

Display Extr. Calls - 10

or lesser selection extractor may run with out any issue.... check with increased no of above parameters in RSA3 and check if it throws short dump or not?

Regards

KP

[anshu_lilhori]

Hi Arvind,

To me it seems the issue with the function module.I just got this thread relevant to your issue.

Please check that out :

http://scn.sap.com/thread/3379039

Hope this helps.

Regards,

AL

[RamanKorrapati]

Hi Nag,

Recently any changes happen to source system or FM code of this data source.

Based on your ecc version you may need to apply relevant OSS Note: 1712355

http://benxbrain.com/en/index.do?onInputProcessing=brai_thread&001_thread_id=2114471%20&001_temp=R3T...

Thanks