Error Calling R/3 to get table data

dataservices sap-erp-bw
1 
Error Calling R/3 to get table data: <DATA_BUFFER_EXCEEDED This operation attempts to extract more than the 512 bytes per row that the R/3 table source can return. To avoid this error, reduce number of columns that the source extracts.>>

sjain :india: (BOB member since 2009-04-17)

2

Hi,
if you are using an R/3 Workflow, inside this R/3 you should use a Query transform where you have to define and mappe only the fields that you need.

Greets

youbel (BOB member since 2009-12-15)

3

You are reading a wide table via the RFC_READ_TABLE method of DataServices, meaning you pulled that table directly into the dataflow, but you should use ABAP dataflows for large volumes.
Or you are doing a data preview - clicking on the magnifying class.

Both functionalities use the SAP provided RFC_READ_TABLE function module which has a relatively small buffer width. So we provide you with a version of the RFC module called Z_AW_… and if you install the DataServices provided SAP functions, this limitation is gone.

Werner Daehn :de: (BOB member since 2004-12-17)

4

Yes, we are Viewing Data in the Datastore itself. sorry i ddn’t mention.

Thanks for your valuable suggestion. so function "Z_AW_… " will overright the “RFC_READ_TABLE” this function.

sjain :india: (BOB member since 2009-04-17)

5

Almost. DataServices does always check if there is a Z_AW_… function and if not, falls back to the SAP provided functions.

Werner Daehn :de: (BOB member since 2004-12-17)

6

@Werner,

We have upgraded the DS 3.1 version to 4.0 and the main source for us is SAP R3 systems .

When we run the job in DS4.0 against R3 source systems ( the same job which used to run in DS 3.1 version ) , the job completes sucesfully but wit lot of warnings on z_AW_* functions for version mismatch . PFA attached detailed error message .

But when we compared the Z_AW_* functions in SAP R3 source systems , there are of proper version 6.5.1.0 . Any inputs to avoid these warnings ?

thanks in advance

Thanks,
Rani
Error.jpg

rani_cts (BOB member since 2008-06-05)

7

I have asked my developer, he is out until 26th.

There are two parts playing a role here:

the function Z_AW_GET_VERSION crawls through all functions and tries to find a FORM of the name xxxxx_GETV inside each function.

These forms of each function are then called and should return a proper value.

When I look at my install of DS 14.0, the Z_AW_GET_VERSION has O_DI_VER=‘6.5.1.0’ set and each function like Z_AW_TREE_PROF has at the very bottom the lines
FORM Z_AW_TREE_PROF_GETV …
VERSION=‘6.5.1.0’.
ENDFORM.

Werner Daehn :de: (BOB member since 2004-12-17)

8

Hi Werner,

Thanks for the quick response .

when we try to check the z_* function version in SAP R3 system , we also get the same message which you have given .
PFA “Version.jpg” screenshot

:hb:

Regards,
Rani
Version.jpg

rani_cts (BOB member since 2008-06-05)