emeadaxsupport: Store connect - IDispatch error #3119: Violation of PRIMARY KEY

[Blog bot]

Источник: http://blogs.msdn.com/b/emeadaxsuppo...imary-key.aspx
==============

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




Источник: http://blogs.msdn.com/b/emeadaxsuppo...imary-key.aspx