Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / eConnect Integration f...
Finance | Project Operations, Human Resources, ...
Suggested answer

eConnect Integration for Purchase Orders - Insert error conflicted with CHECK Constraint CK_POP10100_CREATD Column CREATDDT

(0) ShareShare
ReportReport
Posted on by lisasorensen15 10

I have a client that is importing Purchase Orders from an outside system using eConnect. While running the integration, the following error is generated: 

The INSERT statement conflicted with the CHECK constraint "CK__POP10100__CREATD__5540965B". The conflict occurred in database "COMPANY", table "dbo.POP10100", column 'CREATDDT'.

I found the following post related to the DOCDATE field, but don't see anything related to the Created Date field: https://community.dynamics.com/gp/b/dynamicsgpthoughts/posts/the-insert-statement-conflicted-with-the-check-constraint 

I know the Created Date is a system generated date of the first save of the Purchase Order in the header table. 

We are not passing a value for the CREATDDT field so we are not certain why we are receiving the error. Does it make sense to set a value for the field? Or is it another date field that is triggering this error? 

Any insight on how to get around the error would be helpful. 

Thank you. 

Categories:
Microsoft Dynamics GP
  • lisasorensen15 Profile Picture
    lisasorensen15 10 on at
    RE: eConnect Integration for Purchase Orders - Insert error conflicted with CHECK Constraint CK_POP10100_CREATD Column CREATDDT

    Hi Josh, 

    Thanks for the response. I don't have a Pre/Post proc that is setting or altering the CREATDDT field.

    As a precaution, I did confirm that the default binding for the CREATDDT field is set to dbo.GPS_DATE but there shouldn't be any modifications as the client doesn't have any 3rd party software installed and have not been using the POP module. I did confirm that there is only the standard trigger on the POP10100 table so nothing unusual there. 

    I forwarded your responses to the developers to have them confirm the date value format for the DOCDATE and all Date fields they are attempting to import. I haven't received a reply regarding the progress. If we still have issues, I will follow-up but I appreciate the feedback. All good suggestions! 

  • Suggested answer
    Josh Page Profile Picture
    Josh Page on at
    RE: eConnect Integration for Purchase Orders - Insert error conflicted with CHECK Constraint CK_POP10100_CREATD Column CREATDDT

    Below are some items to check.

    1) Do you have a pre or post Econnect proc that is setting\ altering the CREATDDT field?

    2) If you look at the table design for POP10100, is the default binding for CREATDDT set to dbo.GPS_DATE? I'm guessing if it's not you would have this issue entering PO's in general as well.

    3) Are there any triggers on the POP10100 which could be affecting the process?

    4) If you check the DOCDATE field in your XML file, does it have a time listed after the date?

    I checked and it looks like econnect uses the same date value as DOCDATE for CREATDDT

    What's happening is that the check constraint on this column prevents you have having a time in the datetime column as an example in Fabricam if you ran the below statement you would get the same error because we are setting the hour value. Somewhere in the process the created date value is being added\ updated with the time portion of the datetime stamp being set.

    update POP10100 set CREATDDT='2013-07-21 03:00:00.000' where DEX_ROW_ID=1

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans