Violation of PRIMARY KEY constraint during sending NCCode to system

[kalmerkand]

MES system is: (6.0.4.22)

External software is sending NCData to MES system and sometimes gets error:"Violation of PRIMARY KEY constraint 'PK__BC_JMSQU__3F9FE7012CDE6A9D'. Cannot insert duplicate key in object 'SAPEL1DB.BC_JMSQUEUE'. The duplicate key value is (36, 26015261174081363, 3500000000000000001)"

I provide client machine log with data details in file: "client device.txt"

and default trace part in file: "default_trace.txt"

client device.txt.zip

default_trace.txt.zip

[alexander_teslyuk]

The error seems to be against NW table, which is for JMS queue.

How exactly do you send NC data to MES? Do you use MII and MEINT?

[kalmerkand]

Communication works through Webservices.

[sergiy_katerinich]

Hi!

You might be using NC Codes with Message Type assigned or you turned on RTW for NC. Please check if disabling these features makes any change.

Also you can play with "Enable SFC Complete JMS Message" system rule.

Regards,

Sergiy