It's all about the answers!

Ask a question

RTC 3.0.1 : error creating tables.


Yerko Munoz (122) | asked May 10 '12, 6:20 p.m.
Hi everyone:

I'm trying to manually creat tables for Team Concert, but with no success.

I have:

C:\IBM\JazzTeamServer\server>repotools-jts.bat -createTables -clean
Repo Tools
Provisioning using "C:\IBM\JazzTeamServer\server\conf\jts\provision_profiles".
Jazz Foundation - Core Libraries, Version 3.0.1 (RJF-I20110602-0017)

CRJAZ1363I Loading the configuration from "file:conf/jts/teamserver.properties".

CRJAZ1779I This server is configured as a JTS.
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 mana
gement in the application. The public URI represents the URL that all clients m
ust use to access the application.
CRJAZ1365I The server is attempting to connect to the following database: "thin:
xxxxxxxx@//172.30.21.23:1531/APL"
CRJAZ0503I The server was unable to connect to the following database: "thin:*
xxxxx@//172.30.21.23:1531/APL" Exception:
"Io exception: The Network Adapter could not establish the connection"
CRJAZ1093I The following service class was not activated: "com.ibm.team.reposito
ry.service.internal.schemagen.PersistentMappingService"
CRJAZ1364I The connection to the following database was successful:
Db Product Name: Oracle
Db Product Version: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0
- 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
Db URL: jdbc:oracle:thin:xxxxxxxx@//172.30.21.23:1531/APL
Jdbc Driver Name: Oracle JDBC driver
Jdbc Driver Version: 11.1.0.6.0-Production
CRJAZ1141I Cannot get the service "com.ibm.team.repository.service.internal.rdb.
IDatabaseStateService".
CRJAZ1203I Could not determine the database location.
CRJAZ1306I The service "com.ibm.team.repository.service.internal.rdb.IDatabaseSt
ateService" is not available.
Creating the tables for the database "thin:xxxxxxxx@//172.30.21.23:1531/APL" wit
h indices.
CRJAZ1141I Cannot get the service "com.ibm.team.repository.service.internal.rdb.
IDatabaseCreationService".
CRJAZ1309I The database connectivity service is not ready.
The database tables were not created.


Any idea of what's happening? Is it JDBC driver version?

3 answers



permanent link
Ralph Schoon (63.4k33646) | answered May 13 '12, 10:17 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
I am not sure, the error message explains you have to run step 1 of the setup wizard to set the public URI first. You can stop after running that step and try to create the tables manually.

This might be due to the fact that it is not possible to change the URI later and you have to check a checkbox that you are aware of it and are really, really sure you want to use the host name and port.....

At least that is what I would try.

permanent link
Geoffrey Clemm (30.1k33035) | answered May 13 '12, 11:25 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
For context, why are you creating the tables manually rather than using the setup wizard?

Cheers,
Geoff

I am not sure, the error message explains you have to run step 1 of the setup wizard to set the public URI first. You can stop after running that step and try to create the tables manually.

This might be due to the fact that it is not possible to change the URI later and you have to check a checkbox that you are aware of it and are really, really sure you want to use the host name and port.....

At least that is what I would try.

permanent link
Ralph Schoon (63.4k33646) | answered May 13 '12, 12:15 p.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
Another thought. You use oracle. I have heated from others that it is sensitive to issues with the connection string. There are also additional attributes that are needed for Oracle. Please look into the initial team server.properties for them. Check with the online help again and review the connection string. The error indicates that the database could not be connected. Drivers is another issue I have hearted too, in the past.

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.