Whitespace is not allowed at this location. Error processing resource in sap pi

[Former Member]

Dear all,

I have developed a custom adapter module to read .xls file and convert into XML. When i test the with the .xls file containing 1000 records, in SXI_MONITOR -> in pipeline steps -> i can view only 5 successfully converted XML records in the payload and at the end it is showing the below error.

Even in the successfully processed message; when i check the target directory, it contains only first 5 records.

The audit log for the same is

Please suggest me the solution if u have come across this kind of situation.

Note:: I am able to see exact first 5 records (XML) in target directory.

Regards

Koti Reddy

[iaki_vila]

He Koti,

Please check the payload, the error seems to be in a XML tag with a space inside, like < Hello>, between < and the H.

Regards.

[Former Member]

Hi Inaki,

Thank you. I have copied each cell onto a notepad and checked it. But i couldnot find any white spaces.

I am refering to this link. 

http://www.w3schools.com/xml/xml_syntax.asp

Can u please suggest me any generic piece of code to handle this in the custom adapter module?

Regards

Koti Reddy

[Former Member]

Is this happening with all the excel or only this?

If possible, Please attach the xml file from the screenshot.

Regards

Osman