Wednesday, July 31, 2013

Ax 2009 - Replicaton errors


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:
The Transfer field list: (Retail Scheduler/Subjobs/Setup/Transfer Field List)
 The Field Type on all To Fields are set to = none
Solution:
Read the fields with store connect from the menu (Retail Scheduler/Distribution location/Functions) then all field types are restored to the correct values. 

Error no.: 12296 in AXRETAIL MSG DB

User don’t have privilege read and write on POS DB

Item cannot be found in the collection corresponding to the requested name or ordinal., table 'RBOSTAFFTABLE': 5637146104,0,0,0,0,0,0,0,0,0,0,,ceu,84374,,0,John,Doe,,1,30,0,0,0,40,0,Admin,4/13/2010 6:57:01 PM,John Evans,JohnE,0758441cBD8C3CE1,PoljiTh

The issue is that the schema of the AxRetailPOS database if not matching the columns that is in the package file.

No comments:

Post a Comment