Error calling RFC function to get table

[former_member214784]

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.

by

vinodh

[Former Member]

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.

[former_member187605]

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.

[former_member214784]

Hi Dirk,

For initial load I retrieved totally 220000 records from source to target.

now the source having only 303,999 records, for this also we need to go for ABAP dataflow?

Thanks.

Vinodh

[former_member198401]

Vinodh,

Ask the BASIS team to increase the /MAX_WPRUN_TIME timeout parameter.

What is the Data Transfer method which you are using. If you are on DS 4.2 then better go for RFC Data Transfer

If there are too many delta records then it will be better to go for ABAP Data flow

Regards

Arun Sasi

[former_member187605]

How long did it take to run the initial load? As Arun mentioned, there's a timeout in ECC, you may have managed to stay just under the threshold with 220K records and are now slightly above with 309K.