Title: Store connect
– IDispatch error #3119: Violation of
PRIMARY KEY
Affected products:
Dynamics AX 2009 SP1 RU6 R2
Dynamics AX 2009 SP1 RU7 R2 Refresh
Description:
When running the N-jobs to move over data to the POS, the
following information occurs in the store connect
IDispatch error #3119:
Violation of PRIMARY KEY constraint ‘I_20137STAFFIDX’. Cannot insert duplicate
key in object ‘dbo.RBOSTAFFTABLE’. 2011-08-16
07:34:53.000
N-1060
Cause:
In the Transfer field list
(Retail Scheduler/Subjobs/Setup/Transfer Field List) the field type on all to fields
are set to None
Picture illustrates how it
should look like:
Solution:
If you read the fields with store connect from the menu
(Retail Scheduler/Distribution location/Functions) Then all field types are
restored to the correct values
Author: Kim
Editor: Kim
Date: 18. August 2011