2. I think I need to configure the teamserver.properties with an explicit path to the oracle driver (<jazz_root>/server/oracle/ojdbc14.jar)? But I see no string for this. See error message below from WAS jazz.log file.

Thanks,
Bill

java.lang.IllegalStateException: CRJAZ0808I The driver "oracle.jdbc.OracleDriver" could not be loaded and registered. Support for some database vendors requires th
at the JDBC driver JAR be provided in a path configured by the server scripts. If you are experiencing problems changing the database vendor, refer to the product
setup instructions for more information.

Hi Bill

Did you start using the oracle teamserver.properties example as the basis for your teamserver.properties file? There is an example in your server installation directory (C:\jazz\server\conf\jazz on my machine) that you need to use.

Running setup (https://<servername>:9443/jazz/setup with user/password ADMIN/ADMIN should also help you configure the Oracle db properly.

anthony

Hi,

The URL should be the same in WAS. /jazz/web or /jazz/admin for 2.x

Hi Bill

Did you start using the oracle teamserver.properties example as the basis for your teamserver.properties file? There is an example in your server installation directory (C:\jazz\server\conf\jazz on my machine) that you need to use.

Running setup (https://<servername>:9443/jazz/setup with user/password ADMIN/ADMIN should also help you configure the Oracle db properly.

anthony

Hi Anthony,

Yes I did, however I did find a few discrepancies and have corrected them. A copy of my new teamserver.properties file is below. As for setting up Oracle. I can run Jazz stand alone with the file below and it comes up fine. The DB was imported from a working instance of Oracle. So I am assuming that the DB is correctly configured. The commented out sections are what we are using currently.

I am able to see a "green arrow" for the jazz app in WAS. But my problem still remains a rather simple one... Where do I go to see the jazz web pages, what is the URL under WAS? I can then start doing a better job of troubleshooting.

Thanks,
Bill

#This configuration update was requested by "leonej01". The old contents of this file
copied to "/opt/jazz/server/conf/jazz/teamserver-1260472780559bakup.properties".
#Thu Dec 10 11:19:40 PST 2009

# These items are from the exitisting Derby Instace that was transfered
#com.ibm.team.repository.changeEvent.expirationByCategory=SystemLog\:259200
#com.ibm.rational.cm.web.component.cqweb.configuration.enabled=true
#com.ibm.team.repository.ws.allow.identity.assertion=false
#com.ibm.team.repository.changeEvent.expirationDefault=1209600
#com.ibm.rational.cm.web.component.cqweb.userdb=UNITY
#com.ibm.rational.cm.web.component.cqweb.schema=7.1.0
#com.ibm.team.repository.db.jdbc.location=/opt/jazz/server/repositoryDB
#}
#com.ibm.rational.cm.web.component.cqweb.server.name=ussycqweb01
#com.ibm.team.repository.licenseService.floatingLicenseServerURI=http\://localhost\:90
#com.ibm.team.repository.user.registry.type=TOMCAT
#com.ibm.team.repository.changeEvent.expirationByType=com.ibm.team.workitem.WorkItem\:

#com.ibm.team.build.BuildResult\:172800

# All items below from teamserver.oracle.properties
# Required for Oracle DB
com.ibm.team.repository.db.vendor=ORACLE
com.ibm.team.repository.db.jdbc.location=thin\:<yyyyy>/{password}@//ussy-qumasdevora\:1
uest
com.ibm.team.repository.db.jdbc.password=xxxxxxx

# Set to true only during development to avoid having to set J2EE configuration
com.ibm.team.repository.ws.allow.admin.access=false

# Used for product packaging
com.ibm.team.repository.web.pageorder={"com.ibm.team.repository.web.admin": \
, \
"com.ibm.team.process.web.projectArea": \
, \
"com.ibm.team.process.web.projectAreaList": \
}

com.ibm.team.repository.web.suppressedPages={"com.ibm.team.repository.web.admin": \
com.ibm.team.repository.web.helpuri=http\://publib.boulder.ibm.com/infocenter/rtc/v2r0
x.jsp

# Fulltest index location
com.ibm.team.fulltext.indexLocation=/opt/jazz/server/workitemindex

Hi,

"loading.." means you get something of the application so at least something must be working OK.
Ports etc is something that needs to be set in the WAS profile.

Please check the teamserver.properties for paths. If you run in WAS all the relative paths need to be made absolute.

You might have already used this but here is a hint anyway: http://jazz.net/library/techtip/321.

It is very important to install the necessary patches for WAS, included the update for java if RTC is supposed to run correctly.

Ralph

Hi,

The URL should be the same in WAS. /jazz/web or /jazz/admin for 2.x

Thanks Rschoon.

I used https://<servername>:9443/jazz/web but just got "loading..."
The ports for this appserver are 9080 for HTTP transport and 9443 for HTTPS transport. An interesting coincidence? If I had used a different appserver... the port would need to be changed?

Also the jazz.log is empty. Nothing is reported when I try to connect.

the teamserver.profile above works with stand alone RTC.

So I am still where I was before. WAS says that the jazz_war is running but I get nothing when I try and connect.

Thanks,
bill