Failed to get list of profiles. File decryption failed (0xc000028l)

[JWest8]

After upgrading to V9.0 I am able to pull system details in the console however all profile data fails to load. I am also unable to create new profiles as the same error is presented. Was able to find a DB entry in dbo.global_settings that indicated the upgrade was "in_progress". I restored the DB and ran the database utility upgrade command that completed successfully however provided the following errors in the log. After the restore and manual upgrade I seem to have the same issue.

17:10:53,113 - INFO : DatabaseUtils.Logging.Log(:0), - Starting: UpgradeDB

17:10:53,113 - INFO : DatabaseUtils.Logging.Log(:0), - Creating encryption key for database...

17:10:55,968 - INFO : DatabaseUtils.Logging.LogFileOnly(:0), - Start Upgrading Database...

17:10:55,968 - INFO : DatabaseUtils.Logging.Log(:0), - Checking if database exists and in the right version...

17:10:55,968 - INFO : DatabaseUtils.Logging.LogFileOnly(:0), - Enter DBExists

17:10:55,984 - INFO : DatabaseUtils.Logging.LogFileOnly(:0), - Enter Connect

17:10:56,015 - ERROR: DatabaseUtils.Logging.LogFileOnlyError(:0), - Invalid object name 'dbo.csti_configuration'.

17:10:56,015 - ERROR: DatabaseUtils.Logging.LogFileOnlyError(:0), - Invalid object name 'dbo.csti_global_settings'.

17:10:56,030 - INFO : DatabaseUtils.Logging.Log(:0), - Attempting to upgrade the database to version 9.0...

17:10:56,030 - INFO : DatabaseUtils.Logging.LogFileOnly(:0), - Parsing file: UpgradeDB8.1to9.0.sql

17:10:56,030 - INFO : DatabaseUtils.Logging.LogFileOnly(:0), - Executing file: UpgradeDB8.1to9.0.sql

17:10:56,030 - INFO : DatabaseUtils.Logging.Log(:0), - Creating new tables...

17:10:56,030 - INFO : DatabaseUtils.Logging.Log(:0), - Create Platform Capabilities Discovery table

17:10:56,030 - INFO : DatabaseUtils.Logging.Log(:0), - Migrating AMT discovery data.

17:10:56,030 - INFO : DatabaseUtils.Logging.Log(:0), - This can take several hours.

17:10:56,030 - INFO : DatabaseUtils.Logging.Log(:0), - Please be patient.

17:10:56,155 - INFO : DatabaseUtils.Logging.Log(:0), - Create DMP table

17:10:56,155 - INFO : DatabaseUtils.Logging.Log(:0), - Create Platform Capabilities Summary table

17:10:56,171 - INFO : DatabaseUtils.Logging.Log(:0), - Create update platform capabilities summary procedure

17:10:56,171 - INFO : DatabaseUtils.Logging.Log(:0), - Succeeded.

17:10:56,171 - INFO : DatabaseUtils.Logging.LogFileOnly(:0), - Password was printed to console output

17:10:56,171 - INFO : DatabaseUtils.Logging.LogFileOnly(:0), - Enter Disconnect

17:10:56,171 - INFO : DatabaseUtils.Logging.Log(:0), - Completed Successfully.

[Alan_A_Intel]

Hi jwest,

It looks like from these errors that the database was updated, but the RCS server itself was not. The RCS must be upgraded, or if you've already uninstalled version 8, then RCS version 9 must be installed on the same server with the same logon user.

The reason for that is the encryption method was changed in version 9 to increase security. During the upgrade of the RCS the installer performs a full re-encryption of the data in the database. Running the database tool upgrade command by itself only changes the database and doesn't re-encrypt the data so the new RCS can't read that data. Please refer to the SCS User Guide for more information and for a detailed "step by step" upgrade flow.

-Alan