Problem in Simple file to file scenario

[Former Member]

Hello,

I am new to SAP PI 7.3. I am doing a simple file to file scenario. The source file contains key,name,id,gender,role & location field. I have done a simple mapping to create the same file in the target side. I have done all the configuration in ESR & ID.

But the problem is that in the target file ( Destination File ) i am getting only key field and the other fields are missing.

Note: In communication channel monitoring, the communication channel is functioning properly and in message monitor also, the status is 'delivered'.

The source payload also contains all the fields correctly. In message mapping (in ESR) also, the target payload is also generating correctly. But in the destination file I am getting the key field only and the rest fields are missing.

Can you please suggest me what to do and where is the problem?

Thanks & Regards,

Moumita

[Former Member · Accepted solution]

Hello,

Do u have any MT name above Record node? If yes, then u have to change ur structre little bit. Check my reply in the thread pasted below.

BTW, if i am not wrong Iñaki has also suggested the same.

Thanks

Amit Srivastava

[Former Member · Accepted solution]

Hi Amit,

I have changed the structure according to your opinion. Now the structure is like this:

<MT_Name>

    <Record>

       <Detail>

             <NameA>nameA</NameA>

             <NameB>nameB</NameB>

       </Detail>

    </Record>

</MT_Name>

Still I am facing same problem. Please give me suggestion what to do next.

Thanks & Regards,

Moumita

[Former Member · Accepted solution]

Hi Moumita

You can change your structure like below and then see if it works or not

<MT_Name>

           <Detail>

             <NameA>nameA</NameA>

             <NameB>nameB</NameB>

       </Detail>

</MT_Name>

[Former Member · Accepted solution]

Hello,

I think u got me wrong, if u see my reply in the thread which i have pasted above u will notice that i had suggested to reduce hierarchies, so in ur case u have to use structure something like this:

<MT_Name>

    <Record>

             <NameA>nameA</NameA>

             <NameB>nameB</NameB?

    </Record>

</MT_Name>

Change the same and let me know ue results.

Thanks

Amit Srivastava

[Former Member · Accepted solution]

Hi Amit/Indrajit,

Thank u very much. I have followed the structure defined by you and the problem is resolved now.

Thanks & regards,

Moumita

[former_member680603]

Hi Moumita,

For FCC on receiver there is no need to provide field names.

try the below configuration for receiver channel FCC

[iaki_vila]

Hi Moumita,

You said:

I have done a simple mapping to create the same file in the target side. I have done all the configuration in ESR & ID.

If you want the same file in he target, you dont need any ESR development, neither a FCC conversion. Check this link: SAPTechnical.COM - File-to-File Scenario without creating Repository Objects

regards.

[Former Member]

Hi Moumita

Are you using any content conversion on receiver file adapter?

If so please provide the screen shot so that we can have a look.

Also please make sure that you have the updated map in the system run-time.

Do a cache refresh in ESR.

[Former Member]

Hi Indrajit,

yes I am using content conversion on receiver file adapter. Screenshot is given below.

Thanks & Regards,

Moumita

[anand_shankar10]

share your flat file on whcih you are doing content conversion.

I understand you are doing this for learning/POC.

regards

[Former Member]

Hi Anand,

This is the source file.

Thanks & Regards,

Moumita

[Former Member]

Hi Moumita

Your FCC looks perfect. Can you please provide the screen shot of your target message structure and the output xml generated from message mapping.

[iaki_vila]

Hi Moumita,

Your mapped XML should be in this way:

....

<Details>

    <key>value1</key>

   <name>value2</name>

...

</Details>

Regards.

[Former Member]

Hi Indrajit,

screenshot of the target message is given below:

Thanks & Regards,

Moumita

[Former Member]

Hi Indrajit,

Sorry. Actually the previous one is source payload. Screenshot of the target message is given below.

Thanks & Regards,

Moumita

[Former Member]

Hi Moumita

Clearly field names are wrong in FCC and hence your file is not having all the fields.

Correct filed names are

Key,Emp_Name,Emp_id,Gender,Designation,Address

[Former Member]

Hi Indrajit,

I have done one mistake. Actually the first sreenshot is of source payload and the second one is the target message.

Thanks & regards,

Moumita

[Former Member]

Hi Moumita

FCC looks perfect as per the target structure. Not sure why you are not receiving other values.

Can you please provide the screen shot of the file generated ?

[Former Member]

Hi Indrajit,

I am getting this file. (Target File)

Thanks & regards,

Moumita

[Former Member]

Hi Moumita

Just remove the content conversion from receiver file adapter and save the xml file.

See whether you receive the xml file with all details or you are missing the fields there as well.

[Former Member]

Hi Indrajit,

>>Just remove the content conversion from receiver file adapter and save the xml file.

Yes I am getting the xml file with all the details.

Thanks & Regards,

Moumita