We have recently run into an interesting bug while trying to install update rollup 8 and 9.
The actual error file in the ur log file was:
“Cannot insert the value NULL into column ‘InvoiceNumber’, table”
“column does not allow nulls. UPDATE fails.”
In addition Update Rollup 9 seems to be stuck in a loop, generating lines and lines of log files.
After looking at the database and verifying all was ok including all invoice rows of data having an InvoiceNumber we found a potential workaround, but not an ideal one. Our work around was to delete all data from the Invoice and InvoiceDetail tables. Then installing UR 8 or UR 9. After the system was updated, the same synchronize method as before was used to re-add the invoice data.
If a better workaround is found, we’ll post it here.
Welcome to the #1 Dynamics CRM Partner in the World
Proud winner of the 2015 Microsoft Partner of the Year for Cloud Customer Relationship Management, PowerObjects is the preferred partner for implementing, supporting, and growing CRM solutions. Through unparalleled offerings of service, support, education, and add-ons, PowerObjects can help tailor custom solutions for your business.
How Can We Help You Today?