When updating a self-hosted Storage Platform to v21.7 directly from v21.5 (i.e. skipping v21.6), you may encounter the following issues on trying to start the AccountServer:
12:27:25.776 (1) Error: Error in AS_Service: Database server not available or database migration script error. Attix5.StoragePlatform.Common.Exceptions.StartupException: Database server not available or database migration script error
12:27:35.043 (5) Error: SQL server reported the following error: Invalid column name 'CompanyGroupId'.. System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'CompanyGroupId'
To resolve these, open SQL Server Management Studio and execute the following on the Storage Platform's AccountServer and SlaveAccountServer databases:
UPDATE SubSonicSchemaInfo SET version = 265
Note that the query must be executed on both databases, as the services on the SlaveAccountServer will not run until the query has been executed, and the database replication/copy tasks will not execute if the services are not running.
Please sign in to leave a comment.