Failed to restore project in hp alm 11.52

  • Questions
  • Failed to restore project in hp alm 11.52
Question ID: 107089

Hi All,

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
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

Thank you


Marked as spam
Posted by (Questions: 11, Answers: 7)
Asked on September 7, 2016 3:50 pm
Answers (1)
Private answer

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,

Marked as spam
Posted by (Questions: 0, Answers: 771)
Answered on September 7, 2016 6:30 pm
Hi Dan, Thank you for response...!!! I have db rights to run the sql queries so i ran queries and i changed db user from dbo to td and tried to restore project from hp alm sa but again i am getting similar issue please check. Messages: Failed to restore project; Failed to load data from EXTENSIONS table of project 'default_poc_db@jdbc:mercury:sqlserver://HTXQSQLALM01P:1433(td)'; [Mercury][SQLServer JDBC Driver][SQLServer]Invalid object name 'EXTENSIONS'. Failed SQL: /* ~~QC */ SELECT EX_NAME FROM EXTENSIONS; Regards, Praveen
( at September 8, 2016 11:37 am)