It's all about the answers!

Ask a question

Installation Problem


James Garrison (4111) | asked Aug 11 '10, 6:49 p.m.
I'm evaluating RTC Standard 2.0.0.2i3, and I'm following the instructions for installing RTC server on Windows with Oracle. I get a successful DB connection, but then I get a failure when executing the "Create Tables" step (error below). The only reference to this message ID on the web is http://www-01.ibm.com/support/docview.wss?uid=swg21418911, which relates to Derby, not Oracle.

If I click on the "Test Connection" button I get

The database exists, but is not configured to contain Jazz. Use the "Create Tables" button in Step 2.3 to configure the database for Jazz.


I have verified that I can connect to the Oracle user with the configured username and password (using SQLDeveloper), and that it has the required permissions as described in the setup instructions.

I have a short deadline for a presentation to Management, and really need to get past this point. Suggestions?

CRJAZ1173I Service "com.ibm.team.repository.service.internal.IDatabaseCreationRestService" is not available.

java.lang.Exception
com.ibm.team.repository.common.transport.ServerHttpUtil.serializeError(ServerHttpUtil.java:1093)
com.ibm.team.repository.servlet.AbstractTeamServerServlet.handleException(AbstractTeamServerServlet.java:1159)
com.ibm.team.repository.servlet.AbstractTeamServerServlet.handleRequest2(AbstractTeamServerServlet.java:1718)
com.ibm.team.repository.servlet.AbstractTeamServerServlet.handleRequest(AbstractTeamServerServlet.java:1642)
com.ibm.team.repository.servlet.AbstractTeamServerServlet.service(AbstractTeamServerServlet.java:1555)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
org.eclipse.equinox.http.registry.internal.ServletManager$ServletWrapper.service(ServletManager.java:180)
org.eclipse.equinox.http.servlet.internal.ServletRegistration.handleRequest(ServletRegistration.java:90)
org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:111)
org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:75)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
org.eclipse.equinox.servletbridge.BridgeServlet.service(BridgeServlet.java:121)
com.ibm.team.repository.server.servletbridge.JazzServlet.service(JazzServlet.java:54)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:525)
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:873)
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
java.lang.Thread.run(Thread.java:811)

7 answers



permanent link
James Garrison (4111) | answered Aug 13 '10, 12:29 p.m.
I filed a bug on this, (http://jazz.net/jazz/web/projects/Rational%20Team%20Concert#action=com.ibm.team.workitem.viewWorkItem&id=126065). The problem with Oracle is that it checks specifically for Oracle 10 and refuses to start if it finds Oracle 11. The solution is to add

com.ibm.team.repository.db.override.versioncheck=true



to teamserver.properties.

The problem with SQLServer seems to a codepage mismatch for which no solution is yet available.

permanent link
James Garrison (4111) | answered Aug 13 '10, 11:44 a.m.
I was able to get it working with Derby, nothing special required. That's not a usable long-term solution, obviously.

Here's a copy of my Oracle teamserver.properties (comments and blank lines removed)

com.ibm.team.repository.db.vendor = ORACLE

com.ibm.team.repository.db.jdbc.location=thin:teamconcert/{password}@//blanco:1521/dev11gr2.hq.troux.com
com.ibm.team.repository.db.jdbc.password=teamconcert
com.ibm.team.repository.ws.allow.identity.assertion = false
com.ibm.team.repository.web.pageorder = {"com.ibm.team.repository.web.admin": \
["com.ibm.team.repository.server", \
"com.ibm.team.process.admin"], \
"com.ibm.team.process.web.projectArea": \
["com.ibm.team.dashboard", \
"com.ibm.team.workitem", \
"com.ibm.team.apt", \
"com.ibm.team.scm", \
"com.ibm.team.reports"],\
"com.ibm.team.process.web.projectAreaList": \
["com.ibm.team.repository.web.projectAreaList"]}
com.ibm.team.repository.web.suppressedPages = {"com.ibm.team.repository.web.admin": \
["com.ibm.team.repository.provision"]}
com.ibm.team.repository.web.helpuri = http://publib.boulder.ibm.com/infocenter/rtc/v2r0m0/index.jsp
com.ibm.team.repository.changeEvent.expirationDefault = 1209600
com.ibm.team.repository.changeEvent.expirationByType = com.ibm.team.workitem.WorkItem:5184000 com.ibm.team.build.BuildResult:172800
com.ibm.team.repository.changeEvent.expirationByCategory = SystemLog:259200
com.ibm.team.fulltext.indexLocation=workitemindex

permanent link
Ralph Schoon (63.0k33645) | answered Aug 13 '10, 8:55 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
Hi,

this is strange. Could you anonymize you teamserver,properties and post it here.

This indicates the database location can't be found.

That you can't get it running for any DB could also indicate that the network does not allow the connection. Are there any logs on the ports? Anything in addition in the Jazz logs (server/logs)?

Jdbc Driver Version: 3.0.1301.101
CRJAZ1093I Service class "com.ibm.team.repository.service.internal.schemagen.PersistentMappingService" failed to activate.
CRJAZ1141I Failed to 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.IDatabaseStateService" is not available.
Creating the tables for the database "//localhost:1433;databaseName=jazz;user=xxxxxxxx;password=xxxxxxxx;" with indices.
CRJAZ1141I Failed to get the service "com.ibm.team.repository.service.internal.rdb.IDatabaseCreationService".

permanent link
James Garrison (4111) | answered Aug 12 '10, 3:05 p.m.
Fails with SQLServer also. Again, I have verified that I can connect to the DB (MSSQLServer on localhost this time), and the messages indicate that the initial connection is successful:

C:\rtc\jazz\server>repotools -createTables
Repo Tools
Rational Team Concert, Version 2.0.0.2 iFix 3 (I20100602-1000)
Jazz Foundation - Jazz Team Server, Version 1.0.0.2 iFix 3 (I20100602-1000)

Rational Jazz Team Server - Standard
CRJAZ1363I Loading configuration from "file:conf/jazz/teamserver.properties".
CRJAZ1365I Attempting Initial Database Connection Using
Db Name/Location: //localhost:1433;databaseName=jazz;user=xxxxxxxx;password=xxxxxxxx;
CRJAZ1364I Initial database connection successful
Db Product Name: Microsoft SQL Server
Db Product Version: 10.00.2531
Db URL: jdbc:sqlserver://localhost:1433;xopenStates=false;sendTimeAsDatetime=true;trustServerCertificate=false;sendStringParametersAsUnicode=true;selectMethod
=direct;responseBuffering=adaptive;packetSize=8000;loginTimeout=15;lockTimeout=-1;lastUpdateCount=true;encrypt=false;disableStatementPooling=true;databaseName=j
azz;applicationName=Microsoft SQL Server JDBC Driver;
Jdbc Driver Name: Microsoft SQL Server JDBC Driver 3.0
Jdbc Driver Version: 3.0.1301.101
CRJAZ1093I Service class "com.ibm.team.repository.service.internal.schemagen.PersistentMappingService" failed to activate.
CRJAZ1141I Failed to 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.IDatabaseStateService" is not available.
Creating the tables for the database "//localhost:1433;databaseName=jazz;user=xxxxxxxx;password=xxxxxxxx;" with indices.
CRJAZ1141I Failed to 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.

permanent link
James Garrison (4111) | answered Aug 12 '10, 11:44 a.m.
As a test I also tried different versions of the Oracle JDBC drivers:

    ojdbc14.jar
    ojdbc5.jar
    ojdbc6.jar

The only one that was able to connect to the database was ojdbc14.jar.

permanent link
James Garrison (4111) | answered Aug 12 '10, 11:12 a.m.
Here's the output from repotools -createTables. The system is a Core i7-920, 12GB, Win7pro-x64

C:\rtc\jazz\server>repotools -createTables

Repo Tools
Jazz Foundation - Jazz Team Server, Version 1.0.0.2 iFix 3 (I20100602-1000)
Rational Team Concert, Version 2.0.0.2 iFix 3 (I20100602-1000)

Rational Jazz Team Server - Standard
CRJAZ1363I Loading configuration from "file:conf/jazz/teamserver.properties".
CRJAZ1365I Attempting Initial Database Connection Using
Db Name/Location: thin:xxxxxxxx/xxxxxxxx@blanco:1521/dev11gr2.hq.troux.com
CRJAZ1364I Initial database connection successful
Db Product Name: Oracle
Db Product Version: Oracle Database 11g Release 11.1.0.0.0 - Production
Db URL: jdbc:oracle:thin:teamconcert/teamconcert@blanco:1521/dev11gr2.hq.troux.com
Jdbc Driver Name: Oracle JDBC driver
Jdbc Driver Version: 10.2.0.3.0
CRJAZ1093I Service class "com.ibm.team.repository.service.internal.schemagen.PersistentMappingService" failed to activate.
CRJAZ1141I Failed to 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.IDatabaseStateService" is not available.
Creating the tables for the database "thin:xxxxxxxx/xxxxxxxx@blanco:1521/dev11gr2.hq.troux.com" with indices.
CRJAZ1141I Failed to 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.

permanent link
Ralph Schoon (63.0k33645) | answered Aug 12 '10, 5:05 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
Hi,

hard to tell what the issue is. did you follow the instruction on how to setup the Oracle DB? Have you looked into the ORACLE log files?

You can also use the repotools -createTable command in a console. Maybe this gives you more information.

Also in the past it was the best way to start with the teamserver.oracle.properties, copy it to teamserver.properties, edit it that manually to provide the connection infos needed for your DB and run repotools -createTables before running the Web setup app.

Just some options,

Ralph

I'm evaluating RTC Standard 2.0.0.2i3, and I'm following the instructions for installing RTC server on Windows with Oracle. I get a successful DB connection, but then I get a failure when executing the "Create Tables" step (error below). The only reference to this message ID on the web is http://www-01.ibm.com/support/docview.wss?uid=swg21418911, which relates to Derby, not Oracle.

If I click on the "Test Connection" button I get

The database exists, but is not configured to contain Jazz. Use the "Create Tables" button in Step 2.3 to configure the database for Jazz.


I have verified that I can connect to the Oracle user with the configured username and password (using SQLDeveloper), and that it has the required permissions as described in the setup instructions.

I have a short deadline for a presentation to Management, and really need to get past this point. Suggestions?

CRJAZ1173I Service "com.ibm.team.repository.service.internal.IDatabaseCreationRestService" is not available.

java.lang.Exception
com.ibm.team.repository.common.transport.ServerHttpUtil.serializeError(ServerHttpUtil.java:1093)
com.ibm.team.repository.servlet.AbstractTeamServerServlet.handleException(AbstractTeamServerServlet.java:1159)
com.ibm.team.repository.servlet.AbstractTeamServerServlet.handleRequest2(AbstractTeamServerServlet.java:1718)
com.ibm.team.repository.servlet.AbstractTeamServerServlet.handleRequest(AbstractTeamServerServlet.java:1642)
com.ibm.team.repository.servlet.AbstractTeamServerServlet.service(AbstractTeamServerServlet.java:1555)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
org.eclipse.equinox.http.registry.internal.ServletManager$ServletWrapper.service(ServletManager.java:180)
org.eclipse.equinox.http.servlet.internal.ServletRegistration.handleRequest(ServletRegistration.java:90)
org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:111)
org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:75)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
org.eclipse.equinox.servletbridge.BridgeServlet.service(BridgeServlet.java:121)
com.ibm.team.repository.server.servletbridge.JazzServlet.service(JazzServlet.java:54)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:525)
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:873)
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
java.lang.Thread.run(Thread.java:811)

Your answer


Register or to post your answer.