eConnect Error While creating receipts

(0) Share

Report

Posted on by Vamsi Kotta

Hello,

We are using eConnect to create receipts in GP. XML is formatted as per the schema. I am not sure why we are getting the error. Part of the error is as follows

The INSERT statement conflicted with the CHECK constraint "CK__PA10702__DATEVAL__00F7C100". The conflict occurred in database "GPPRD", table "dbo.PA10702", column 'DATEVAL'. The statement has been terminated. Server stack trace: at

Thanks

Vamsi

*This post is locked for comments

All responses (1)

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

Re: eConnect Error While creating receipts

When exactly do you get this error message? It looks like some of the data you are trying to integrate is not in the correct format..and it looks to be a date issue. I'm no expert with this!!

You can look into the check to see what is being validated. Try running the following query in MSSQL: (You don't have to run it against any particular database)

SELECT * FROM sys.check_constraints WHERE name = 'CK__PA10702__DATEVAL__00F7C100'

PA10702 looks like a Project Accounting table...