Upgrading JTS server from 3.0.1 to 3.1.1.3 issue
Hello.
I have a question regarding upgrading the JTS server from 3.0.1 to 3.1.1.3.
I am using currently JTS version 3.0.1 (RQM and RTC installed in the same bundle). I have used the guide from and have reached step 9. I am using Tomcat and Derby database.
http://pic.dhe.ibm.com/infocenter/clmhelp/v3r0m1/index.jsp?topic=%2Fcom.ibm.jazz.install.doc%2Ftopics%2Ft_upgrading_3011.html
Step 9
Run the repotools -addTables command to ensure the database has the correct tables. (For distributed systems, go the appropriate server and run the repotools command.)
cd 3.0.1.x_install_dir/server
./repotools-jts.sh -addTables noPrompt
./repotools-ccm.sh -addTables noPrompt
./repotools-qm.sh -addTables noPrompt
When I do the first command I get the following error
----------------------------------------------------------------------------------------------------------------------------------------------------------------
[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)
CRJAZ1093I The following service class was not activated: "com.ibm.team.repository.service.internal.schemagen.PersistentMappingService"
CRJAZ1141I Cannot get the service "com.ibm.team.repository.service.internal.rdb.IDatabaseStateService".
CRJAZ1728E An unexpected error has been detected. See the log file "/opt/IBM/JazzTeamServer_1/server/repotools-jts_addTables.log" for more details.
----------------------------------------------------------------------------------------------------------------------------------------------------
Also in this forum is it possible to attach log files? I do not see the option of attaching files.
If it is not possible I will update the thread with the logs from the file.
What must I do so that the process of migration from 3.0.1 to 3.1.1.3 can continue?
I have a question regarding upgrading the JTS server from 3.0.1 to 3.1.1.3.
I am using currently JTS version 3.0.1 (RQM and RTC installed in the same bundle). I have used the guide from and have reached step 9. I am using Tomcat and Derby database.
http://pic.dhe.ibm.com/infocenter/clmhelp/v3r0m1/index.jsp?topic=%2Fcom.ibm.jazz.install.doc%2Ftopics%2Ft_upgrading_3011.html
Step 9
Run the repotools -addTables command to ensure the database has the correct tables. (For distributed systems, go the appropriate server and run the repotools command.)
cd 3.0.1.x_install_dir/server
./repotools-jts.sh -addTables noPrompt
./repotools-ccm.sh -addTables noPrompt
./repotools-qm.sh -addTables noPrompt
When I do the first command I get the following error
----------------------------------------------------------------------------------------------------------------------------------------------------------------
[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)
CRJAZ1093I The following service class was not activated: "com.ibm.team.repository.service.internal.schemagen.PersistentMappingService"
CRJAZ1141I Cannot get the service "com.ibm.team.repository.service.internal.rdb.IDatabaseStateService".
CRJAZ1728E An unexpected error has been detected. See the log file "/opt/IBM/JazzTeamServer_1/server/repotools-jts_addTables.log" for more details.
----------------------------------------------------------------------------------------------------------------------------------------------------
Also in this forum is it possible to attach log files? I do not see the option of attaching files.
If it is not possible I will update the thread with the logs from the file.
What must I do so that the process of migration from 3.0.1 to 3.1.1.3 can continue?
2 answers
Detailed error information will be in the log file, so we really need to see what's in it. There should be a log of exception and stack trace information related to the CRJAZ1141I error - can you paste in all the related information? Be sure to include all of the nested exception info. Based on the fact that there was a problem with IDatabaseStateService, it could mean that there was a problem copying the 3.0.1 Derby database to the 3.0.1.3 installation area, such that the copy was corrupted somehow.
Comments
It looks like the root cause exception is this:
Which leads me to believe that there was a problem copying your 3.0.1 Derby databases to the 3.0.1.3 installation area. In the instructions you are following, did you perform step 3? Is your server running on Linux or Windows? The instructions are for Linux systems, but they say you have to do the equivalent thing if you are running on Windows. So step 3 says to do the copy like this:
My suggestion is to delete the 3.0.1.3 database locations, and do the copy again. That is, delete these folders on your server:
Then copy your 3.0.1 databases again, and retry the addTables command.
java.lang.ArrayIndexOutOfBoundsException: Array index out of range: 0
at org.apache.derby.impl.sql.GenericParameterValueSet.initialize(Unknown Source)
at org.apache.derby.impl.sql.execute.BaseActivation.setupActivation(Unknown Source)
at org.apache.derby.impl.sql.GenericActivationHolder.<init>(Unknown Source)
at org.apache.derby.impl.sql.GenericPreparedStatement.getActivation(Unknown Source)
... 57 more
Which leads me to believe that there was a problem copying your 3.0.1 Derby databases to the 3.0.1.3 installation area. In the instructions you are following, did you perform step 3? Is your server running on Linux or Windows? The instructions are for Linux systems, but they say you have to do the equivalent thing if you are running on Windows. So step 3 says to do the copy like this:
cp -R 3.0.1_install_dir/server/conf/jts/derby/repositoryDB 3.0.1.x_install_dir/server/conf/jts/derby
cp -R 3.0.1_install_dir/server/conf/ccm/derby/repositoryDB 3.0.1.x_install_dir/server/conf/ccm/derby
cp -R 3.0.1_install_dir/server/conf/qm/derby/repositoryDB 3.0.1.x_install_dir/server/conf/qm/derbyIs that what you did?My suggestion is to delete the 3.0.1.3 database locations, and do the copy again. That is, delete these folders on your server:
Be sure to delete the 3.0.1.3 databases, not your 3.0.1 databases! Or you will lose all your data.3.0.1.x_install_dir/server/conf/jts/derby/repositoryDB3.0.1.x_install_dir/server/conf/ccm/derby/repositoryDB3.0.1.x_install_dir/server/conf/qm/derby/repositoryDB
Then copy your 3.0.1 databases again, and retry the addTables command.
Comments
Zulchefil Ozgian
Jun 07 '12, 10:35 a.m.Zulchefil Ozgian
Jun 07 '12, 10:36 a.m.Zulchefil Ozgian
Jun 07 '12, 10:37 a.m.Zulchefil Ozgian
Jun 07 '12, 10:37 a.m.Zulchefil Ozgian
Jun 07 '12, 10:38 a.m.Zulchefil Ozgian
Jun 07 '12, 10:38 a.m.Zulchefil Ozgian
Jun 07 '12, 10:38 a.m.Zulchefil Ozgian
Jun 07 '12, 10:38 a.m.Zulchefil Ozgian
Jun 07 '12, 10:38 a.m.Zulchefil Ozgian
Jun 07 '12, 10:39 a.m.Zulchefil Ozgian
Jun 07 '12, 10:39 a.m.Zulchefil Ozgian
Jun 07 '12, 10:39 a.m.Zulchefil Ozgian
Jun 07 '12, 10:39 a.m.Zulchefil Ozgian
Jun 07 '12, 10:39 a.m.Zulchefil Ozgian
Jun 07 '12, 10:39 a.m.Zulchefil Ozgian
Jun 07 '12, 10:39 a.m.Zulchefil Ozgian
Jun 07 '12, 10:40 a.m.Zulchefil Ozgian
Jun 07 '12, 10:40 a.m.Zulchefil Ozgian
Jun 07 '12, 10:40 a.m.Zulchefil Ozgian
Jun 07 '12, 10:40 a.m.Zulchefil Ozgian
Jun 07 '12, 10:40 a.m.Zulchefil Ozgian
Jun 07 '12, 10:40 a.m.Zulchefil Ozgian
Jun 07 '12, 10:41 a.m.Zulchefil Ozgian
Jun 07 '12, 10:41 a.m.Zulchefil Ozgian
Jun 07 '12, 10:41 a.m.Zulchefil Ozgian
Jun 07 '12, 10:41 a.m.Zulchefil Ozgian
Jun 07 '12, 10:42 a.m.Zulchefil Ozgian
Jun 07 '12, 10:42 a.m.Zulchefil Ozgian
Jun 07 '12, 10:42 a.m.Zulchefil Ozgian
Jun 07 '12, 10:42 a.m.Zulchefil Ozgian
Jun 07 '12, 10:42 a.m.Zulchefil Ozgian
Jun 07 '12, 10:43 a.m.Zulchefil Ozgian
Jun 07 '12, 10:43 a.m.Zulchefil Ozgian
Jun 07 '12, 10:43 a.m.Zulchefil Ozgian
Jun 07 '12, 10:43 a.m.Zulchefil Ozgian
Jun 07 '12, 10:43 a.m.Zulchefil Ozgian
Jun 07 '12, 10:43 a.m.Zulchefil Ozgian
Jun 07 '12, 10:44 a.m.Zulchefil Ozgian
Jun 07 '12, 10:44 a.m.Zulchefil Ozgian
Jun 07 '12, 10:44 a.m.Zulchefil Ozgian
Jun 07 '12, 10:44 a.m.Zulchefil Ozgian
Jun 07 '12, 10:44 a.m.Zulchefil Ozgian
Jun 07 '12, 10:45 a.m.Zulchefil Ozgian
Jun 07 '12, 10:45 a.m.Zulchefil Ozgian
Jun 07 '12, 10:45 a.m.Zulchefil Ozgian
Jun 07 '12, 10:45 a.m.Zulchefil Ozgian
Jun 07 '12, 10:45 a.m.Zulchefil Ozgian
Jun 07 '12, 10:45 a.m.Zulchefil Ozgian
Jun 08 '12, 4:35 a.m.