This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

upgrade database failed 520 to 550

Hi,

 

I have tried to upgrade 520 to 550 and I had an error so I did the new database 550:

 

C:\sec_550\ServerInstaller\DB\Core>InstallDB.bat (local)\sophos server2 SOPHOS550
Sophos_InstallCore550DB.log

 

And then:

 

C:\Program Files (x86)\Sophos\Enterprise Console>UpgradeDB.exe -debug -sourceVer
sion=520 -reset
17.05.2017 01:14:57 Parsing command-line qualifiers ... successfully completed.

17.05.2017 01:14:57 Validating parameter values ...
17.05.2017 01:14:57 ... successfully completed.
17.05.2017 01:14:57 Transferring data to the new database ...
17.05.2017 01:15:14 ... successfully completed.
17.05.2017 01:15:14 Patching database SophosSecurity ...
17.05.2017 01:15:14 Redirecting SophosSecurity synonyms ...
17.05.2017 01:15:14 Error: DBI exception thrown Could not find stored procedure
'dbo.RedirectSynonyms'.
17.05.2017 01:15:14 Exit code 11 (Failed to patch database SophosSecurity.)

C:\Program Files (x86)\Sophos\Enterprise Console>

 

I have changed the permissions to db_owner

I have tried many times to deattach and then do it again but nothing works!!!

I can see that the database 550 has data now but it does not finish properly for some reason.

Can you help? I am desperate, thanks.



This thread was automatically locked due to age.
  • Hello Jose Bordetas,

    the stored procedure 'dbo.RedirectSynonyms' is created by the UpdateSophosSecurity.bat script - did you run this as well? You should then run UpgradeDB.exe -reset before running it again to upgrade.

    Christian