Error running sql - update Projects set ObligationDate
User is trying to click Process Approved on the Project Changesets screen and receives the following error:
Error running sql: update Projects set ObligationDate = ? where Id = 'Â Â XXX' -2262 -6372
Additional information concerning a status error of -6372:
The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.
If you have any questions, please contact Munis Technical Support.
Project Master
The date defined on the New Value for Project - Obligation Date within one of the Approved changesets on the project is invalid.
User will need to delete the changeset where the date has been entered incorrectly
Financials > General Ledger Menu > Project Accounting > Project Ledger > Projects/Inquiry > Project Master
Click the orange folder icon next to Change Set
Use the arrow buttons to navigate between changeset records
User should be looking in the Fields section, reviewing the date entered in the New Value column for Project - Obligation Date
Once the problematic changeset has been identified, Delete the changeset
Re-enter the changes needed on the project and release the changes to workflow
For questions regarding this error or process of correcting this issue, please contact Enterprise ERP General Ledger Support.
Clicking Process Approved on the Project Changesets screen processes the changes for all Approved changesets, not just the changeset that the user is viewing.