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