We have recently run into an interesting bug while trying to install update rollup 8 and 9.

crm2011

The actual error file in the ur log file was:

“Cannot insert the value NULL into column ‘InvoiceNumber’, table”

And/or

“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?

Avatar for Joe D365

Joe D365

Joe D365 is a Microsoft Dynamics 365 superhero who runs on pure Dynamics adrenaline. As the face of PowerObjects, Joe D365’s mission is to reveal innovative ways to use Dynamics 365 and bring the application to more businesses and organizations around the world.