Skip to Content

Issue in FCC

Hi Experts,

I have a structure with Header,1,Detail,*,Trailer,1 with key field values H,D,T respectively which are configured in a SFTP sender channel.

When processsing the input file as below

H,ABC,001,SSS,DDD

D,FFF,0001,DDD,1234

  ,SSS,0002,DDD,1234  (Missing Detail key field value 'D')

D,RRR,0003,DDD,1234

T,XYZ,END

Then the output file is coming only with 2 detail items without any error where as we have a condition that if "D" is missing then file should be discarded.

To discard the file we have condition in our mapping, but problem is, sender communication channel it self skips this row and sending a complete file to message mapping, so we are not able to identify this in message mapping.

I have to populate the error message that there is no Key Field value for the 3rd line Line Item in the end to end execution. Please suggest me the solution for this with out hampering the source and target structures.

Below is the screenshot of my FCC.

Displaying image.png

Thanks.

Farooq

2.png (4.9 kB)
3.png (4.0 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Jun 08, 2015 at 10:55 PM

    File content conversion is not possible with SFTP Channel, However you can use the MessageTransformation Bean

    https://scn.sap.com/thread/3263334       Please go through Grzegorz reply

    https://scn.sap.com/thread/3376411       Please go through Srinivasan answer.


    Regards,

    Saiyog

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Saiyog,

      Thanks for your response. I have used message transformation beans only. I have enclosed the screenshots. My problem is with the the keyfield value missing in the source file then its been skipped and processed.

      Require suggestions on that.

      Regards,

      Farooq

  • avatar image
    Former Member
    Jun 13, 2015 at 07:59 AM

    Hi Farooq,


    <<To discard the file we have condition in our mapping, but problem is, sender communication channel it self skips this row and sending a complete file to message mapping>>




    In my opinion it does not skip the particular row. Instead it takes the detail/item structure as one complete row, and this is the reason why the complete file is being passed through even when "D" is missing.


    So, please use xml.Item.endSeparator with value 'nl'.


    In that case it will take the different rows and stop the file from being sent in case "D" is missing.


    Regards,

    Souvik

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 16, 2015 at 12:10 PM

    Farooq,

    You can try below solution. Then, in UDF (if line does not start with D), trigger alert or perform some action.

    Flat file to deep XML - using an UDF

    How to send Alerts using UDF or JAVA Mapping

    Add comment
    10|10000 characters needed characters exceeded