on 07-31-2012 11:53 AM
Hi Folks,
I am working on SFTP(File) to SFTP(File) interface in sandbox system. File(Txt) is sending data in ~ format to target system .we are using a new approach ~ here.
i tested with following files in sandbox
1.xml to txt----successfull
2.txt to xml----successfull
3.txt to txt---unsucessfull
PI able to pick file and placing the file in target server but data is not populating .In target file the data is displaying only ~~~~~~ like this.
I checked in moni i can see the payload overthere.but in target system data is not coming.
Sender FCC
Receiver FCC
In output directory i am only getting this
Hi Muni,
Everyone here is correct in saying you could do this without any mapping steps.
However, you should also be able to make this work with mapping. You are obviously very close to making this work because in your output file you are getting 4 delimiters but just the content is missing.
If you look at your source payload in moni, right click, view source, copy this payload and paste it into your design mapping, test tab (source view).
Then switch back to tree view which will parse your test input and verify your input message structure versus what your map expects.
Now is your root node red or green? Sometimes you could run into a root level message name difference that keeps your payload from being recognized in the map.
If you run this test and get output, you know the problem is something trivial in the output FCC parameters. However, if you run this test and get empty results, you may have a message type mismatch on your input FCC parameters and your sending message type.
Regards,
Aaron
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Are you not seeing error in any of the pipeline steps? Also I want you to see in the receiver communication channel to find more details on this error. The error could be due to mapping area or invalid conversion parameters specified on the receiver channel. Provide more details on the target structure side.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Baskar,
Thanks for the reply...
I am not getting any error in pipeline steps...the above screen shots mentioned both sender & receiver fcc.
Mapping is fine..Source and Target structure is same.
SOBID,FEEDERCODE,TRANSACTIONCODE,CONVERSIONTYPE,CURRENCYCODE
In receiver Fcc i mentioned like this
Recordset structure : Row
Row.fieldSeparator:~
Row.fieldNames:SOBID,FEEDERCODE,TRANSACTIONCODE,CONVERSIONTYPE,CURRENCYCODE
Row.endSeparator:'nl'
any other things need to add in receiver fcc.Correct me if i am wrong
Hello!
Is this structure hierarchical or plain row? Anyway, try checking the wiki page below for some reference on the receiver FCC configuration:
http://wiki.sdn.sap.com/wiki/display/XI/FCC+For+Hierarchical+Structure+in+Receiver+Channel
Hope it helps.
BR,
Lucas Santos
If your source and target structure is same and no mapping involved then why do you use file content conversion. Is that right? You dont need ESR objects at all. Just configure ID objects and do simple pass through scenario itself.
Hi Baskar,
Thanks for the reply..
I agree with your answer but pi undesrtands only xml files in that case no FCC...
But here .txt(~) to .txt(~format) so for this we need FCC..correct me if i am wrong..
In this case in fcc what are the things i need to do..
Recordset structure : Row
Row.fieldSeparator:~
Row.fieldNames:SOBID,FEEDERCODE,TRANSACTIONCODE,CONVERSIONTYPE,CURRENCYCODE
Row.endSeparator:'nl'
>I agree with your answer but pi undesrtands only xml files in that case no FCC...
That is not true. Here you dont need any conversion. You DONT need ESR objects. Just do ID objects and follow the blog I have shown in the above reply. PI can also be used to handle other file types like binary, zip, gif etc.
Hi Baskar,
I removed FCC both sender & Reciver CC,now file is not getting placed getting below error.
<SAP:Category>Application</SAP:Category>
Hi Muni ,
The following link might help you.
http://www.saptechnical.com/Tutorials/XI/File2File/Demo1.htm
Regards
Gagan
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.