Friday, October 28, 2011

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

If you are running the N-jobs to move over data to the POS, and following error 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


The cause is that in the Transfer field list:
(Retail Scheduler/Subjobs/Setup/Transfer Field List)
The Field Type on all To Fields are set to = None

How it suppose to look is illustrated below:

 
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.

1 comment: