CRJAZ1726E CRJAZ2654E SQLSTATE: 08004, SQLCODE: -4499 failed during register applications for (QM and CMM)
Hello,
This is my third Engineering Lifecycle Management setup on Windows. First two went with no problems.
This time I failed during register applications for (QM and CMM) the others worked.
The applications could not be registered with Jazz Team Server.ID CRJAZ1726Ehide details
Request to service https://172.17.110.50:9443/ccm/service/com.ibm.team.repository.service.internal.setup.IRegistrationHandlerService failed with status code 500 and response body: Error 500: Required service (IInternalOAuthConsumerRegistrationService) not available Caused by: Required service (IInternalOAuthConsumerRegistrationService) not available
I even tried to recreate the DB just in case that was the problme.
But when I run the reptools-ccm -createTables, I get following errors too.
c:\Program Files\IBM\JazzTeamServer\server>repotools-ccm -createTables
Repo Tools
Provisioning using "c:\Program Files\IBM\JazzTeamServer\server\conf\ccm\provision_profiles".
To submit questions about issues, go to the Jazz.net forum at https://jazz.net/forum.
To find more information about a message, see the online product documentation.
CRJAZ1363I Loading the configuration from "file:conf/ccm/teamserver.properties".
CRJAZ1778I This server is configured as an application.
CRJAZ2558I Setting the local server rename state to false and the openServerDescriptionServiceTemporarily state to false.
CRJAZ1365I The server is attempting to connect to the following database: "//172.17.110.50:25000/JAZZ:user=xxxxxxxx;password=xxxxxxxx;"
CRJAZ2654E The server was unable to connect to the database because the database connection settings are invalid or because database is unreachable (SQLSTATE: 08004, SQLCODE: -4499). Verify the connection settings in your teamserver.properties file. See the Jazz Team Server log for more information.
CRJAZ0503E The server was unable to connect to the database. Exception:
I have search the web for a solution.
increase the Db2 STMTHEAP size to avoid getting the warning.
I have verified cmm and qm teamserver.properties
I have set up the DB2 entries:
#Data Warehouse Automatic Setup - Set this to false if you have already created the data warehouse manually
com.ibm.team.datawarehouse.db.automatic.setup = true
#
# DB2 configuration
#
# Comment out the above lines, uncomment the following five database properties
# and customize the example database location to use DB2.
# NOTE THAT EVERY APPLICATION INSTANCE AND JAZZ TEAM SERVER REQUIRES ITS OWN UNIQUE DATABASE.
com.ibm.team.repository.db.vendor = DB2
com.ibm.team.repository.db.jdbc.location=//172.17.110.50:25000/JTS:user=db2admin;password={password};
com.ibm.team.repository.db.jdbc.password=<PASSWORD>
com.ibm.team.datawarehouse.db.vendor = DB2
com.ibm.team.datawarehouse.db.jdbc.location=//172.17.110.50:25000/JTS:user=db2admin;password={password};
com.ibm.team.datawarehouse.db.jdbc.password=<PASSWORD>
# The path where the warehouse tablespace should be created
com.ibm.team.datawarehouse.db.base.folder = C:\\jazzdw\\tempspace32k
# The database user for whom proper permissions will be granted
com.ibm.team.datawarehouse.report.user = RPTUSER
# DB2 requires a path where the content tablespace should be created, examples for Win and Linux follow
com.ibm.team.repository.db.db2.content.tablespace.location=c:\\db2\\jts\\content_tablespace
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
# Fulltext index location
com.ibm.team.fulltext.indexLocation=c:/Program Files/IBM/JazzTeamServer/server/conf/jts/indices/workitemindex
# Location of JFS index root directory
com.ibm.team.jfs.index.root.directory=c:/Program Files/IBM/JazzTeamServer/server/conf/jts/indices
A little assistance would be appreciated. The weird part all the others worked with similar setup.
I will move on to create my 4th ELM (hopefully no problems there)
Thank you in advance
Carmen
One answer
At a quick glance I see two possible issues in your setup.
This line:
com.ibm.team.repository.db.jdbc.location=//172.17.110.50:25000/JTS:user=db2admin;password={password};
is OK BUT your error message says:
CRJAZ1365I The server is attempting to connect to the following database: "//172.17.110.50:25000/JAZZ:user=xxxxxxxx;password=xxxxxxxx;"
This refers to database JAZZ where your setup line refers to JTS' they should both eithee be JAZZ or JTS.
There's also an issue with this:
com.ibm.team.datawarehouse.db.jdbc.location=//172.17.110.50:25000/JTS:user=db2admin;password={password};
As this is for the data warehouse it shouldn't be referring to the JTS database, but to the data warehouse database e.g. DW (i.e. the database you created for the data warehouse).
Comments