Looking for PowerObjects? Don’t worry, you’re in the right place! We’ve been part of HCL for several years, and we’ve now taken the final step in our acquisition journey: moving our website to the HCL domain. Nothing else is changing – we are still fanatically focused on Microsoft Business Applications!

PowerObjects Blog 

for Microsoft Business Applications


Error Installing UR 8 and 9

Post Author: Joe D365 | February 14th, 2010

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"

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?

Joe CRM
By 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.

One comment on “Error Installing UR 8 and 9”

PowerObjects Recommends