Skip to Content
avatar image
Arkesh Sharma

SAP PI 7.31 Dual stack Message Transform Bean Issue

Jan 24, 2017 at 09:22 AM | 125 Views

Hi Experts,

I am trying a simple SFTP to SFTP scenario with FCC on the sender side using message transform bean. The file structure is like HEADER,1,LINE_ITEMS,*

The file is pipe delimited and there is no fixed length for the fields. Initially I was getting some parameter errors that I resolved. Finally, when the file was picked up by the sender channel and transformed, it landed up in error at mapping level with the message "premature end of file". When I try to look at the source payload, it is empty with zero characters in it.

I am unable to understand If the FCC transformation was successful then where did the content of the file go. Kindly help me out in this regard.

I have a simple structure as shown below:

HEADER|2017-01-24|2|123.11|001
LINEITEM|001|2017-01-24|1|Test1|User 1|Std||AB|SYSNO
LINEITEM|001|2017-01-24|2|Test2|User 2|Std||AB|SYSNO

The XML structure in DT I created looks as below:


DT_Source
Recordset
HEADER 0..1
H1
H2....
LINEITEMS 0.. unbounded
L1
L2.....

I have referred to the below links already while creating the module parameters:

https://wiki.scn.sap.com/wiki/display/XI/How+To...Content+conversion+module+with+J2EE+JMS+adapter

http://help.sap.com/saphelp_nwpi711/helpdata/en/44/6713ec3f914ddee10000000a1553f7/content.htm?frameset=/en/44/686e687f2a6d12e10000000a1553f6/frameset.htm¤t_toc=/en/44/658ac3344a4de0e10000000a1553f7/plain.htm&node_id=9

Regards,

Arkesh

SAP Process Integration
pi
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Jan 24, 2017 at 06:03 PM

    Hello Arkesh,

    I think you should try with conversion type as Simple Plain2xml. Because there is no need of multiple hierarchy. One more thing in your message transform bean parameters you mentioned xml.LINEITEMS.keyFieldValue in double quotes ("LINEITEMS") which is not the right way to declare the value.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Arkesh Sharma
    Jan 26, 2017 at 02:40 PM

    Hi Experts,

    The issue has been resolved. The problem lay in the

    xml.HEADER.keyFieldValue = "HEADER"
    xml.LINEITEMS.keyFieldValue = "LINEITEMS"

    The values of the two parameters should not be in double quotes as they were not in the file. This is what was going wrong at my end.

    Regards,

    Arkesh

    Add comment
    10|10000 characters needed characters exceeded