It's all about the answers!

Ask a question

The configured database lock id does not match the lock id in the database


Piotr Aniola (3.7k11738) | asked Mar 21 '14, 8:09 a.m.
edited Mar 26 '14, 3:56 p.m. by Stephanie Taylor (24115)
Hello,

I'm trying to attach RQM to a restored DB. RQM is 4.0.5, DB is DB2 9.7.
When doing test connection in the setup wizard I'm getting:

"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 shut down the server and ran repotools resetRepoLockId for both QM and JTS, but the condition persists. Attaching the results of the command:
c:\Program Files\IBM\JazzTeamServer\server>repotools-qm.bat -resetRepoLockId tea
mserver.properties=conf\qm\teamserver.properties
Repo Tools
Provisioning using "c:\Program Files\IBM\JazzTeamServer\server\conf\qm\provision
_profiles".
  Jazz Foundation - Core Libraries, Version 4.0.5 (RJF-I20131025-1325)
  Quality Management - Core Libraries, Version 4.0.5 (I20131025_2252)


 To submit questions about issues, go to the Jazz.net forum at https://jazz.net/
forum.
 To find more information about a message, see the CLM Messages Information Cent
er at
 https://jazz.net/help-dev/CLMErrorMessages/index.jsp.
CRJAZ1363I Loading the configuration from "file:conf/qm/teamserver.properties".
CRJAZ1778I This server is configured as an application.
CRJAZ2558I Setting the local server rename state to false and the openServerDesc
riptionServiceTemporarily state to false.
CRJAZ1365I The server is attempting to connect to the following database: "conf/
qm/derby/repositoryDB"
CRJAZ1364I The connection to the following database was successful:
 Db Product Name: Apache Derby
  Db Product Version: 10.8.2.3 - (1212722)
  Db URL: jdbc:derby:conf/qm/derby/repositoryDB;create=true
  Jdbc Driver Name: Apache Derby Embedded JDBC Driver
  Jdbc Driver Version: 10.8.2.3 - (1212722)
CRJAZ1970I The application is configured with:
  Public URI: "https://localhost:9443/qm"
  Jazz Team Server location: "https://localhost:9443/jts/"
CRJAZ2523I Setting the global server rename state to false and the validation st
ate to false.
Reset of repository lock id has finished.

c:\Program Files\IBM\JazzTeamServer\server>repotools-jts.bat -resetRepoLockId te
amserver.properties=conf\jts\teamserver.properties
Repo Tools
Provisioning using "c:\Program Files\IBM\JazzTeamServer\server\conf\jts\provisio
n_profiles".
  Jazz Foundation - Core Libraries, Version 4.0.5 (RJF-I20131025-1325)


 To submit questions about issues, go to the Jazz.net forum at https://jazz.net/
forum.
 To find more information about a message, see the CLM Messages Information Cent
er at
 https://jazz.net/help-dev/CLMErrorMessages/index.jsp.
CRJAZ1363I Loading the configuration from "file:conf/jts/teamserver.properties".

CRJAZ1779I This server is configured as a JTS.
CRJAZ2558I Setting the local server rename state to false and the openServerDesc
riptionServiceTemporarily state to false.
CRJAZ1365I The server is attempting to connect to the following database: "conf/
jts/derby/repositoryDB"
CRJAZ1364I The connection to the following database was successful:
 Db Product Name: Apache Derby
  Db Product Version: 10.8.2.3 - (1212722)
  Db URL: jdbc:derby:conf/jts/derby/repositoryDB;create=true
  Jdbc Driver Name: Apache Derby Embedded JDBC Driver
  Jdbc Driver Version: 10.8.2.3 - (1212722)
CRJAZ1971I The server is configured with:
  Public URI: "https://localhost:9443/jts"
CRJAZ2523I Setting the global server rename state to false and the validation st
ate to false.
Reset of repository lock id has finished.


Is there any place in the DB where I can put the repo lock id from teamserver properties directly?

Accepted answer


permanent link
John Nason (2.4k1012) | answered Mar 25 '14, 7:49 a.m.
FORUM MODERATOR / JAZZ DEVELOPER
Hi Piotr - you are running the correct command, but in the first line you mention "DB2", but all the resetRepoLockId commands you are running are connecting to the local Derby instance, e.g.:
CRJAZ1364I The connection to the following database was successful:
 Db Product Name: Apache Derby
  Db Product Version: 10.8.2.3 - (1212722)
  Db URL: jdbc:derby:conf/qm/derby/repositoryDB;create=true
So to me it looks like you're mistmatching the teamserver.properties file you use to run repotools -resetRepoLockId vs. the DB connection you're using when running the server. I'd have expected it to be connecting to your DB2 instance. So I'd double check that your teamserver.properties file is correct, and that the JDBC connection info to your DB is also correct.

Piotr Aniola selected this answer as the correct answer

Comments
Piotr Aniola commented Mar 25 '14, 8:54 a.m.

You are right, and that fixed it, but it doesn't explain why there was the repoLockId issue in the first place. I suppose the setup wizard tests the DB against the default DB from the teamserver.properties, rather than the values from entered in the wizard

Your answer


Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.