EXPORT/IMPORT using DATA BUFFER

[prabhu_s2]

Hi

In a current process, there are around 500K records exported and imported to data buffer. While this works most of the time, occasionally we see failure in the job that implements export/import process. the job runs into HOLD status with reason SLEEP which I think is of resource bottleneck. I couldn't discard the reason of this error linked to the way how EXPORT/IMPORT is used.

Keeping the existing process of export/import to data buffer unchanged, how do I clear the data buffer?

Below is the code I have for import:

IMPORT p1 = lt_matl FROM DATA BUFFER iv_buff .

After the import how i can reset or clear the buffer iv_buff. FREE MEMORY ID results in syntax error as iv_buff must be a character type field.

1. Any suggestion on how to clear the data buffer ?
2. Is there any limitation on using IMPORT/EXPORT using DATA BUFFER for large volumes of data?

[matt]

If FREE MEMORY ID iv_buff fails due to iv_buff not being a character field, that would indicate to me, that you need to make it a character field. What is its type?

[prabhu_s2]

it is a RAWSTRING

[matt]

Ah, I see it now:

Spot the difference.

1. IMPORT p1 = lt_matl FROM DATA BUFFER iv_buff .
2. FREE MEMORY ID iv_buff

1 puts information into a data buffer

2 frees a memory id.

Quite different things. Why would you expect it to work?

Try: clear iv_buff.

[Sandra_Rossi]

If it's really IMPORT which makes the workprocess hang forever, then it's abnormal (it should just fail) and you should check if there are patches to correct that, or contact the SAP support if there are none.

[prabhu_s2]

thanks Sandra .... what I missed to include in the post is the import is performed within a submit job in background .... currently I could see there are atleast 140 jobs created

[Sandra_Rossi]

Ouch. 500 thousand lines * 140 jobs, that's a huge amount of memory! Because there is first the IV_BUFF variable which contains the compressed data, and you uncompress it into LT_MATL. PS: in that context, "DATA BUFFER" just means that the compressed data is inside the variable (IV_BUFF). Clearing the variable clears the "data buffer".