SAP-to-File Sceanario-*.tmp files getting ftp'd to target system.

[lnirmala]

Hi all,

My scenario is SAP to File in which we are using proxy at source side i.e ECC.There are lot many files being processed every day and this is the first time we are facing an issue like this.While trying to FTP the file to target system there is an error listed in the RWB but in the first retrial the file got successfully sent to target.But the problem is in the target system an additional file with the name XI_ftp_4a12552a-23d5-02p0-e100-00000a0a0968.tmp is getting created.In RWB the error is listed as

Error Attempt to process file failed with com.sap.aii.adapter.file.ftp.FTPEx: 550 XI_ftp_4a12552a-23d5-02p0-e100-00000a0a0968.tmp: The system cannot find the file specified.

Error MP: Exception caught with cause com.sap.aii.af.ra.ms.api.RecoverableException: XI_ftp_4a12552a-23d5-02p0-e100-00000a0a0968.tmp: The system cannot find the file specified. : com.sap.aii.adapter.file.ftp.FTPEx: 550 XI_ftp_4a12552a-23d5-02p0-e100-00000a0a0968.tmp: The system cannot find the file specified.

File adapter is a simple one in which no advanced parameters are being used.

I have searched the forum but didnt find the exact reason for the ftp for tmp file to target.

Can some one help me in solving this issue.

Any help will be highly appreciated.

Thanks & Regards,

Lekshmi.

[Shabarish_Nair · Accepted solution]

1. clear all *.tmp files in the target folder

2. in the receiver file adapter use the option, Put File -> Directly instead of using temporary files

Put File

If the file is to be created on the server immediately, select Directly.

If the content is to be gathered in a temporary file first before the final file is put on the server, choose Use Temporary File.

[lnirmala]

Hi All,

Could someone please help me in solving this issue.

Thanks,

Lekshmi.

[Satyagadadas]

Iormally write mode "Use temperray file" means it writes as .tmp file and renames once the writing is completed. It won't delete any thing just it renames.

regards,

[lnirmala]

Hi Satya,

Please check the log :

If the .tmp file will be renamed how can the same tmp file be FTP'd to target location.

Also in the audit log it is saying "XI_ftp_4a641263-5bd5-02b8-f100-00000a0a0433.tmp: The system cannot find the file specified"

2009-07-27 14:46:43 Success Write to FTP server "xx.xx.xx.xx", directory "/inbound", -> file "File20090727-144643-545.xml" 2009-07-27 14:46:43 Success Transfer: "BIN" mode, size 185 bytes, character encoding -

2009-07-27 14:46:43 Error Attempt to process file failed with com.sap.aii.adapter.file.ftp.FTPEx: 550 XI_ftp_4a641263-5bd5-02b8-f100-00000a0a0433.tmp: The system cannot find the file specified.

2009-07-27 14:46:43 Error MP: Exception caught with cause com.sap.aii.af.ra.ms.api.RecoverableException: XI_ftp_4a641263-5bd5-02b8-f100-00000a0a0433.tmp: The system cannot find the file specified. : com.sap.aii.adapter.file.ftp.FTPEx: 550 XI_ftp_4a641263-5bd5-02b8-f100-00000a0a0433.tmp: The system cannot find the file specified.

2009-07-27 14:46:43 Error Exception caught by adapter framework: XI_ftp_4a641263-5bd5-02b8-f100-00000a0a0433.tmp: The system cannot find the file specified.

2009-07-27 14:46:43 Error Delivery of the message to the application using connection File_http://sap.com/xi/XI/System failed, due to: com.sap.aii.af.ra.ms.api.RecoverableException: XI_ftp_4a641263-5bd5-02b8-f100-00000a0a0433.tmp: The system cannot find the file specified. : com.sap.aii.adapter.file.ftp.FTPEx: 550 XI_ftp_4a641263-5bd5-02b8-f100-00000a0a0433.tmp: The system cannot find the file specified..

Thanks,

Lekshmi.

[lnirmala]

Hi Trevor,

Thanks for your reply.

I dont think this is related to any permissions in target system as the files are being processed daily from our Prod to this target system.This target system is shared by more than one interface in our Prod environment.More than one File adapter is writing files to this target system.This FTP process has been happening since 3 months and we are facing this issue since 2 weeks only.And also this issue has happened only twice.All the file adapters are having the write mode as "Use temporary File" but only this interface is having issue.

Could someone pls throw some light on this as the target system team is not ready to accept these .tmp files in their system.

To get more details i am including the audit log from RWB below:

2009-07-27 14:46:43 Success Message successfully received by messaging system. Profile: XI URL: http://prdpi:60000/MessagingSystem/receive/AFW/XI Credential (User): PIISUSER

2009-07-27 14:46:43 Success Using connection File_http://sap.com/xi/XI/System. Trying to put the message into the receive queue.

2009-07-27 14:46:43 Success Message successfully put into the queue.

2009-07-27 14:46:43 Success The message was successfully retrieved from the receive queue.

2009-07-27 14:46:43 Success The message status set to DLNG.

2009-07-27 14:46:43 Success Delivering to channel: File_Receiver_CC

2009-07-27 14:46:43 Success MP: Entering module processor

2009-07-27 14:46:43 Success MP: Processing local module localejbs/CallSapAdapter

2009-07-27 14:46:43 Success File adapter receiver: processing started; QoS required: ExactlyOnce

2009-07-27 14:46:43 Success File adapter receiver channel File_Receiver_CC: start processing: party " ", service "SERVICE_BUSS"

2009-07-27 14:46:43 Success Connecting to FTP server "xx.xx.xx.xx"

2009-07-27 14:46:43 Success Write to FTP server "xx.xx.xx.xx", directory "/inbound", -> file "File20090727-144643-545.xml"

2009-07-27 14:46:43 Success Transfer: "BIN" mode, size 185 bytes, character encoding -

2009-07-27 14:46:43 Error Attempt to process file failed with com.sap.aii.adapter.file.ftp.FTPEx: 550 XI_ftp_4a641263-5bd5-02b8-f100-00000a0a0433.tmp: The system cannot find the file specified.

2009-07-27 14:46:43 Error MP: Exception caught with cause com.sap.aii.af.ra.ms.api.RecoverableException: XI_ftp_4a641263-5bd5-02b8-f100-00000a0a0433.tmp: The system cannot find the file specified. : com.sap.aii.adapter.file.ftp.FTPEx: 550 XI_ftp_4a641263-5bd5-02b8-f100-00000a0a0433.tmp: The system cannot find the file specified.

2009-07-27 14:46:43 Error Exception caught by adapter framework: XI_ftp_4a641263-5bd5-02b8-f100-00000a0a0433.tmp: The system cannot find the file specified.

2009-07-27 14:46:43 Error Delivery of the message to the application using connection File_http://sap.com/xi/XI/System failed, due to: com.sap.aii.af.ra.ms.api.RecoverableException: XI_ftp_4a641263-5bd5-02b8-f100-00000a0a0433.tmp: The system cannot find the file specified. : com.sap.aii.adapter.file.ftp.FTPEx: 550 XI_ftp_4a641263-5bd5-02b8-f100-00000a0a0433.tmp: The system cannot find the file specified..

2009-07-27 14:46:43 Success The message status set to WAIT.

2009-07-27 14:46:43 Success The asynchronous message was successfully scheduled to be delivered at Mon Jul 27 14:51:43 IST 2009.

2009-07-27 14:51:43 Success The message status set to TBDL.

2009-07-27 14:51:43 Success Retrying to deliver message to the application. Retry: 1

2009-07-27 14:51:43 Success The message was successfully retrieved from the receive queue.

2009-07-27 14:51:43 Success The message status set to DLNG.

2009-07-27 14:51:43 Success Delivering to channel: File_Receiver_CC

2009-07-27 14:51:43 Success MP: Entering module processor

2009-07-27 14:51:43 Success MP: Processing local module localejbs/CallSapAdapter

2009-07-27 14:51:43 Success File adapter receiver: processing started; QoS required: ExactlyOnce

2009-07-27 14:51:43 Success File adapter receiver channel File_Receiver_CC: start processing: party " ", service "Service_BUSS"

2009-07-27 14:51:43 Success Connecting to FTP server "xx.xx.xx.xx"

2009-07-27 14:51:43 Success Write to FTP server "xx.xx.xx.xx", directory "/inbound", -> file "File20090727-145143-670.xml"

2009-07-27 14:51:43 Success Transfer: "BIN" mode, size 185 bytes, character encoding -

2009-07-27 14:51:43 Success File processing complete

2009-07-27 14:51:43 Success MP: Leaving module processor

2009-07-27 14:51:43 Success The message was successfully delivered to the application using connection File_http://sap.com/xi/XI/System.

2009-07-27 14:51:43 Success The message status set to DLVD.

Lekshmi.

[lnirmala]

Hi Shabarish,

Thanks for your reply.

Once i change the write mode property to directly the above problem will be solved.

Here i want to clear one more doubt in the same context.If i am using wite mode as "Use temporary file" then the temporary file should be deleted once the original file is written(as per my knowledge).

So how can the original file and temporary file co-exist in the same target folder?

[Former Member]

Hi Lekshmi,

One possibility is how the permissions are set in the target folder (e.g. whether a user is allowed to delete, rename etc...)

Regards, Trevor