Skip to content
+1-888-319-3663

COMMUNITY FORUM

REALLY COULD USE SOME ASSISTANCE WITH THIS

Deanne asked 5 years ago
The INSERT statement conflicted with the CHECK constraint ‘CK_PA10001_PATE_47AE9581”.  The conflict occurred in database “ARFUS”, table ‘dbo.PA10001”, column ‘PATE’.  The statement has been terminated.
 
The map has Create timesheet and Add line item
 
This map is not referencing PATE anywhere – why do we get this error?
Answers
Lorren Zemke Staff answered 5 years ago
Deanne,
If you change the map destination to Dynamics GP – File, does it show a value or node in the XML for the PATE column?  If there is a value, does it have a date of 1/1/1900, which Dynamics GP requires for Time fields.
If there is no value, then you will probably need to check with Microsoft on why the taPATimeSheetLineInsert eConnect procedure is throwing that error. Another option would be to set a default PATE value in the map or int the taPATimeSheetLineInsertPre procedure.
Lorren

If you would like to submit an answer or comment, please sign in to the eOne portal.