on 10-03-2013 10:25 AM
Hi,
I am having a scenario of File to Idoc interface. A .CSV format file is placed in a folder in FTP server. If the file is processed successfully by PI, the file will move to archieve folder in FTP server.But it is not happening in my case. File is not getting processed and posting to ECC. Instead, file is moving into processed folder.
If the same file is saved and placed in FTP server then the file is getting processed and message log can be seen too.
Kindly help me out to resolve this issue.
Thanks & Regards,
Madhuri.
Hello Madhuri ,
Try to increase your polling interval . This will decrease the possibilty of failure. If you are sure about the timings of the files to be placed in a day then you can use AAT- adapter availability timings feature. By this start the channel only after your files are placed and written.
Thanks,
Gaurav Ranjan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Madhuri,
There seems to be difference in file format which is being put in FTP server. Here is the explanation: Please check in which operating system the file is being created? Then check out the operating system of the FTP server. Say for example the file is created by business user in windows OS and being put in FTP server which is in unix. There is a file format difference between the two operating system. Windows uses "\r\n" as line ending where as unix/linux uses "\n" as line ending.
Check this for more information http://www.cs.toronto.edu/~krueger/csc209h/tut/line-endings.html .
When the file is saved in FTP server the file format is converted into format as expected by operating system used in FTP server. This what I feel is the source of the problem. Under FTP Connection Parameters in sender file adapter there is a parameter called Transfer Mode. Try setting this to binary .
That might perhaps solve the problem.
Regards
Anupam
Hi Madhuri,
I mentioned difference in file format , did you check with business on that??
In case you find the reason perfectly matches my explanation above, I feel,the problem cannot be resolved from PI end. The Business needs to provide correctly formatted file to PI adapter. Please wait for experts to respond on the same.
Regards
Anupam
Message was edited by: Anupam Ghosh
Hi Madhuri,
Write a small script in PI server. The script will copy files from source directory ( from where PI is trying to read currently) and would save the file in same FTP server in a different directory(T) . If the operating system of the PI server is UNIX/LINUX, then you can use following link to write a script. In case the PI server is on windows platform then you please check this link http://support.microsoft.com/kb/96269. Put the script path in run OS command before processing in sender FTP adapter. PI will try reading the file from directory T. This will eliminate the problem of file incompatibility. The script can be written in FTP server itself but then this has to be taken care by other team responsible for maintenance of the FTP server.
"How to check whether the file is compatible with PI?"
The file is definitely compatible with Pi as after saving the file PI can read it.
Regards
Anupam
Hi Madhuri,
please ask Basis to check the permissions on the file. Should be file mask 777.
Ambrish
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
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.