Putting message into send queue failed in file to idoc scenario

[Former Member]

for a file to idoc scenario after doing all the configurations when the file is posted , the file is not being deleted (picked) .the following is the log message from RWB->communication channel monitoring

Putting message into send queue failed, due to: com.sap.aii.af.ra.ms.api.DuplicateMessageException: Message ID a0ff7230-8793-11dc-a4d5-001558e4827d(OUTBOUND) already exists in database: com.sap.sql.DuplicateKeyException: [NWMss][SQLServer JDBC Driver][SQLServer]Violation of PRIMARY KEY constraint 'PK__XI_AF_MSG__2B090089'. Cannot insert duplicate key in object 'dbo.XI_AF_MSG'..

pl help

[Former Member · Accepted solution]

Hi Mohammad,

Please change the source directory path and also do the necessary changes in the file adapter and check.

hope i am clear.

Regards,

Chandu.

[Former Member]

what was the solution you implemented?

[Former Member]

Hi Mohammad,

Can you please share with us how you solved this problem?

we are facing the same issue here.

kindly share us the answer.

thanks

Seema.

[Former Member]

hi

thanks for your effort, the problem was solved

[Former Member]

>

> hi 
> thanks for your effort, the problem was solved

ehm... could you please explain how you solved the problem?

It would be of great help

thanks,

Daniele

[Former Member]

Hi Mohammad,

The XI_AF_MSG is concerned with message archiving on the Java stack. I donot think it is an error concerning your interface.

Suggest you to contact your Basis consultant to get this resolved.

Regards,

Smitha.

[Former Member]

Hi,

The primary key value u sending in the file is already present in the system and so it is throwing the exception "PRIMARY KEY constraint "

Check he primary key values u sending.

Regards,

Shabari

[Former Member]

HI

integration directory you need to set the value as temporary/delete.

then after receiving the files to the receiver system the picked files are automatically deleted.

check it with that.

regards,

KRUSHI

[Former Member]

Hi Shabari,

can u pl expalin , how to check the primary key values and how to rectify the error

rgds,

mojib

[Former Member]

Hi,

The error is self explanatory,you are trying to insert same record into database and violating the primary key.

Just change the data of your file and scenario will work.

for example IF YOU are sending emp_no as 101,send 102

Thanks,

TUhin

[Former Member]

Hi,

What data are u posting to R/3 system using the Idoc?

Regards,

Shabari

[Former Member]

hi shabhari ,

this is the complete xml message we have posted

<?xml version="1.0" encoding="UTF-8" ?>

- <ns0:abc_mt xmlns:ns0="http://abcns">

<venid>eswar1111</venid>

<venname>xyz</venname>

<vencity>noida</vencity>

<ventel>0112344567</ventel>

</ns0:abc_mt>

pl look at it and revert

rgds

mojib

[Former Member]

Hi,

Plz check in table in the R/3 system where u posting the data ,if the venid 'eswar111' already exists.

Regards,

Shabari

[vikas_agarwal]

Hi,

It looks like that the field(IDoc) in which you are filling venid is a primary key and cannt take this value again.

Check the table in R/3 side or try with other venid.

regards,

Vikas

[Former Member]

Hi,

i checked with other venid also but of no use l, moreover in rwb communication channel is showing green and successful but i can't understand why the data is not being picked up.

pl help

rgds,

mojib

[Former Member]

Hi,

In communication channel for file sender

Check if in Processing parameter->Processind Mode is set to "Delete"

Regards,

Shabari

[Former Member]

Hi

processing mode is set at " delete" right from beginning but still the file is not being picked up from the file although the in rwb channels are in active position and green .

i m not able to find the problem where it is , pl help

rgds

mojib