Changin the qcsiteadmin_db to a different one in ALM?
Question ID: 105888
0
0

HI,
I have a co worker that was having issues with our ALM server application and ended up running the installation again and creating a new qcsiteadmin_db. e haven’t reactivated the projects and would just like to go back to using the original qcsiteadmin_db so we don’t have to go through all of the changes we had with the original siteadmin project db. Is it possible to revert to the other acsiteamin project db?

HomerJ

Marked as spam
Posted by (Questions: 379, Answers: 35)
Asked on January 29, 2015 3:22 pm
43 views
Answers (1)
1
Private answer

Hi HomerJ,
The good news is thag yes you can revert to the original qcsiteadmin_db and since you haven't activated your projects yet, the data will not have changed nor will you lose any work that may have been done since the changes (as none was completed).

What you will need to do is to stop the services and then edit the siteadmin.xml files to point to the original qcsiteadmin_db within that xml. As an example do the following within ALM 11 (the folder locations will differ with different ALM versions and different OS versions, so you may need to search for all instances and replace the information for each location to ensure it works as desired):

Start by changing where the APP server is to look for it's qcsiteadmin database.
Open qcbin20.war folder (folder name has a ''.'' In it):
3 locations - change all three (if they all exist)
C:Program FilesHPHP Application Lifecycle Management Platformapplication20qcbin.warWEB-INF
C:Documents and SettingsAll UsersApplication DataHPALMjbossserverdefaultdeploy20qcbin.warWEB-INF
C:Documents and SettingsAll UsersApplication DataHPALMapplication20qcbin.warWEB-INF
Navigate to the WEB-INF folder

Edit the project name from the new qcsiteadmin project db to the original one).

Once this is done, you can just restart the services and all should start normally and run off of the original db information.

You shouldn't but may have to remove (remove and not delete) the projects from the project list and readd them to the list if they are not able to be reactivated.

Hope this helps,
Dan

Marked as spam
Posted by (Questions: 0, Answers: 770)
Answered on January 29, 2015 3:31 pm
0
Thanks, that solved our issues and helped save us much time in reimporting all the information.
( at January 29, 2015 3:32 pm)
EyeOnTesting

Welcome back to "EyeOnTesting" brought to you by Orasi Software, Inc.

X
Scroll to Top