1 Reply Latest reply on Dec 16, 2013 10:23 AM by Alan Alderson

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

    jwest

      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.

        • 1. Re: Failed to get list of profiles. File decryption failed (0xc000028l)
          Alan Alderson

          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