File Adapter - Delete file error

[Former Member]

Hi Experts,

I am on XI 7.0 SP 10, and trying to test out a simple scenario for file adater where am trying to move an XML from one directory to another. In the communication channel moinitoring it shows that there is an error in deleting the file from the location (the folder has proper access rights). Checked some server traces and found the below error message. Please help in case any of you knows the solution.

Regards

Unni

Error trace below

#1.5#00156052F51900610000003A00002BE8000436129857B96A#1185353400063#/Applications/ExchangeInfrastructure/AdapterFramework/Services/ADAPTER/ADMIN/File##com.sap.aii.adapter.file.File2XI.processFileList()#J2EE_GUEST#0####06ed4e033a8c11dca09e00156052f519#XI File2XI[cc_xmlfile_sender/bs_xmlfile_sender/]_17##0#0#Error#1#com.sap.aii.adapter.file.File2XI#Plain###Channel cc_xmlfile_sender: Sending file failed with com.sap.aii.af.ra.ms.api.DuplicateMessageException: Message ID 6d2ec360-3a78-11dc-a893-00156052f519(OUTBOUND) already exists in database: com.sap.sql.DuplicateKeyException: [SAP_NWMss][SQLServer JDBC Driver][SQLServer]Violation of PRIMARY KEY constraint 'PK__XI_AF_MSG__7640FDE6'. Cannot insert duplicate key in object 'XI_AF_MSG'. - continue processing#

#1.5#00156052F51900610000003C00002BE8000436129857C052#1185353400063#/Applications/ExchangeInfrastructure/AdapterFramework/Services/ADAPTER/ADMIN/File##com.sap.aii.adapter.file.File2XI.deleteFile(FileHandle)#J2EE_GUEST#0####06ed4e033a8c11dca09e00156052f519#XI File2XI[cc_xmlfile_sender/bs_xmlfile_sender/]_17##0#0#Error#1#com.sap.aii.adapter.file.File2XI#Java###Deleting of file failed - cannot proceed#1#C:
XI_FILES
SENDER
xi_xmlfile_input1.dat#

#1.5#00156052F51900610000003E00002BE8000436129857C1A2#1185353400063#/Applications/ExchangeInfrastructure/AdapterFramework/Services/ADAPTER/ADMIN/File##com.sap.aii.adapter.file.File2XI.processFileList()#J2EE_GUEST#0####06ed4e033a8c11dca09e00156052f519#XI File2XI[cc_xmlfile_sender/bs_xmlfile_sender/]_17##0#0#Error#1#com.sap.aii.adapter.file.File2XI#Plain###File 'C:
XI_FILES
SENDER
xi_xmlfile_input1.dat' - deleting after processing failed - retry#

#1.5#00156052F51900610000004000002BE8000436129857D8BE#1185353400063#/Applications/ExchangeInfrastructure/AdapterFramework/Services/ADAPTER/ADMIN/File##com.sap.aii.adapter.file.util.AuditLog.addAuditLog(PublicMessageKey, String, AuditLogStatus, String, String, Object[])#J2EE_GUEST#0####06ed4e033a8c11dca09e00156052f519#XI File2XI[cc_xmlfile_sender/bs_xmlfile_sender/]_17##0#0#Error#1#com.sap.aii.adapter.file.util.AuditLog#Plain###FILE_ERR_019#

[prabhu_s2 · Accepted solution]

unni

or check with the table entires and reporcess the failed message from rwb. this will not create another message id

[prabhu_s2]

try to reporcess the failed message from RWB and see if it is posting

[Former Member]

>>>trying to test out a simple scenario for file adater where am trying to move an XML from one directory to another

Are you usin the processing mode "Archive". If so, check the archive folder. The file you are trying to process now may be already available in the archive folder (same file name).

Regards,

Jai Shankar

[Former Member]

Processing mode is "Delete"

[prabhu_s2]

what is the version u r using? maybe in the latest SP level unless the mesage is processed successfuly the file is not deleted !!! i doubt this happens but still a check

[Former Member]

I am on XI 7.0 SP 10

[Former Member]

Hmm... One more try...

Use cmd prompt and try to login to the FTP server with the User id/ pwd mentioned in the cc and try to delete the file using FTP command <b>delete</b>.

Regards,

Jai Shankar

[prabhu_s2]

okie first just try to correct the error in database level while updating the table. if this is corrected then u can conclude what the error is excatly

[Former Member]

Hi Prabhu,

Well, this is automatically happening from behind the scene. I dont have any control. I did try deleting this entry from the db table mentioned, but then it will show a different message id next time.

Any clues?

regards

Unni

[prabhu_s2]

since ur are testing the scenario creation of a new message id will not be a show stopper. it will help to figure out the cause of the error. else try to reporcess the failed message again.

[Former Member]

Hi Krishna,

As mentioned i the problem, I have already given full access to that folder.

regards

Unni

[Former Member]

Hi

Check if you have specifies the same message for the fault message type in the outbound i.e for the sender

regards

krishna

[prabhu_s2]

first part is u are tyring to update the data in a tbale which already exists (primary key is set). so check WRT that first. maybe if u can correct this ur scenario will work

[Former Member]

Hi Prabhu,

Well, this is automatically happening from behind the scene. I dont have any control. I did try deleting this entry from the db table mentioned, but then it will show a different message id next time.

Any clues?

regards

Unni

[Former Member]

I seriously doubt if that trace got anything to do with your problem

regards

krishna

[Former Member]

Hi

in the file server, Give full rights to the file and the directory

regards

krishna