repotools-jazz -addTables fails in upgrade from 2.x to 3.0
I'm upgrading RTC on Windows 2008 server, from 2.x to 3.0 As usual, many times scripts fail, apparently because of the lack of testing on Windows computers. For example, the migration command could not migrate Tomcat settings because it was confused by the standard windows "program files" path. In any case, having got past those sorts of troubles, I'm stuck on the new database creation as specified here:
As the log below shows, the script can connect to the database, but then fails. I assumed it was a SQL Server permission problem. However, after changing permissions and delete/creating the database a few times, it appears that there's a problem with the script.
Any idea of what the issues might be?
2013-05-20 11:40:06,822 The bundle com.ibm.team.workitem.sample.money is STARTED.
2013-05-20 11:40:06,832 repotools-jazz -addTables
2013-05-20 11:40:06,832 Change and Configuration Management - Core Libraries, Version 3.0 (RTC-I20101112-1731)
Jazz Foundation - Core Libraries, Version 3.0 (RJF-I20101112-0630)
2013-05-20 11:40:06,841 CRJAZ1363I Loading the configuration from "file:conf/jazz/teamserver.properties".
2013-05-20 11:40:07,235 CRJAZ1781W The Public URI Root has not been set. Use the server setup wizard to enter the public URI. This property is required to enforce consistent URL management in the application. The public URI represents the URL that all clients must use to access the application.
2013-05-20 11:40:07,247 CRJAZ1778I This server is configured as an application.
2013-05-20 11:40:09,396 CRJAZ1365I The server is attempting to connect to the following database: "//localhost:1433;databaseName=jazzXXX;user=xxxxxxxx;password=xxxxxxxx;"
2013-05-20 11:40:09,756 CRJAZ1364I The connection to the following database was successful:
Db Product Name: Microsoft SQL Server
Db Product Version: 10.00.5512
Db URL: jdbc:sqlserver://localhost:1433;databaseName=jazzXXX;user=xxxxxxxx;password=xxxxxxxx;
Jdbc Driver Name: Microsoft SQL Server JDBC Driver 2.0
Jdbc Driver Version: 2.0.1803.100
2013-05-20 11:40:10,262 CRJAZ8192I: Fulltext Index Location: C:\Program Files\IBM\JazzTeamServer3\server\conf\jazz\indices\workitemindex\fulltext_index
2013-05-20 11:40:10,412 CRJAZ1204I The database "//localhost:1433;databaseName=jazzv3;user=xxxxxxxx;password=xxxxxxxx;" does not exist, the database tables have not been created, or the database user does not have the required privileges to access the database.
2013-05-20 11:40:10,413 Failed to add tables to the database. The database has not been modified.
2 answers
Have you modified your com.ibm.team.repository.db.jdbc.location propery in teamserver.properties? Can you double check if it is correct? Possibly there is any typo in database location.
The problem was that I followed the instructions (which are incorrect):
Rather than -addTables, the command should be -createTables, as described here:
Continuing with the instructions, it appears that the migration instructions are also incorrect.
1. Open a command window and go to the <RTC3.0_install_dir>/server directory. Run the following command to add tables to the database:
repotools-jazz -addTables
2. Run the following command to export user information from the RTC database:
repotools-jazz -migration_exportJTSData toFile=jtsData.tar
Notice that step 2 is in the directory of the new repository, and thus exports no old data.
The link is here: