Thread Info
  • State Not Answered
  • Locked Locked
  • Replies 6 replies
  • Subscribers 1 subscriber
  • Views 2473 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

error upgrading sophos45 db to 50 on sql 2008

tdubb

I am getting an error when running the sophos5 installer on the db server to upgrade the 45 database. 

MSI (s) (3C:98) [12:26:29:733]: Note: 1: 1402 2: UNKNOWN\Components\DA42BC89BF25F5BD0AF18C3B9B1A1EE8\2BEDF90E8F2D7E14E94486F6F593A14E 3: 5 MSI (s) (3C:98) [12:26:29:734]: Product: Sophos Enterprise Console -- Error 1402.Could not open key: UNKNOWN\Components\DA42BC89BF25F5BD0AF18C3B9B1A1EE8\2BEDF90E8F2D7E14E94486F6F593A14E.  System error 5.  Verify that you have sufficient access to that key, or contact your support personnel.
MSI (s) (3C:98) [12:26:29:738]: User policy value 'DisableRollback' is 0MSI (s) (3C:98) [12:26:29:738]: Machine policy value 'DisableRollback' is 0Action ended 12:26:29: InstallExecute. Return value 3.MSI (s) (3C:98) [12:26:29:748]: Executing op: Header(Signature=1397708873,Version=405,Timestamp=1077240654,LangId=1033,Platform=0,ScriptType=2,ScriptMajorVersion=21,ScriptMinorVersion=4,ScriptAttributes=1)MSI (s) (3C:98) [12:26:29:748]: Executing op: DialogInfo(Type=0,Argument=1033)MSI (s) (3C:98) [12:26:29:749]: Executing op: DialogInfo(Type=1,Argument=Sophos Enterprise Console)MSI (s) (3C:98) [12:26:29:750]: Executing op: RollbackInfo(,RollbackAction=Rollback,RollbackDescription=Rolling back actions,RollbackTemplate=[1],CleanupAction=RollbackCleanup,CleanupDescription=Removing backup files,CleanupTemplate=File: [1])MSI (s) (3C:B0) [12:26:29:759]: I/O on thread 5768 could not be cancelled. Error: 1168MSI (s) (3C:B0) [12:26:29:759]: I/O on thread 4704 could not be cancelled. Error: 1168MSI (s) (3C:B0) [12:26:29:759]: I/O on thread 7056 could not be cancelled. Error: 1168MSI (s) (3C:B0) [12:26:29:759]: I/O on thread 5784 could not be cancelled. Error: 1168MSI (s) (3C:B0) [12:26:29:759]: I/O on thread 5884 could not be cancelled. Error: 1168MSI (s) (3C:B0) [12:26:29:759]: I/O on thread 5148 could not be cancelled. Error: 1168

:21133


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

    I just want to summarize the issues I had during my upgrade from 45 to 50

    first it was a registry permission error when running the installer to upgrade the database

    The fix was going through this link

    http://www.symantec.com/business/support/index?page=content&id=TECH135922

    Then I as able to rerun the installer and install the database sophos50 and sophospatch but they were blank after the install.

    Then I ran the installer on the management server. Even though sophos said the installer should upgrade the database. It didnt do it. The installer will say installing completed with no errors. But the management service will not start. When trying to start it, it says 


     Migrating data if necessaryError: std::runtime_error. Database upgrade failed. Please see KBA 113946.Data

    So at this point. I had to run upgradedb.exe

    upgradedb -sourceversion=45 -debug -reset

    then this did it.

    I guess --reset was not necessary if no data was migrated from 45 to 50. But in my case I tried to manually migrate it on the database server prior to the upgradedb command.

    sqlcmd -E -S .\SOPHOS -d SOPHOS50 -Q "dbo.FromXto4 45,0"

    anyway glad its working now

    :21149
Reply
  • 0

    I just want to summarize the issues I had during my upgrade from 45 to 50

    first it was a registry permission error when running the installer to upgrade the database

    The fix was going through this link

    http://www.symantec.com/business/support/index?page=content&id=TECH135922

    Then I as able to rerun the installer and install the database sophos50 and sophospatch but they were blank after the install.

    Then I ran the installer on the management server. Even though sophos said the installer should upgrade the database. It didnt do it. The installer will say installing completed with no errors. But the management service will not start. When trying to start it, it says 


     Migrating data if necessaryError: std::runtime_error. Database upgrade failed. Please see KBA 113946.Data

    So at this point. I had to run upgradedb.exe

    upgradedb -sourceversion=45 -debug -reset

    then this did it.

    I guess --reset was not necessary if no data was migrated from 45 to 50. But in my case I tried to manually migrate it on the database server prior to the upgradedb command.

    sqlcmd -E -S .\SOPHOS -d SOPHOS50 -Q "dbo.FromXto4 45,0"

    anyway glad its working now

    :21149
Children
No Data
Cookie Information Banner