VoIP upgrade error

gfaircloth

I received the following error when upgrading my VoIP module to 2.1.

Database configuration failed: 
 •  Error while executing script- Cannot insert the value NULL into column 'VoipCCMMonitoringID', table 'CCS.dbo.VoipCCMPhones'; column does not allow nulls. UPDATE fails.
The statement has been terminated.

I have verified with DB manager that the column specified does allow NULL's.  So maybe its a database owner issue (dbo)?  Wish I understood SQL better.

Now the VoIP monitors web access is dead.  Anyone know how to fix this easily.  I am running Orion 9.1 SP3.  I assume I can reinstall the previous version of VoIP to at least get back up and running.

Thanks.

gfaircloth

UPDATE

It turns out the problem was related to some data that was still in some of the VoIPCCM... tables from some call managers that no longer were being monitored.  After truncating those tables the install worked fine. 

Many thanks to Matthew Harvey in tech support for figuring this out.