repotools can't connect to the db ?
Hi
I have setup an environment with RTC2.0 server on Win 2003,sql server and WAS 7005. It's working fine :)
However, I can not use the repotools to export or import, or even use the -verify option. repotools -clean runs fine.
C:\JazzTeamServer\server>repotools -verify
Repo Tools
Rational Team Concert, Version 2.0 (I20090618-1753)
Jazz Foundation Server, Version 1.0 (I20090618-1753)
Provisioning using "C:\JazzTeamServer\server\conf\jazz\provision_profiles".
Rational Jazz Team Server - Standard
CRJAZ1363I Loading configuration from "file:conf/jazz/teamserver.properties".
CRJAZ1365I Attempting Initial Database Connection Using
Db Name/Location: //sql03.xxxx.se:1433;databaseName=PilotJazz_1;user=xxxxxxxx;
password=xxxxxxxx;
CRJAZ1093I Service failed to activate.
CRJAZ1141I Failed to get the service "com.ibm.team.repository.service.internal.rdb.IDatabaseStateSer
vice".
CRJAZ1203I Could not determine the database location.
CRJAZ1306I The service "com.ibm.team.repository.service.internal.rdb.IDatabaseStateService" is not a
vailable.
CRJAZ1204I The database "//sql03.xxxx.se:1433;databaseName=PilotJazz_1;user=xxxx
xxxx;password=xxxxxxxx;" does not exist, the database tables have not been created, or the database
user does not have the required privileges to access the database.
Repotools worked when building the tables (-createTables) but with some warnings:
CRJAZ1364I Initial database connection successful
Db Product Name: Microsoft SQL Server
Db Product Version: 9.00.3042
Db URL: jdbc:sqlserver://sql03.xxxx.se:1433;xopenStates=false;trustServerCertific
ate=false;sendStringParametersAsUnicode=true;selectMethod=direct;responseBuffering=adaptive;packetSi
ze=8000;loginTimeout=15;lockTimeout=-1;lastUpdateCount=true;encrypt=false;disableStatementPooling=tr
ue;databaseName=PilotJazz_1;applicationName=Microsoft SQL Server JDBC Driver;
Jdbc Driver Name: Microsoft SQL Server JDBC Driver 2.0
Jdbc Driver Version: 2.0.1803.100
CRJAZ8192E: Fulltext Index Location: workitemindex\fulltext_index\
Creating the tables for the database "//sql03.xxxx.se:1433;databaseName=PilotJaz
z_1;user=xxxxxxxx;password=xxxxxxxx;" with indices.
CRJAZ1257I Updating the database statistics failed.
CRJAZ1257I Updating the database statistics failed.
CRJAZ1257I Updating the database statistics failed.
CRJAZ1257I Updating the database statistics failed.
CRJAZ1257I Updating the database statistics failed.
CRJAZ1257I Updating the database statistics failed.
CRJAZ1257I Updating the database statistics failed.
The user "ADMIN" has logged in to the database "//sql03.xxxx.se:1433;databaseName=
PilotJazz_1;user=xxxxxxxx;password=xxxxxxxx;".
The user "ADMIN" has logged out of the database "//sql03.xxxx.se:1433;databaseName=
PilotJazz_1;user=xxxxxxxx;password=xxxxxxxx;".
The database tables were created successfully.
The Jazz/admin page reports all components OK (green)
Any Ideas whats wrong ?
BR
Henrik
I have setup an environment with RTC2.0 server on Win 2003,sql server and WAS 7005. It's working fine :)
However, I can not use the repotools to export or import, or even use the -verify option. repotools -clean runs fine.
C:\JazzTeamServer\server>repotools -verify
Repo Tools
Rational Team Concert, Version 2.0 (I20090618-1753)
Jazz Foundation Server, Version 1.0 (I20090618-1753)
Provisioning using "C:\JazzTeamServer\server\conf\jazz\provision_profiles".
Rational Jazz Team Server - Standard
CRJAZ1363I Loading configuration from "file:conf/jazz/teamserver.properties".
CRJAZ1365I Attempting Initial Database Connection Using
Db Name/Location: //sql03.xxxx.se:1433;databaseName=PilotJazz_1;user=xxxxxxxx;
password=xxxxxxxx;
CRJAZ1093I Service failed to activate.
CRJAZ1141I Failed to get the service "com.ibm.team.repository.service.internal.rdb.IDatabaseStateSer
vice".
CRJAZ1203I Could not determine the database location.
CRJAZ1306I The service "com.ibm.team.repository.service.internal.rdb.IDatabaseStateService" is not a
vailable.
CRJAZ1204I The database "//sql03.xxxx.se:1433;databaseName=PilotJazz_1;user=xxxx
xxxx;password=xxxxxxxx;" does not exist, the database tables have not been created, or the database
user does not have the required privileges to access the database.
CRJAZ1364I Initial database connection successful
Db Product Name: Microsoft SQL Server
Db Product Version: 9.00.3042
Db URL: jdbc:sqlserver://sql03.xxxx.se:1433;xopenStates=false;trustServerCertific
ate=false;sendStringParametersAsUnicode=true;selectMethod=direct;responseBuffering=adaptive;packetSi
ze=8000;loginTimeout=15;lockTimeout=-1;lastUpdateCount=true;encrypt=false;disableStatementPooling=tr
ue;databaseName=PilotJazz_1;applicationName=Microsoft SQL Server JDBC Driver;
Jdbc Driver Name: Microsoft SQL Server JDBC Driver 2.0
Jdbc Driver Version: 2.0.1803.100
CRJAZ8192E: Fulltext Index Location: workitemindex\fulltext_index\
Creating the tables for the database "//sql03.xxxx.se:1433;databaseName=PilotJaz
z_1;user=xxxxxxxx;password=xxxxxxxx;" with indices.
CRJAZ1257I Updating the database statistics failed.
CRJAZ1257I Updating the database statistics failed.
CRJAZ1257I Updating the database statistics failed.
CRJAZ1257I Updating the database statistics failed.
CRJAZ1257I Updating the database statistics failed.
CRJAZ1257I Updating the database statistics failed.
CRJAZ1257I Updating the database statistics failed.
The user "ADMIN" has logged in to the database "//sql03.xxxx.se:1433;databaseName=
PilotJazz_1;user=xxxxxxxx;password=xxxxxxxx;".
The user "ADMIN" has logged out of the database "//sql03.xxxx.se:1433;databaseName=
PilotJazz_1;user=xxxxxxxx;password=xxxxxxxx;".
The database tables were created successfully.
The Jazz/admin page reports all components OK (green)
Any Ideas whats wrong ?
BR
Henrik
One answer
Hi Henrik,
henrik_westrell wrote:
Are there any more details in the repotools logs? (They are generated
in the same directory as repotools.bat and named repotools_*.log by
default.)
Please open a work item against Jazz Foundation / Repository and attach
those log files.
Thanks,
Craig Chaney
Jazz server team
henrik_westrell wrote:
Hi
I have setup an environment with RTC2.0 server on Win 2003,sql server
and WAS 7005. It's working fine :)
However, I can not use the repotools to export or import, or even use
the -verify option. repotools -clean runs fine.
Are there any more details in the repotools logs? (They are generated
in the same directory as repotools.bat and named repotools_*.log by
default.)
Please open a work item against Jazz Foundation / Repository and attach
those log files.
Thanks,
Craig Chaney
Jazz server team
C:\JazzTeamServer\server>repotools -verify
Repo Tools
Rational Team Concert, Version 2.0 (I20090618-1753)
Jazz Foundation Server, Version 1.0 (I20090618-1753)
Provisioning using
"C:\JazzTeamServer\server\conf\jazz\provision_profiles".
Rational Jazz Team Server - Standard
CRJAZ1363I Loading configuration from
"file:conf/jazz/teamserver.properties".
CRJAZ1365I Attempting Initial Database Connection Using
Db Name/Location:
//sql03.xxxx.se:1433;databaseName=PilotJazz_1;user=xxxxxxxx;
password=xxxxxxxx;
CRJAZ1093I Service failed to activate.
CRJAZ1141I Failed to get the service
"com.ibm.team.repository.service.internal.rdb.IDatabaseStateSer
vice".
CRJAZ1203I Could not determine the database location.
CRJAZ1306I The service
"com.ibm.team.repository.service.internal.rdb.IDatabaseStateService"
is not a
vailable.
CRJAZ1204I The database
"//sql03.xxxx.se:1433;databaseName=PilotJazz_1;user=xxxx
xxxx;password=xxxxxxxx;" does not exist, the database tables have
not been created, or the database
user does not have the required privileges to access the database.
Repotools worked when building the tables
(-createTables) but with some warnings:
CRJAZ1364I Initial database connection successful
Db Product Name: Microsoft SQL Server
Db Product Version: 9.00.3042
Db URL:
jdbc:sqlserver://sql03.xxxx.se:1433;xopenStates=false;trustServerCertific
ate=false;sendStringParametersAsUnicode=true;selectMethod=direct;responseBuffering=adaptive;packetSi
ze=8000;loginTimeout=15;lockTimeout=-1;lastUpdateCount=true;encrypt=false;disableStatementPooling=tr
ue;databaseName=PilotJazz_1;applicationName=Microsoft SQL Server JDBC
Driver;
Jdbc Driver Name: Microsoft SQL Server JDBC Driver 2.0
Jdbc Driver Version: 2.0.1803.100
CRJAZ8192E: Fulltext Index Location: workitemindex\fulltext_index\
Creating the tables for the database
"//sql03.xxxx.se:1433;databaseName=PilotJaz
z_1;user=xxxxxxxx;password=xxxxxxxx;" with indices.
CRJAZ1257I Updating the database statistics failed.
CRJAZ1257I Updating the database statistics failed.
CRJAZ1257I Updating the database statistics failed.
CRJAZ1257I Updating the database statistics failed.
CRJAZ1257I Updating the database statistics failed.
CRJAZ1257I Updating the database statistics failed.
CRJAZ1257I Updating the database statistics failed.
The user "ADMIN" has logged in to the database
"//sql03.xxxx.se:1433;databaseName=
PilotJazz_1;user=xxxxxxxx;password=xxxxxxxx;".
The user "ADMIN" has logged out of the database
"//sql03.xxxx.se:1433;databaseName=
PilotJazz_1;user=xxxxxxxx;password=xxxxxxxx;".
The database tables were created successfully.
The Jazz/admin page reports all components OK (green)
Any Ideas whats wrong ?
BR
Henrik