SFTP FCC Issue in PO7.5

[Former Member]

Hello Experts,

My scenario is something like that

I have following set of records with 1 and 2 as the prefix like

1absnsmsmsm

2absbsnsnsns

1absnsmsmsm

2absbsnsnsns

2absbsnsnsns

1absnsmsmsm

2absbsnsnsns

2absbsnsnsns

2absbsnsnsns

For every set of 1 and 2 one message should be created. Means here in the above payload , for 3 sets 3 messages should be created. Its working fine with FCC in FIle adapter in Dual stack.In PO7.5, I am trying to do FCC but getting the error as

Exception:received.java.langNullPointerException.

Tried with Beans in SFTP  instead of FCC. Its picking the file correctly without any error but not splitting it into messages as per the number of sets in the payload as explained above.

Can you please help me fix this? Its the show stopper for us.

Appreciate quick help.

Thanks in advance

[bhavesh_kantilal]

Are you using a File Adapter or a SFTP Adapter?From your question it looks like you are using FileContentConversion and that works and when you use SFTP Adapter with MessageTransformBean it does not split the records.

If that is the case, it is the expcted behavior. MessageTransformBean does not support "RecordsetsPerMessage" options. Check this link that describes what is supported and what isnt.

http://scn.sap.com/docs/DOC-58321

Regards

Bhavesh

[Former Member]

Hi Bhavesh,

Thanks for a very quick reply. I am using SFTP with Message Protocol as FCC.

I could learn from the blog you provided that MTB is not supported in SFTP and FCC can be used in SFTP just like the way we use it in File adapter.

But here even after using the SFTP with message protocol as FCC and mentioning the RecordSet  Per Message 1 the splitting is not happening and everything is coming under one message.

Really appreciate valuable inputs from you. This issue has become the show stopper for us and need to get it fixed in a few hours.

Thanks in advance

[bhavesh_kantilal]

I could learn from the blog you provided that MTB is not supported in SFTP and FCC can be used in SFTP just like the way we use it in File adapter.

Actually this is the other way around. SFTP Adapter does not have any direct File Content Conversion Parameters. To perform File Content Conversion in the SFTP Adapter you have to use the MessageTransformBean and the Message TransformBean does not support recordsetspermessage.

Why don't you change your logic in the mapping layer, where you perform a 1: N mapping split as a multi mapping?

Regards,

Bhavesh

[Former Member]

Hi Bhavesh,

Thanks once again for a very quick reply.

Actually this is the other way around. SFTP Adapter does not have any direct File Content Conversion Parameters. To perform File Content Conversion in the SFTP Adapter you have to use the MessageTransformBean and the Message TransformBean does not support recordsetspermessage

Does it mean FCC is not possible to split the message per recordset using FCC in my scenario and the only work around is doing a multi mapping? If possible at channel level is there is any parameter other than RecordSetPerMessage in FCC parameters or any other work around?

Thanks in advance

[bhavesh_kantilal]

• There is no means to do this on a SFTP Adapter other than use a Multi Mapping
• Another alternate could be to build a SFTP to File ( NFS ) Pass Through Scenario and then have another File Adapter with Regular FCC and Recordsetspermessage.
• I would prefer using multi mapping though as the alternate is a solution with multiple point of failures..

Regards

Bhavesh

[Former Member]

Totally agree with you and  thanks once again Bhavesh.

Can you please give a pointer on how to achieve it using multi mapping? It will be of great help.

Thanks in advance

[bhavesh_kantilal]

• In your mapping change, go to Signature Tab and change Target Message Occurrence to 0..unbounded
• Your Root Node will now have a occurence of 0 .. Unbounded.
• Map the Recordset to this Root Node.
• Likewise change the occurence of Operation Mapping - Target Service Interface to 0..unbounded
• In Integration Directory make sure your Operation Mapping is re selected in your ICO to reflect the 0..unbounded

Regards

Bhavesh

[praveen_sutra]

Hi Bhavesh,

I would like to add a quick information. Now the SFTP adapters support FCC. I think its support pack 4 and above.

hope this helps.

thanks and regards,

Praveen T

[Former Member]

Thanks Bhavesh and Praveen.

I am trying to use FCC in SFTP but getting the error  Exception:received.java.langNullPointerException.

While there is no message split if I use MessageTransformBean.

So can I say that my requirement of splitting of message that is message per recordset in the payload is not possible in SFTP ?

Appreciate advise. I am really running our of time . Need to fix it ASAP.

Thanks in advance

[Former Member]

Hello Experts,

Any help on this please?

Thanks in advance

[bhavesh_kantilal]

Thanks Praveen, wasnt aware of this! On a 731 SP 06 server and hence cant upgrade either

Regards

Bhavesh

[former_member182412]

Hi Bhavesh,

If you are taking about SFTP adapter, you can update SFTP adapter to latest service pack for any PI version, it is not depend on PI version.

Your PI 3.1 SP06 can update SFTP adapter service pack 04.

Regards,

Praveen.

[bhavesh_kantilal]

Hi Praveen,

Unfortunately the Compatibility Matrix from SAP says SFTP SP 04 is only supported from PI 731 SP 07 onwards..

SAP Note: 1695563

[former_member182412]

OK Bhavesh I did not know about this restriction, i am on SP 14 and installed SFTP SP04, thanks for this note.

[Former Member]

Thanks a lot both Bhavesh and Praveen.

This means FCC is supported in SP04 onwards but does is support splitting of the messages as per my requirement that is, for example, if there are 10 records in the payload then 10 messages should be created.

Does SP04 supports this functionality? If yes, then how can it be achieved at channel level?

Appreciate your valuable inputs.

Thanks in advance