Microsoft Dynamics 365 Blog

Title: Store connect
IDispatch error #3119: Violation of

Affected products:

Dynamics AX 2009 SP1 RU6 R2

Dynamics AX 2009 SP1 RU7 R2 Refresh


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



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:



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

We're always looking for feedback and would like to hear from you. Please head to the Dynamics 365 Community to start a discussion, ask questions, and tell us what you think!