Thread Info
  • State Verified Answer
  • Locked Locked
  • Replies 2 replies
  • Subscribers 2 subscribers
  • Views 4058 views
  • Users 0 members are here
Options
Suggested
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

Sophos Enterprise Console DB failed after upgrade from 5.4.1 to 5.5.1

Mantas L

Hi,

I get error after upgrade SEC from 5.4.1 to 5.5.1. When I have tried to start new upgraded SEC 5.5.1, I get error like this 

 

After searching on Sophos Community and KB I have find these solutions but none of them, has solved this problem.

https://community.sophos.com/products/endpoint-security-control/f/sophos-enterprise-console/90109/database-issue-with-upgrading-from-5-4-1-to-5-5-0

At first I tried upgradeDB -debug -sourceVersion=540, but then I get error like this: 

Error: std::exception thrown  SP Error: 55

Exit code 5 (Failed to transfer data from the old database.)

Then I have tried hese steps:

  • Detach and rename newly created Sophos551 DB
  • Then try to run sec_551\ServerInstaller\DB\Core\InstallDB.bat and after running this batch file no new DB has been created. (Just getting log file below:
    InstallDB (local)\SOPHOSMANAGMENT SOPHOSCC SOPHOS551 Sophos_InstallCore551DB.log
    Started
    2018-11-23
    15:17
    ========== )

Also I tried https://community.sophos.com/kb/en-us/111429, but same problem with new database creation. 

Please help.



This thread was automatically locked due to age.
Parents
  • 0

    Hello Mantas L,

    Off the top of my head.
    if the Management Service fails to start there should be an entry in the Window Event log. As you've already tried to reinstall the database the original error is no longer of much interest but what error do you get now?

    same problem with new database creation
    does it exist (sqlcmd -E -S [Server Name]\[SQL Instance Name] -Q "SELECT name from sys.databases")?

    You don't use the default server instance SOPHOS but instead one named SOPHOSMANAGMENT? Is this so? You've provided this parameter to InstallDB.bat?

    Christian

Reply
  • 0

    Hello Mantas L,

    Off the top of my head.
    if the Management Service fails to start there should be an entry in the Window Event log. As you've already tried to reinstall the database the original error is no longer of much interest but what error do you get now?

    same problem with new database creation
    does it exist (sqlcmd -E -S [Server Name]\[SQL Instance Name] -Q "SELECT name from sys.databases")?

    You don't use the default server instance SOPHOS but instead one named SOPHOSMANAGMENT? Is this so? You've provided this parameter to InstallDB.bat?

    Christian

Children
  • +1 in reply to QC

    Hello Christian,

    Thanks for response. But Sophos Support helped. First of all there was issue with DB user. I needed reset password for that DB user. 

    After that they reinstalled Sophos Enterprise Console and ran following command on cmd:

    "upgradedb.exe -debug -sourceVersion=540 -reset"

Unfiltered HTML