on 11-15-2018 11:49 AM
Hi SAPiens,
I am using SFTP receiver channel with write modus as Use Temporary File.
However, for some of the files are not fetting converted from .tmp to .csv while some are getting successfully converted.
How to fix this issue?
BR,
Rashmi
Hi Muni/ Pavan,
I see in communication channel, below write modus there is timeout error set as 30sec...
Can it be possible PI trying to write temp file and time exceeded by 30sec and that why files got stuck in temp status?
Regards,
Rashmi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Rashmi,
The issue may occur while PI channel still writing into .tmp file and connection to SFTP server lost during that time because of that it failed to convert into actual file and may still remain into as .tmp file
For more analysis you can take the log from SFTP server team and look into exact time of log on basis of time where you encountered this error
javax.resource.ResourceException: 4: Moving xxx.csv.temp to .csv failed
Regards
Pavan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
it is worth checking with SFTP server team/admin and ask them to analys SFTP server log files if possible
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Manoj,
The issue to to convert temp file to .csv files..... Few files are getting posted succeessfully while few files are getting stuck with .tmp file...
- Rashmi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Rashmi,
Looks like an authorization issue, ask the server guys to provide read/write/delete authorization ( if possible:0777)
Br
Manoj
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
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.