Skip to Content

Error calling RFC function to get table

Hi All,

As per my client requirement I am doing incremental load using Auto correct load option.

I have done the initial load successfully. But when ever I am trying to do incremental load, I am facing the below error.

The source has 300000 records.

I increased the array fetch size up to 5000 in source table options and increased the no. of loader as 8 in target table option.

Kindly help me how to overcome this error.

Thank you very much.



Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Posted on Sep 21, 2015 at 09:51 AM

    The problem is at source side, not at the target.

    How many records did you manage to retrieve during the initial load? It seems the incremental query condition is not pushed down to the underlying database.

    Execute your extraction in background. Or ask your Basis colleagues to increase the time-out. Or use an ABAP data flow instead of a regular one.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 22, 2015 at 08:49 PM

    If you convert your RFC on the ECC system to a background mode job (instead of dialog mode) you can run jobs longer without the timeout problem.

    We have done this because our ECC systems have different timeouts for dialog mode (which is what you are running it as) and background mode.

    You can change the BODS job to background mode by opening the table in designer and clicking the checkbox for "background." It will try to run the job in background mode, you may need more permissions for your role though.

    We have tried to make the setting on the datastore to be "Background=yes" but that does not appear to influence the job running in background. Only the setting on the SAP table actually does this.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.