Home› Self-Service Portal - Community

Can't upgrade V7 to V8

Jeff_LandersJeff_Landers Customer IT Monkey ✭
in Self-Service Portal - Community

We have successfully upgraded our Version 7 portal to Version 8 but V7 to V8 is problematic in our test environment.

The user running is install is a domain admin on the SM box and the Cireson portal box and is dbo on the SM and Cireson database.   Since we are on version 7, we went through the uninstall procedure EXCEPT for deleting the Cireson Database (is that the problem?).  We select Install Database since the warning box says to do that even if upgrading.  However, we are getting this error.  Can someone help?

Jeff

0/16/2017 10:11:39 AM Replacing content in: InstallationFiles\DBScripts\ServiceManagement-Temp.sql

10/16/2017 10:11:39 AM Attempting to create ServiceManagement Database

10/16/2017 10:11:49 AM Failed to create management database  ServiceManagement2 on cohntcs33\mssqlcm : Changes to the state or options of database 'ServiceManagement2' cannot be made at this time. The database is in single-user mode, and a user is currently connected to it.
ALTER DATABASE statement failed.

10/16/2017 10:11:49 AM Failed to create management database  ServiceManagement2 on cohntcs33\mssqlcm : Changes to the state or options of database 'ServiceManagement2' cannot be made at this time. The database is in single-user mode, and a user is currently connected to it.

Best Answer

Answers

  • Tony_CollettTony_Collett Cireson Support Super IT Monkey ✭✭✭✭✭
    Hi Jeff, 
    Can you please go to Add/Remove Programs and uninstall the entry "Cireson Setup". This will not uninstall the existing portal - it only removes the old installation files. Once that's done, go back to the beginning of installing version 8 (make sure the file you download is Unblocked in Properties) and run the installer again. It should download version 8 fresh. 

    Alternatively, you can try stopping the Cireson Cachebuilder and Platform Host services and stopping the IIS Site and see if you are still having an issue with the single user problem. 

    Regards, Tony
  • Jeff_LandersJeff_Landers Customer IT Monkey ✭

    Tony, Thank you for your reply.

    Just to be clear, we have followed the uninstall document which removes all IIS entries, uninstalls the cache builder service, deletes the inetpub/cireson folder, removes the mgmt packs, and would remove Cireson from add/remove programs but it has never appeared there even on our functional Version 8 portal.  In addition, since this is an offline install, we browse to the install files, and copy them to the server so there is no unblock.   Something just doesn't make sense with what should be a clean install except for updating the databases. What are we missing?

    Thank you, Jeff

  • Tony_CollettTony_Collett Cireson Support Super IT Monkey ✭✭✭✭✭
    Can you try removing (dropping) the database? The error message is saying it's in single-user mode (so only one connection at a time). 
    Removing the database does remove things like favourite requests, KB articles and dashboards, so if that's not something you want to do, then you could try this:
    ALTER DATABASE ServiceManagement
SET MULTI_USER;
GO

  • Martin_BlomgrenMartin_Blomgren Customer Ninja IT Monkey ✭✭✭✭
    @Jeff_Landers
    dbo isn't enough you must be sysadmin to be able to deploy the dacpac, as stated in the install kb.
  • Jeff_LandersJeff_Landers Customer IT Monkey ✭

    Martin,

    Our bad.  I assumed that since the database was installed we would not need sysadmin on the SQL box.   Can you clarify the "administrator on the local box" please?   Is that local admin on the cireson portal box, sql box, or both.  Thank you for you help.

    Important note: Make sure that the logged in user that you are running the installer as is a sysadmin on the SQL Server where the ServiceManagement database will be installed, as well as an administrator for the local machine.

Sign In or Register to comment.