Skip to Content
0

FCC in SFTP adapter not working

Jun 15, 2017 at 10:43 AM

357

avatar image
Former Member

Hello Experts,

Currently I am working on SFTP adapter. The same configuration is working fine for FTP adapter.

Below is my structure.

<Record> (1..1)
<Header>(1..1)
<Imp/> (1..1)
</Header>
<Item>(1..unbounded)
<Data/>(1..1)
</Item>
</Record>

Recordset structure in channel : Header,1,Item,9999

FCC parameters :

Header.fieldSeparator 'nl'
Header.fieldNames Imp
Item.fieldSeparator 'nl'
Item.fieldNames Data


In SFTP i am facing below issue (error is highlighted in bold):

Recordset structure
1. Header,1,Item,5(exact number of line item from sample file) : interface is running fine.


2. Header,1,Item,* : Exception received: com.sap.aii.adapter.sftp.ra.rar.conversion.exception.ParserException: Record type: Header missing in the end of the file


3. Header,1,Item,9999 : Exception received: com.sap.aii.adapter.sftp.ra.rar.conversion.exception.ParserException: Record for segment:Item not found

Can anybody help me with this??

Regards

Ankyy


10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

6 Answers

Manoj K Jun 19, 2017 at 03:41 PM
0

Ankyy,

Please check Below :

If the below FCC dosn't . Please check for the patch as suggested .Below Example is tested with File Adapter.

Br,

Manoj


input.png (9.5 kB)
fcc.png (14.1 kB)
out.png (16.3 kB)
Show 3 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Thanks Manoj.

This is working for FTP adapter but i am getting error in SFTP adapter.

Error : Exception received: com.sap.aii.adapter.sftp.ra.rar.conversion.exception.ParserException: Record for segment:Item not found

Regards

Ankyy

0

Then it should be the Patch Issue i believe. Why don't you try with MTB as mentioned in your other thread.

0
Former Member
Manoj K

Yes, i am working on the same.

0
avatar image
Former Member Jun 20, 2017 at 12:05 PM
0

If you have deployed SFTP PGP Add on 1.0, then it should work fine.

Anyway, try once putting additionally below -

igoneRecordSetName = true

Header.endSeparator = 'nl'

Item.endSeparator = 'nl'

If still the issue will be there, then you should definitely check the patch level and talk to SAP or else you can use MessageTarformationBean to do the FCC

Thanks,

Apu

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

I have already tried using above parameters, it didn't work.

Also tried with Bean, still no luck.

0
Luis Felipe de Barros e Silva Jun 19, 2017 at 12:47 PM
0

There may be some bugs on the SFTP adapter. Which SP/Patch Level are you on?

You can check a workaround on: https://archive.sap.com/discussions/thread/3959970

Or maybe you need to update your system according to SAP Note 2144272 - SFTP Adapter Support for Large File Handling and Content Conversion.

Regards,

Luis

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

I am working on PO 7.5, SP 04.

I have already checked above link and i am working on MTB, but that is also not giving desired output.

Regards

Ankyy

0
Evgeniy Kolmakov Jun 19, 2017 at 12:57 PM
0

Hi Ankyy!

In case of recordset with "*" occurence I guess, that you shoud define keys for recordsets.

Regards, Evgeniy.

Show 2 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Evgeniy,

I have already tried defining Key but i am getting same error.

Regards

Ankyy

0

And what is the full set of your FCC parameters?

Regards, Evgeniy.

0
Raghuraman S Jun 20, 2017 at 12:24 PM
0

Can you try once using Module Beans?

we also faced similar kind of issues that's because of bug in SFTP adapter FCC.

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

i have tried with Modules beans.. but no luck.

0
avatar image
Former Member Jun 28, 2017 at 11:17 AM
0

Hello All,

We actually changed Data type structure and little changes in mapping. Interface is working now.

Thanks for your help.

Regards

Ankyy

Share
10 |10000 characters needed characters left characters exceeded