Error reused DB CLM 4.0.6
HI There,
I have a problem here. I have aorphaned MS SQL databases file that have been used for old clm 4.0.6 configuration.
Unfortunately, I just only have those DB without any configuration files that support it (teamserver.properties,log4j.properties,etc,)
Now I setup new fresh installation of clm 4.0.6 and want to reused those DB, but when I test DB connection in jts/setup. I get error message like this:
The configured database lock id does not match the lock id in the database. This can happen if 2 applications or Jazz Team Servers are trying to access the same set of tables, or if the lock id was overwritten or lost in the teamserver.properties configuration file. Check the server configuration and the database connection spec and ensure they are correct. To recover from an emergency lockout, the lock can be reset using the 'repotools -resetRepoLockId' command. Check the log file for information on the affected database.ID CRJAZ1770E
I have follow the 'resetRepoLockId' procedure but when I retest again the connection, it has the same fails. What steps that should I do? So I can used the old db in my new clm.?
I presume this issue is caused by 'un matching' lock ID between jts and the db, then how can I locate the lock id config in those DB so i can reset and rematching again.?
Accepted answer
First of all, MySQL is not a supported database. You can find the supported databases in the Getting Started page linked to the System Requirements e.g.
from https://jazz.net/downloads/rational-team-concert/releases/4.0.7?p=gettingStarted find https://jazz.net/wiki/bin/view/Deployment/CLMSystemRequirements405406
Secondly, you will have at least two databases, one is for the JTS, and one is for the RTC/CCM application.
You have to configure these two databases in the setup, it have to be different ones, otherwise one application gets it and lock it for itself and the next one that tries fails.
For general information about backup see the product documentation online (from the download page) and https://jazz.net/wiki/bin/view/Deployment/BackupCLM
from https://jazz.net/downloads/rational-team-concert/releases/4.0.7?p=gettingStarted find https://jazz.net/wiki/bin/view/Deployment/CLMSystemRequirements405406
Secondly, you will have at least two databases, one is for the JTS, and one is for the RTC/CCM application.
You have to configure these two databases in the setup, it have to be different ones, otherwise one application gets it and lock it for itself and the next one that tries fails.
For general information about backup see the product documentation online (from the download page) and https://jazz.net/wiki/bin/view/Deployment/BackupCLM
Comments
Sorry, I mean MS SQL. I have revise it.
Yes obviously, we have all the databases (JTS,CCM,QM,DW).
But when I try to configure JTS, with existing db, it shows error like above.
The jts is come from fresh installation, so I think the issues is not on the jts side.
Yah, so how I unlock the repo-lock id configuration in db side (JTS/CCM/QM/DW)? So I can reused those DB?
The answer really is in the error message. If you read it carefully, which is advisable, it tells you to use the 'repotools -resetRepoLockId' command. You open a shell, go into the server folder of your specific server and run repotools-jts or repotools-ccm with the command -resetRepoLockID.
I have take step above, it doesnt work.
Then check if you have really used different DB's in the teamserver.properties files of the applications.
Otherwise, I really don't think I can help with the information available.
Hi there,
I have take 'repotools -resetRepoLockId' and it's work now, So, the way is:
I must copy the 'sql_server' section from teamserverbakup.properties, replace the default value in teamserver.properties and run above command.