SFTP Channel: FCC Module Error (CSVtoXML)

[Former Member]

Hi Experts,

I have Sender SFTP channel with the below FCC module settings configured.

But getting the error during mapping. I am pretty sure that there must be some issue with the FCC module parameters. Kindly correct me where i was wrong. Attaching screenshot.

6.png

CSV File:

Error:

Regards,

Syed

[former_member190293 · Accepted solution]

Hi Syed!

You were suggested to check source payload after FCC. Provided message type structure won't give any information about error.

I just guess that your FCC doesn't produce any xml data, so after it you have the empty message:

<MT_Your_Message></MT_Your_Message>

without any inner elements.

Thus, there is no errors in scenario flow, since message exists (though it's empty), but message mapping raises exception.

Regards, Evgeniy.

[PriyankaAnagani]

Did you check the message payload before mapping to see how the content was converted to XML.? Also, as mentioned by Patrick, the endSeparator is not newline. It can be comma or any other character actually being used in file. Please verify.

--Priyanka

[Former Member]

Thank you Priyanka.. i have changed new line to comma now.

But getting the mapping error.

My input file is CSV which i have attached in my previous thread. Kindly check.

Message is throwing the below error. Please help.

Regards,

Syed

[weberpat]

Hi Syed,

I guess your field separator is not really a new line, so you'll want to adjust that to the one you are actually using. Also the specification of field names in your configuration is redundant when using the "fromFile" option for the processFieldNames parameter but that shouldn't be an issue here.

Regards,

Patrick

[Former Member]

Thank you very much for your reply!

I have changed new line to comma now.

But getting the below mapping error.

My input file is CSV which i have attached.file.txt

Message is throwing the below error. Please help.

Regards,

Syed

[weberpat]

This is no longer an issue with your CSV to XML conversion but a bug in your message mapping. Post a screenshot of the node where the mapping error occurs and ideally the XML representation of your input message so that we can have a look.

[former_member190293]

Hi Syed!

Enable message staging before mapping step, get your source payload from message monitor and use it to perform the test in Operation mapping.

You have mandatory element in target structure which is not created during message transformation.

Regards, Evgeniy.

[xinjiang_li]

Hi Syed,

Try changing the fieldSeparator attribute to '0x09' , the means tab delimiter.

[Former Member]

Thanks a lot Patric/Evgeniy/Priyanka/Xinjiang,

Issue resolved now. Your inputs have helped me alot. Thanks for your time!

Regards,

Syed

[Former Member]

Hi Patric/Evigeniy,

Appreciate your response! PFB the requested screenshot. Pls help.

Error:

CSV file. file.txt