Message transform not converting flat file to xml

[Former Member]

Hello Experts,

I am using a sender SFTP Adapter and I have used message transform bean in the sender channel.

My csv file has a structure like below.

UserID,User Name,Closing Balance,Product Name,MSISDN,Product Code

DLRT0000333153,test_13438,500,ETOPUP,7428073437,101

DLRT0000334098,test_14383,500,ETOPUP,7428074382,101

DLRT0000333172,test_13457,500,ETOPUP,7428073456,101

Please find the screen shot below.

The thing is the file is picked from the sender channel but the conversion is not happening.

Can you please let me know where I have gone wrong.

I am getting no error in the channel level

Regards

Advit

[engswee · Accepted solution]

The parameter for Transform.Class has a typo error (written as Tansform.Class without the "r"). If you see the log, it shows that it's using an $identity transformation (i.e. no change) because the conversion class was not found.

[bhavesh_kantilal · Accepted solution]

Ha, I need to get my eyes tested

[Former Member · Accepted solution]

Me too.

Now after changing that I am getting a channel error.

Screen shot for your reference..

Regards

Advit

[Former Member · Accepted solution]

No worries.

I used com.sap.aii.af.sdk.xi.adapter.Conversion and it worked ..

Regards

Advit

[bhavesh_kantilal]

Hello Advit,

How do you conclude that the conversion is not happening? The configuration looks Ok so I am trying to understand if the issue is with the Content Conversion or elsewhere?

Also - are you sure the File is getting picked by the Right Channel with the Content Conversion Modules or is getting picked by someother channel.

Can you share the Logs of this Message being processed?

Regards

Bhavesh

[Former Member]

Hi Bhavesh,

The message is failing at the mapping level because it is not converted to XML .Please find the screen shot attached.

Regards

Advit

[bhavesh_kantilal]

The screen shot does not show the mapping logs.

Can you share - your Message Type screen shot so we can check this with the configuration and see what is different?

What I think is happening is : something in your MessageType does not match the Configuration and hence the issue in the mapping.

Regards,

Bhavesh

[bhavesh_kantilal]

Also, check the Input Payload in your PIMonitoring. Is it the same as expected by the payload when you generate through your mapping editor?

[Former Member]

The input payload is in csv format itself .That is the reason it is failing .In SXMB_MONI when I check inbound message payload ,I see it in CSV format itself.

Please find the screen shot below.

Regards

Advit