Proxy giving error

[Former Member]

Hi,

We are using proxy to send the data to PI. This is full load everyday and has around 7000 records & we are expecting all records in one XML file ( 7000) of them . Problem is when the abap report sends the data, it errors out because of internal table overflows.

The PI message is

Msg_T

-> Items

--> item01

--> name

--> Address

Now with this, proxy is generating nested (deep structure) and having trouble in filling the values.Is there any way we can solve this issue.

.

Please advice

[Former Member]

Hi,

As for as I know Proxies are ment to handle the large amount of data. There could be some issue in your ABAP code.

1. First of all check your filter crietera.

2. Your select query should not be insde any loop... endloop.

3. You should avoid joins if there are more tables in the select query.

4. Do not put loop inside loop.

5. Try create more internal tables and finally merge them into one final internal table.

6. Now play with this final internal table, to move your data into XI.

Regards,

Sarvesh

[Former Member]

Hi,

7000 lines should not be a problem in a ABAP Proxy. Maybe you shoud get a experienced ABAPer to look through the code. To what are you delivering the payload. JDBC, file or what ever. Because, as suggested earlier in many cases you could devide the payload when sending it and then collect it again on the other side. For file Append, for JDBC just make more insertstatements etc.

Hope it helps

Kind regards

Mikkel

[Former Member]

you can split the file for every 1000 records and send. but this will be multiple files instead of one.

[Former Member]

Thanks for replying. We are not using File adapter but using proxy to push the data. When proxy call is made we are passing full internal table & that's where the error is coming for internal table overflows.

[Former Member]

Hi

nested XML filling should not be a problem. XI is handling the message data type right?

With this if you are facing overflow, For high volume generally we dont implement BPM but using BPM you can collect message and can send only 1000 at a time from proxy to avoid message overflow.

Thanks

Gaurav