I am trying to upgrade project from hp qc 10 to hp alm 11.52
in that process trying to restore project from hp alm 11.52 but getting error like "failed to restore project"
here is the SA log message :
Failed to restore project. Project will be removed com.hp.alm.platform.exception.CTdException Messages: Failed to update versions in the project; [Mercury][SQLServer JDBC Driver][SQLServer]Invalid object name 'td.DATACONST'. Failed SQL: / ~~QC / UPDATE td.DATACONST SET DC_VALUE=/P/'10.00' WHERE DC_CONST_NAME=/P/'version';
how can i restore project in sql server project db have "dbo.ACTIONS, dbo.AUDIT_LOG etc how can chege these tables into td.ACTIONS, td.AUDIT_LOG etc.
what type of permissions i need in sql management studio to restore project ?
what is the procedure to restore project from hp alm site admin.could please assit me its urgent to upgrade projects .
attaching sql db snap shot
appreciate if you do needfull
Answer by Dan · Sep 07, 2016 at 06:30 PM
Praveen_hpqc, If your new DB has all of your projects prefixed as td and not dbo, then the original project will need to be changed to td before being able to perform any upgrade. The td prefix for the tables means that the DB is using SQL authentication and your old project prefixed with dbo is using Windows Authentication. You will have to have your DBA run the SQL queries to change the Authentication type for all the tables within the project (after you have restored the project's DB schema to the DB instance) and make sure the db account owner is correctly associated with this project schema. You should then be able to edit the DBID.xml for the correct parameters, restore the project to the ALM instance, verify, repair( repeat verify and repair as necessary) and then upgrade the project.
Hope this helps, Dan