on 09-18-2009 2:29 AM
Hi ,
I'm processing a CSV file which is 30MB... after converting into XML , it is failing in SXMB_MONI with error ""Request Entity too Large Error " .
We are trying to increase the size of the "MaxRequestHeadersLength" as someone suggested in the below thread.
Intially it has 16,480.. I increased to 25,000 , still it is failing..
ANy suggestion how much I need to increase in this setting to handle around 30MB files? which after converting into XML.. it has size of around 200 to 250MB .
Or is there any other way I can handle this error?
Thanks
Deepthi
Hi,
When you working one ane scenario first you have to design what is the best approach..In your case you are trying to send 30mb file at a time,how you think that PI will work fine???
Try to split the file in to samller pieces,how you will do this is use java code to split the file,then try to send it.
Previously i had faced same situation,sending huge flat file ,i had writen on Java Mapping to split the file.
try to use Recordset per message opetion in File Adapter,i hope it will work it out.
Regards,
Raj
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks guys for your replies.
After going through your answers, I decided togo for splitting the file before mapping and appending the whole data at the receiver file adapter.
Hi Raj,
>> Previously i had faced same situation,sending huge flat file ,i had writen on Java Mapping to split the file.
>> try to use Recordset per message opetion in File Adapter,i hope it will work it out.
If possible, Please expand this one step by step . ANy reference blog will be helpful
Thanks
Deepthi
After going through your answers, I decided togo for splitting the file before mapping and
appending the whole data at the
receiver file adapter.
Check this blog: /people/sravya.talanki2/blog/2005/11/29/night-mare-processing-huge-files-in-sap-xi
Actually a bunchful of methods are given here...inlcuding the above one:
Regards,
Abhishek.
Hi ,
Can someone please explain how to split the file in FCC.
ACcording to the below blog, they suggested to use Recordspermessage in file adapter. But it is not working for me.
Is there anything I need to do apart from that "Recordspermessage" parameter?
Thanks
Deepthi.
Edited by: deepthi reddy on Sep 18, 2009 7:38 AM
HiDeepthi,
Please provide the source structure, It should be of this format for recordsetpermessage to work
<documentName>...
<recordset>
<NameA>
<field-nameA1>field-value</field-nameA1>
<field-nameA2>field-value</field-nameA2>
<field-nameA3>field-value</field-nameA3>
</NameA>
<NameB>
<field-nameB1>column-value</field-nameB1>
<field-nameB2>column-value</field-nameB2>
<field-nameB3>column-value</field-nameB3>
</NameB>
</recordset>
...
<recordset>
...
</recordset>
</documentName>...
Also check this url http://help.sap.com/saphelp_nw04/helpdata/en/2c/181077dd7d6b4ea6a8029b20bf7e55/content.htm
Regards
Suraj
A slight change in the mapping and "Recordset per message" operation in File Adapter helped the problem.
Thanks guys for your help.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
It also depends upon the hradware configurations you are using and compatibility of high volume data. So usage of "MaxRequestHeadersLength" is not only sufficient but also look for other alternatives such as split the files in samller chunks, try setting up try parameter EO_MSG_SIZE_LIMIT in SXMB_ADM etc.
Refer - section 3.2.9
Hardware config such as ( Java Heap etc ) to make sure that XI can handle this file ( not recommended though). SAP recommends a size of 5 MBas the optimum size.
/people/pooja.pandey/blog/2005/10/17/number-formatting-to-handle-large-numbers
Thanks
Swarup
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.