Installation Problem

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.

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

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

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.

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.

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.

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)