Skip to Content

SAP PI SFTP - javax.resource.ResourceException: 4: Moving xxx.csv.temp to .csv failed

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

5 Answers

  • Nov 15, 2018 at 12:25 PM

    Hi Rashmi,

    Looks like an authorization issue, ask the server guys to provide read/write/delete authorization ( if possible:0777)

    Br

    Manoj

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 15, 2018 at 12:28 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 16, 2018 at 06:26 AM

    it is worth checking with SFTP server team/admin and ask them to analys SFTP server log files if possible

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 16, 2018 at 06:56 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 16, 2018 at 08:25 AM

    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

    Add comment
    10|10000 characters needed characters exceeded