Upgrading JTS server from 3.0.1 to 3.1.1.3 issue #2 thread

Zulchefil Ozgian

(16●5●6) edited

Jun 08 '12, 5:05 a.m.

Now I have followed your suggestion and deleted the repositoryDB from the newest 3.1.1.3 instalation directory and copied over again from 3.0.1 for each of them (jts,ccm,rqm)

I have another error now.

[root@oc0570384574 server]# ./repotools-jts.sh -addTables noPrompt
Repo Tools
Provisioning using "./conf/jts/provision_profiles".
Jazz Foundation - Core Libraries, Version 3.0.1.3 (RJF-I20120322-1607)

CRJAZ1363I Loading the configuration from "file:conf/jts/teamserver.properties".
CRJAZ1779I This server is configured as a JTS.
CRJAZ1971I The server is configured with:
Public URI: "https://oc0570384574.ibm.com:9443/jts"
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.5.3.2 - (1073208)
Db URL: jdbc:derby:conf/jts/derby/repositoryDB;create=true
Jdbc Driver Name: Apache Derby Embedded JDBC Driver
Jdbc Driver Version: 10.5.3.2 - (1073208)
CRJAZ8192I: Fulltext Index Location: /opt/IBM/JazzTeamServer_1/server/conf/jts/indices/workitemindex/fulltext_index
CRJAZ8190I: The fulltext index should point to an absolute directory but is currently set to 'conf/jts/indices/workitemindex'
Adding tables to the database "conf/jts/derby/repositoryDB".
CRJAZ1442I The component model of "com.ibm.team.repository.auth" was updated from "3" to "4".
CRJAZ1770E 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 team server.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.
The user "ADMIN" has logged out of the database "conf/jts/derby/repositoryDB".
CRJAZ1728E An unexpected error has been detected. See the log file opt/IBM/Jaz zTeamServer_1/server/repotools-jts_addTables.log" for more details.

0 votes

Comments

Zulchefil Ozgian

Jun 08 '12, 5:03 a.m.

at com.ibm.team.repository.service.internal.rdb.DatabaseStateService.refreshState(DatabaseStateService.java:73) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

Zulchefil Ozgian

Jun 08 '12, 5:03 a.m.

at java.lang.reflect.Method.invoke(Method.java:618) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:370) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:356) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56) at $Proxy108.refreshState(Unknown Source)

Zulchefil Ozgian

Jun 08 '12, 5:03 a.m.

Zulchefil Ozgian

Jun 08 '12, 5:03 a.m.

at com.ibm.team.repotools.rcp.internal.RepositoryToolsApplication.start(RepositoryToolsApplication.java:811) at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:194) at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110) at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79) at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:368)

Zulchefil Ozgian

Jun 08 '12, 5:04 a.m.

at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:179) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

Zulchefil Ozgian

Jun 08 '12, 5:04 a.m.

at java.lang.reflect.Method.invoke(Method.java:618) at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:559) at org.eclipse.equinox.launcher.Main.basicRun(Main.java:514) at org.eclipse.equinox.launcher.Main.run(Main.java:1311)

Zulchefil Ozgian

Jun 08 '12, 5:04 a.m.

at org.eclipse.equinox.launcher.Main.main(Main.java:1287) Caused by: com.ibm.team.repository.common.TeamRepositoryException: Server lock id value _Z0dRAF4FEeGVJNmZLFfWHQ and database lock id _DaHSQV4CEeGbaM_FU-mS2Q do not match for database jdbc:d erby:conf/jts/derby/repositoryDB. Use the 'repotools-jts -resetRepoLockId' command to remove the DB lockID, after ensuring this DB is not used by another JTS or application. at com.ibm.team.repository.service.internal.db.util.RepoLockIdUtil.checkServerToSchemaLock(RepoLockIdUtil.java:181)

Zulchefil Ozgian

Jun 08 '12, 5:04 a.m.

at com.ibm.team.repository.service.internal.db.util.RepoLockIdUtil.checkServerToSchemaLock(RepoLockIdUtil.java:148) at com.ibm.team.repository.service.internal.rdb.DatabaseStateService.checkServerLockToSchemaLock(DatabaseStateService.java:109) at com.ibm.team.repository.service.internal.rdb.DatabaseStateService.refreshState(DatabaseStateService.java:65) ... 27 more 2012-06-08 11:17:33,714 CRJAZ1728E An unexpected error has been detected. See the log file "/opt/IBM/JazzTeamServer_1/server/repotools-jts_addTables.log" for more details.

Zulchefil Ozgian

Jun 11 '12, 4:48 a.m.

I have managed to upgrade to 3.1.1.3 but now when I log into the administration page in JTS I don't see any applications. Does any one know why?

I have done the upgrading using repotools-jts -resetRepoLockId and then doing all over over again

cd 3.0.1.x_install_dir/server ./repotools-jts.sh -addTables noPrompt ./repotools-ccm.sh -addTables noPrompt ./repotools-qm.sh -addTables noPrompt

Zulchefil Ozgian

Jun 11 '12, 6:01 a.m.

I give up. I will reinstall a fresh version 3.1.1.3 and go from there.

showing 5 of 10 show 5 more comments

3 answers

7,360 views

0 votes

3 answers

Permanent link

John Vasta

FORUM MODERATOR / JAZZ DEVELOPER (2.6k●1●5) Jun 08 '12, 9:55 a.m.

All I can say is that you got yourself into a bad state, where the 3.0.1.3 properties files are not consistent with the 3.0.1.3 databases. If your 3.0.1 server still runs without any problems connecting to the database, then I suggest starting over - delete the 3.0.1.3 repositoryDB folders again, copy the 3.0.1 repositoryDB folders to the 3.0.1.3 server install area, copy the properties files again.

Or, if you want to try a shortcut, you can do what the error message suggests: execute 'repotools-jts -resetRepoLockId' (in the 3.0.1.3 server area) to reset the lock id.

1 vote

Permanent link

John Vasta

FORUM MODERATOR / JAZZ DEVELOPER (2.6k●1●5) Jun 08 '12, 8:22 a.m.

It sounds like the 3.0.1 teamserver.properties files, and all the other configuration files, did not get copied correctly from the 3.0.1 install area to the 3.0.1.3 install area. This is step 8 in the upgrade procedure:

cp 3.0.1_install_dir/server/conf/jts/teamserver*.properties  3.0.1.x_install_dir/server/conf/jts
cp 3.0.1_install_dir/server/conf/ccm/teamserver*.properties  3.0.1.x_install_dir/server/conf/ccm
cp 3.0.1_install_dir/server/conf/qm/teamserver*.properties  3.0.1.x_install_dir/server/conf/qm
cp 3.0.1_install_dir/server/conf/admin/admin.properties*  3.0.1.x_install_dir/server/conf/admin
cp 3.0.1_install_dir/server/conf/admin/friends.rdf*  3.0.1.x_install_dir/server/conf/admin
cp 3.0.1_install_dir/server/conf/rm/fronting.properties  3.0.1.x_install_dir/server/conf/rm
cp 3.0.1_install_dir/server/conf/rm/friendsconfig.rdf  3.0.1.x_install_dir/server/conf/rm

The repository lock ids are stored in the teamserver.properties file for each product, and they must match what is stored in the database. So if you copy both the databases and the teamserver.properties files correctly, they should still match. Therefore, please do the above copy commands again, and verify that the files got copied correctly and are in the correct location. Then retry the addTables command.

0 votes

Comments

Zulchefil Ozgian

Jun 11 '12, 9:17 a.m.

I have done what you said and now this error I get

[root@oc0570384574 server]# ./repotools-jts.sh -addTables noPrompt
Repo Tools
Provisioning using "./conf/jts/provision_profiles".
Jazz Foundation - Core Libraries, Version 3.0.1.3 (RJF-I20120322-1607)

CRJAZ1363I Loading the configuration from "file:conf/jts/teamserver.properties".
CRJAZ1779I This server is configured as a JTS.
CRJAZ1971I The server is configured with:
Public URI: "https://oc0570384574.ibm.com:9443/jts"
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.5.3.2 - (1073208)
Db URL: jdbc:derby:conf/jts/derby/repositoryDB;create=true
Jdbc Driver Name: Apache Derby Embedded JDBC Driver
Jdbc Driver Version: 10.5.3.2 - (1073208)
CRJAZ8192I: Fulltext Index Location: /opt/IBM/JazzTeamServer_1/server/conf/jts/indices/workitemindex/fulltext_index
CRJAZ8190I: The fulltext index should point to an absolute directory but is currently set to 'conf/jts/indices/workitemindex'
Adding tables to the database "conf/jts/derby/repositoryDB".
CRJAZ1442I The component model of "com.ibm.team.repository.auth" was updated from "3" to "4".
CRJAZ1770E 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.
The user "ADMIN" has logged out of the database "conf/jts/derby/repositoryDB".
CRJAZ1728E An unexpected error has been detected. See the log file "/opt/IBM/JazzTeamServer_1/server/repotools-jts_addTables.log" for more details.

Zulchefil Ozgian

Jun 11 '12, 9:17 a.m.

2012-06-08 15:29:50,759 Repo Tools
2012-06-08 15:29:50,760 java.version=1.5.0
2012-06-08 15:29:50,760 java.runtime.version=pxi32devifx-20110209 (SR11 FP2 +IZ94331)
2012-06-08 15:29:50,763 Provisioning using "./conf/jts/provision_profiles".
2012-06-08 15:29:50,780 repotools-jts -addTables noPrompt
2012-06-08 15:29:50,781 Jazz Foundation - Core Libraries, Version 3.0.1.3 (RJF-I20120322-1607)

2012-06-08 15:29:50,790 CRJAZ1363I Loading the configuration from "file:conf/jts/teamserver.properties".
2012-06-08 15:29:51,292 CRJAZ1779I This server is configured as a JTS.
2012-06-08 15:29:51,293 CRJAZ1971I The server is configured with:
Public URI: "https://oc0570384574.ibm.com:9443/jts"
2012-06-08 15:29:53,550 CRJAZ1365I The server is attempting to connect to the following database: "conf/jts/derby/repositoryDB"
2012-06-08 15:29:53,936 CRJAZ1364I The connection to the following database was successful:
Db Product Name: Apache Derby
Db Product Version: 10.5.3.2 - (1073208)
Db URL: jdbc:derby:conf/jts/derby/repositoryDB;create=true
Jdbc Driver Name: Apache Derby Embedded JDBC Driver
Jdbc Driver Version: 10.5.3.2 - (1073208)
2012-06-08 15:29:55,074 CRJAZ8192I: Fulltext Index Location: /opt/IBM/JazzTeamServer_1/server/conf/jts/indices/workitemindex/fulltext_index
2012-06-08 15:29:55,074 CRJAZ8190I: The fulltext index should point to an absolute directory but is currently set to 'conf/jts/indices/workitemindex'
2012-06-08 15:29:56,736 Removing project move component...
2012-06-08 15:29:56,741 Removed project move component in 7 ms.
2012-06-08 15:29:56,741 Adding tables to the database "conf/jts/derby/repositoryDB".
2012-06-08 15:29:58,022 CRJAZ1442I The component model of "com.ibm.team.repository.auth" was updated from "3" to "4".
2012-06-08 15:29:58,466 CRJAZ1770E 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.

Zulchefil Ozgian

Jun 11 '12, 9:17 a.m.

2012-06-08 15:29:58,468 The user "ADMIN" has logged out of the database "conf/jts/derby/repositoryDB".
2012-06-08 15:29:59,912 CRJAZ1770E 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 t
o 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 conne
ction 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 infor
mation on the affected database.
java.lang.RuntimeException: CRJAZ1770E 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 tryi
ng 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 c
onnection 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 i
nformation on the affected database.
        at com.ibm.team.repository.service.internal.rdb.DatabaseStateService.refreshState(DatabaseStateService.java:73)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:618)
        at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:370)
        at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:356)
        at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
        at <unknown class>.<unknown method>(Unknown Source)

Zulchefil Ozgian

Jun 11 '12, 9:18 a.m.

        at com.ibm.team.repotools.commands.local.internal.AddTablesCommand.refreshDatabaseState(AddTablesCommand.java:95)
        at com.ibm.team.repotools.commands.local.internal.AddTablesCommand.addTables(AddTablesCommand.java:63)
        at com.ibm.team.repotools.commands.local.internal.AddTablesCommand.execute(AddTablesCommand.java:137)
        at com.ibm.team.repotools.command.AbstractCommand.execute(AbstractCommand.java:64)
        at com.ibm.team.repotools.rcp.internal.RepositoryToolsApplication.run(RepositoryToolsApplication.java:736)
        at com.ibm.team.repotools.rcp.internal.RepositoryToolsApplication.start(RepositoryToolsApplication.java:811)
        at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:194)
        at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)
        at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)
        at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:368)
        at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:179)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:618)
        at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:559)
        at org.eclipse.equinox.launcher.Main.basicRun(Main.java:514)
        at org.eclipse.equinox.launcher.Main.run(Main.java:1311)
        at org.eclipse.equinox.launcher.Main.main(Main.java:1287)

Zulchefil Ozgian

Jun 11 '12, 9:18 a.m.

Caused by:
com.ibm.team.repository.common.TeamRepositoryException: Server lock id value _Z0dRAF4FEeGVJNmZLFfWHQ and database lock id _DaHSQV4CEeGbaM_FU-mS2Q do not match for database jdbc:d
erby:conf/jts/derby/repositoryDB. Use the 'repotools-jts -resetRepoLockId' command to remove the DB lockID, after ensuring this DB is not used by another JTS or application.
        at com.ibm.team.repository.service.internal.db.util.RepoLockIdUtil.checkServerToSchemaLock(RepoLockIdUtil.java:181)
        at com.ibm.team.repository.service.internal.db.util.RepoLockIdUtil.checkServerToSchemaLock(RepoLockIdUtil.java:148)
        at com.ibm.team.repository.service.internal.rdb.DatabaseStateService.checkServerLockToSchemaLock(DatabaseStateService.java:109)
        at com.ibm.team.repository.service.internal.rdb.DatabaseStateService.refreshState(DatabaseStateService.java:65)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:618)
        at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:370)
        at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:356)
        at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
        at <unknown class>.<unknown method>(Unknown Source)
        ... 19 more
2012-06-08 15:29:59,913 CRJAZ1728E An unexpected error has been detected. See the log file "/opt/IBM/JazzTeamServer_1/server/repotools-jts_addTables.log" for more details.

Permanent link

Ralph Schoon

FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER (64.4k●3●36●49) edited

Jun 11 '12, 9:05 a.m.

There is a mismatch of the lock ID of the database and the teamserver.properties. If you are sure you work against the right database, you can use the repotools command suggested in the error message to delete the lock files. The lock is used to prevent from accidentally run more than one server against the same database. You want to really make sure the teamserver.properties of JTS, CCM, QM refer to different databases.

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

0 votes

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.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers

Answers and Comments

Question details

rational-team-concert

× 42,975

rational-quality-manager

× 10,987

troubleshooting

× 6,052

rational-doors-next

× 6,043

Question asked: Jun 08 '12, 5:03 a.m.

Question was seen: 7,360 times

Last updated: Jun 11 '12, 9:18 a.m.

Upgrading JTS server from 3.0.1 to 3.1.1.3 issue #2 thread

Comments

3 answers

7,360 views

0 votes

3 answers

Comments

Your answer

Follow this question

Question details

Related questions