Error while sending message: Message ID <number> already exists in database:

[Former Member]

Hi,

I have this error in PI communication channel.

Sending of file abc.TIF failed.

Error while sending message: Message ID <number> already exists in database: com.sap.sql.DuplicateKeyException: ORA-00001: unique constraint (SAPSR3DB.I_XI_ID_MAP_ID1) violated

How do i rectify this? I dont see any message failing in PI to cancel the message; the error is in communication channel. and rest of the files are not getting processed further because of this error.

and parameters for communication channel are as below:

[javier_alcubilla · Accepted solution]

Hi

That error is at database level.

You're trying to insert the same record and the primary key is violated

Regards

Javi

[Former Member · Accepted solution]

Hi Javi thanks.

but I'm not inserting anything in DB; its file to file.

[javier_alcubilla · Accepted solution]

Ok. Check this note:

SAP Note 1361305 - File sender adapter generates duplicate message IDs

[javier_alcubilla · Accepted solution]

Other solutions:

[Former Member]

Hi All,

Thank you all for the solutions!

the issue was with duplicate files being sent. once the files were deleted from the source and restareted the channels in the communication channel monitoring. did clear this error.

Thanks!

[Former Member]

Thanks Javi.

I have removed that file from source directory and restarted communication channel. but the communication channel is still showing the same error.

any other help?

[Former Member]

Hi Prema,

Refer blog

Suggest to restart XPI Adapter File.

Regards,

Pranav

[naveen_chichili]

Hi Prema,

Try Restarting Adapter service in NWA.

Thanks,

Naveen