You’re offline. This is a read only version of the page.
When using RMS administrator and attempting to upgrade the database I'm getting an error message. "BRMain" is the name of the database.
An error occurred while attempting to upgrade the database
Cannot insert the value NULL into column 'ID', table BRMain.dbo.DatabaseMetaData'; column does not allow nulls. INSERT fails.
Any Ideas?
Daniel
*This post is locked for comments
Daniel, the best method I've found is to do the upgrade in two steps. Go from 2.0 to 2.03 in the first bit and wait for it to finish. Then repeat but this time go from 2.03-2.06. For some reason that always works best for me. The error looks like a trigger that has some unfinished business? Perhaps stop and restart the SQL Server. Then press/start/search/type %TEMP% /Control A/Delete everything (any warnings just skip). Do a MS disk cleanup/Delete everything but restore points (if applicable).Reboot the server/check make sure SQL servers running then try my two step method.
Hope that helps, error sure looks like a hook or a trigger holding up the works, perhaps this method will allow you to get around it.
I've tried on a Win7 machine and I'm getting the same results.
Also, run a database check and a re-index on the existing machine before the upgrade. BACKUP FIRST!!
Try doing it on a Win 7 machine, Win 10 still kinda wonky.
SQL 2008 R2, RMS SO, and database 2.00 on a Windows 10 system.
What version of SQL? I never had any luck with 2012.
Where does the upgrade stop with the error?
Is this an SO or HQ database?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (