System_Failure when trying RFC for some SAP tables

Submitted by Anonymous (not verified) on Sun, 09/14/2014 - 09:10

I try read some tables by RFC but I got an error message: System_Failure.
Although it works with most tables.
The problem table is AFIH

Duration: 
No expiration

Comments

1
Jimbo's picture
Submitted by Jimbo on Fri, 10/31/2014 - 01:52

The AFIH Table - Maintenance order header - tends to be a large table for many companies. It could be that the system is simply overloaded while caching all of this data in RAM.

One way to reduce the amount of memory needed is to select the desired output fields; it may not be necessary to extract the free-text fields like DEVICEID (40 bytes), ADPSP (40 bytes) or UII (72 bytes).

Additionally, it may help to define a where clause and filter the data by date, plant or work center.

Update: The RFC_READ_TABLE function first written 17 years ago received an update in 2019. Now it can read massive tables in smaller chunks by using a simple offset and length system. This will also prevent the System_Failure message by not overtaxing the SAP system's RAM and can be downloaded as part of Jimbo's VBA Automation Toolbox from the Downloads page.