MappingException: 204

[Former Member]

Hello Gurus,

I am trying to process the large files > 500 MB and using EOIO QoS with File splitting active and using AAE. The issue is when I process the XML file with few records it goes through, however, when I use the large XML file > 300 MB I run into error Failed to execute: MappingException 204. Also I am using smaller file it processes

However, the larger file goes to Waiting and then to Holding status with the error below. I also have the EO_MSG_SIZE_LIMIT set to 2097151. And in the Sender File Adapter File Splitting Maximum Size of File part set to 1 MB.

Really appreciate for your valuable inputs on this issue.

[Former Member]

Hello Gurus,

I am processing large file ~ 500 MB XML using the chunk mode process. The file is logically chunked however, the payload is not structured with complete set of records as the source file is a XML file. Meaning if I have set the chunk size 512KB, the chunk does not hold complete records and chunk ends part of XML record (inbetween record). However, the chunk process itself works fine and the chunked file is created.

The other issue is  when I process the above chunk file using other interface I get the the error "Transmitting the message to endpoint <local> using connection File_http://sap.com/xi/XI/System failed, due to: com.sap.aii.af.service.mapping.MappingException: 204". I need to use the chunk file to post to BW system using ABAP proxy. The mapping is very simple and have one to one mapping for 16 fields with no complex mapping.

Also to rule out mapping issues, I tested the message mapping in ESR with a small file and there is no issues.

Please let me know if I need to anything else that I have missed and how I can get the chunk processed.

Really appreciate for your valuable inputs and help.

Thanks Misha

[Former Member]

Folks,

More additional details let me know the configuration details if I need to change, as currently we have JAVA memory heap size is set to 4 GB and SXMB_ADM tuning parameter EO_MSG_SIZE_LIMIT set to 2097151.

I'm looking for some valuable inputs on this issue. Thanks for your help.

[nabendu_sen]

Hi Misha,

What is your PI version? As per my knowledge 'Chunk option' works from PI 7.3 and above.

Check the below discussion:

http://scn.sap.com/message/13140879

If you have also configured in PI 7.1 EHP 1, have you specified "Queue Name'?

Check below blog:

http://scn.sap.com/people/niki.scaglione2/blog/2009/10/31/chunkmode-for-binary-file-transfer-within-...

Regards.

Nabendu.

[Former Member]

Thanks Nabendu, the version is PI 7.3 and I have also specified Queue name as I am using EOIO QoS. The chunk process for the XML works, however, when I run ther other interface to process the chunked file I run into issues.

[former_member184789]

Hi Misha,

AFAIK chunk mode for files can be used only when there are no ESR objects involved. Refer to the limitations section of below blog:

http://scn.sap.com/community/pi-and-soa-middleware/blog/2011/12/26/fileftp-adapter--large-file-trans...

[Former Member]

Adarsh,

I have no issues when I chunk the large file, however, I want to process the chunked file how can I achieve that ?

[former_member184789]

Hi Misha,

I think it will be split into chunks but the individual chunks cannot be processed when mapping is there. Maybe if you remove ESR objects & try to run the scenario, it will work. In the link which I gave earlier, it is written that:

The split never cosiders the payload. It's just a binary split. So the following limitations would apply

• Only for File Sender to File Receiver
• No Mapping
• No Content Based Routing
• No Content Conversion
• No Custom Modules

[Bhargavakrishna]

Hi,

There is some issue with the mapping. Test your message mapping from test tab.

You can also send a test message by copying the payload of failed message from pipeline steps/Moni from RWB to integration engine and see how it is processing.

Also refer this link to process large data in chunks

http://scn.sap.com/community/pi-and-soa-middleware/blog/2011/12/26/fileftp-adapter--large-file-trans...

Define the parameters as per the above guide in file communication channel..

Hope it will helpful..

Regards

Bhargava krishna

[Former Member]

Thanks Bhargava,

I did follow the steps provided in the blog, however, I thought in the receiver file adapter I should see chunk of files created as the Maximum file Size provided in the Sender File adapter. For example, my input file is 500 MB and on the Sender File adapter I have set to 1 MB as the Maximum Size of File part. So I should see physical files created  of 1MB on the app server, instead it is creating the same input file size. I wanted to see the actual file to be spiltted into 1 MB whichs means I should see of size 1 MB for 500 different files.

I don't want them to be combined into 1 file of size 500MB. Please let me know if I have missed anything.

[Bhargavakrishna]

Hi,

Did you set the records set per message option in communication channel?

Refer this link

http://scn.sap.com/thread/0002134948

https://scn.sap.com/thread/1038076

http://scn.sap.com/thread/2153570

Refer baskar reply in the above discussions..

Regards

Bhargava krishna

[Former Member]

Hi Bhargava,,

I am using 500 MB XML file as input file and and in the receiver file adapter it is file based and not FCC.

My other question was, the split functionality does not split into small multiple files (physical files separately). The split functionality chunks them in one file itself to the specified chunk size. My assumption was the split functionality will split into smaller separate files.