Can’t Restore Lab Project to the New upgrade version getting ‘Confidential Passphrase Error’ upon trying?

  • Questions
  • Can't Restore Lab Project to the New upgrade version getting 'Confidential Passphrase Error' upon trying?
Question ID: 106909

We are getting a "Confidential ALM Passphrase is incorrect" error when trying to restore to the new version we just installed and upgraded our projects to. We didn’t migrate the lab project prior to the installation and thus a new version was created and we can’t get the correct lab _project from the prior version into this one (and we need it as the projects are connected to it through the prior version).

How can we get past this issue? We installed using what we thought was the same confidential and communication security phrases used in the prior version however there must be something different as we are unable to restore the project as it shows this error.

Any help is greatly appreciated,

Marked as spam
Posted by (Questions: 379, Answers: 35)
Asked on June 15, 2016 12:38 pm
Answers (1)
Private answer

Hi homerJ,

If you don't have the ALM version you won't be able to see the Lab_Management tab to work with the lab_project. In this case, you need to see the following article on how to get the lab_project viewable in the Site Projects tab alongside the other projects:

After you have done this, then try and restore the project, making sure and verify that the project has the correct pass phrasing being used making sure of the following if using SQL server run the following queries on the DB prior to attempting the restore:

USE domain_project_db
GO (This selects the database)

EXEC sp_change_users_login 'Report'
GO (This unlinks the ''td'' user)

EXEC sp_change_users_login 'Update_One', 'td', 'td'

EXEC sp_changedbowner 'sa'

Exec sp_MSforeachtable @command1=''sp_changeobjectowner '?', 'td'''

If this fails again then, you can try the following:

change the HOST_PASSWORD value in LAB_HOSTS table with the one from the dbid.xml file of the lab_project and then perform the restoration and upgrade.

This action can be done by your DBA with an UPDATE query run against that table within the DB.

I hope this helps,

Marked as spam
Posted by (Questions: 0, Answers: 771)
Answered on June 15, 2016 12:45 pm
Thanks, We had to do the whole procedure as the first part didn't resolve the issue. Thanks for the detailed information. HomerJ
( at June 15, 2016 12:53 pm)