09-03-2013 07:29 AM
I was migrating project from QC 10 to 11.52.
I have moved db and project files separately, restored project, upgraded it
There was no troubles but project was restored with wiped users passwords. Any ideas why did that happen?
09-03-2013 07:56 AM
User's attributes including passwords are kept in Site Administrator schema. If you wanted to keep the whole environment in tact, you should have opted for upgrading SA schema along with the actual project.
09-03-2013 05:28 PM
And were you using QC authentication in your v10 environment (as opposed to LDAP authentication)?
As leobor said, the user password is stored in the Site Admin schema (if you are using QC authentication). When you restore a project, that includes only the usernames of the users. Restoring the project will automatically add that username to the Site, but it does not bring any of the other user attributes with it. Project schemas include only the username value.
There are a variety of ways to get the user passwords. Upgrading a copy of the Site Admin schema during the installation of 11.52 is one way. However if the environments don't share a database server then that can be tricky.
You might also be able to extract the information using the Site Admin API, or by querying the Site Admin schema directly, and then using the Site Admin API on the new system to add the information to the Site Admin schema. Passwords are usually encrypted, and I'm not sure how that would impact your efforts.
You should probably consult directly with HP support to get guidance on the best way to resolve the issue now.
(Opinions expressed in my postings are mine alone, and do not reflect the opinions of my employer.No warranties express or implied for any solution/suggestion posted.)