Skip to Content
0

SAP PI 7.31 Dual stack Message Transform Bean Issue

Jan 24, 2017 at 09:22 AM

111

avatar image

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

pi
10 |10000 characters needed characters left characters exceeded

Can you please share the FCC screenshots

Br,

Manoj

0

Hi Manoj,

Thank you for taking a look at my issue. Please find the snapshots below:

mtb-1.jpg (126.2 kB)
mtb-2.jpg (79.4 kB)
mtb-3.jpg (23.0 kB)
0
* Please Login or Register to Answer, Follow or Comment.

2 Answers

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

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.

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Hi Jeenath!

Wouldn't you please clarify further, how would you get xml structure like:

<Header>

....

</Header>

<LineItem>

...

</LineItem>

using SimplePlainToXML?

Regards, Evgeniy.

0
Arkesh Sharma Jan 26, 2017 at 02:40 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded