Thread Info
  • State Not Answered
  • Locked Locked
  • Replies 2 replies
  • Subscribers 6 subscribers
  • Views 8148 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

Problem upgrading from 6.10 to 7

EasonChing

Follow the upgrade guide, turned off IIS, change database to single user mode and tried running the migratesgn610_sng700.sql script, but hit with this error.

Msg 924, Level 14, State 1, Line 15
Database 'SafeGuard' is already open and can only have one user at a time.
Updating Policy Setting BitLockerFallbackLogonMode
Msg 208, Level 16, State 1, Line 5
Invalid object name 'SGN_POLICY_SETTINGS'.
Msg 208, Level 16, State 1, Line 1
Invalid object name 'SGN_POLICY_SETTINGS'.

(1 row(s) affected)
Create OneDrive Cloud Storage Definition
Msg 208, Level 16, State 1, Line 11
Invalid object name 'CLOUD_STORAGE_DEFINITION'.
Create OneDrive for Business Cloud Storage Definition
Msg 208, Level 16, State 1, Line 11
Invalid object name 'CLOUD_STORAGE_DEFINITION'.
Table versioning maintenance
Msg 208, Level 16, State 1, Line 14
Invalid object name 'dbo.TABLE_INFO'.
Msg 208, Level 16, State 1, Line 1
Invalid object name 'dbo.SEC_OFFICER'.
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "dbo.SEC_OFFICER" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "dbo.SEC_OFF_ROLES" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "dbo.SEC_OFF_CERT" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "dbo.SEC_OFF_TAB_ACCESS" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "dbo.SEC_OFF_IN_GROUP" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "dbo.SEC_OFF_SGD" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "dbo.SEC_OFF_POL" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "dbo.SCHEDULE_TASKS" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "dbo.KEY_ENTRY" because it does not exist or you do not have permissions.
Msg 3701, Level 11, State 5, Line 1
Cannot drop the table 'dbo.SEC_OFFICER', because it does not exist or you do not have permission.
Caution: Changing any part of an object name could break scripts and stored procedures.
Msg 4902, Level 16, State 1, Line 2
Cannot find the object "dbo.KEY_ENTRY" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "dbo.KEY_ENTRY" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "dbo.SCHEDULE_TASKS" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "dbo.SCHEDULE_TASKS" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "dbo.SEC_OFF_POL" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "dbo.SEC_OFF_POL" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "dbo.SEC_OFF_SGD" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "dbo.SEC_OFF_SGD" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "dbo.SEC_OFF_IN_GROUP" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "dbo.SEC_OFF_IN_GROUP" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "dbo.SEC_OFF_TAB_ACCESS" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "dbo.SEC_OFF_TAB_ACCESS" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "dbo.SEC_OFF_CERT" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "dbo.SEC_OFF_CERT" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "dbo.SEC_OFF_ROLES" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "dbo.SEC_OFF_ROLES" because it does not exist or you do not have permissions.

(1 row(s) affected)
The database update failed.

How do i get past this error?



This thread was automatically locked due to age.
  • 0
    EasonChing,

    I hope you made a full backup of the database, but sounds like you still have some open connections to the database... you can try:

    Make sure you stop selecting the database. Open a query window.

    use master
    go
    sp_who2

    For whatever that is connected to the database, run:

    kill ;

    When that is successful, run:

    alter database "DATABASE NAME" set multi_user;

    ~~~~~~

    Once that is done, you can then try again to follow the upgrade guide by going back to single user.
    Failing that, restore to a backup of your database and try again.

    PaulD
  • 0

    I ran into this error as well. Once I was able to get my database restored. I decided to take a risk and try running the script while leaving the database in Multi_User mode. It successfully ran and I was able to get everything else upgraded. I was able to get my organization to approve a Sophos downtime though and make sure no one was using the Sophos management center during that time.

    Maybe that will help you.

Unfiltered HTML