Cannot create jazz database tables - SQL Server

Hello,

We are trying to setup the RQM database tables using SQL Server for RQM version 3.0.1.

We downloaded the most recent jdbc driver and placed it in the $JazzInstallDirectory/server/sqlserver/

We updated the teamserver.properties file to point to the new database

We updated the server.startup file to poitn to the new jdbc driver.

When we run ./repotools-qm.sh -createTables we are getting the following output to the screen.


These 2 lines stand out to me from the screen output
CRJAZ1093I The following service class was not activated: "com.ibm.team.repository.service.internal.schemagen.PersistentMappingService"
CRJAZ1141I Cannot get the service "com.ibm.team.repository.service.internal.rdb.IDatabaseStateService".
CRJAZ1203I Could not determine the database location.



09:14:53,559 WARN ository.common.transport.AbstractElementDescriptor - The com.ibm.team.datawarehouse.service.rqm bundle's plugin.xml uses the component id "com.ibm.team.datawarehouse" as the prefix to a <configurationProperty> element's "name" attribute with the value "com.ibm.team.datawarehouse.service.rqm.configurationProperty1".
09:14:53,560 WARN ository.common.transport.AbstractElementDescriptor - The com.ibm.team.datawarehouse.service.rqm bundle's plugin.xml uses the component id "com.ibm.team.datawarehouse" as the prefix to a <configurationProperty> element's "name" attribute with the value "com.ibm.team.datawarehouse.service.rqm.configurationProperty1".
Repo Tools
Provisioning using "./conf/qm/provision_profiles".
Jazz Foundation - Core Libraries, Version 3.0.1 (RJF-I20110602-0017)
Quality Management - Core Libraries, Version 3.0.1 (I20110602_0806)

CRJAZ1363I Loading the configuration from "file:conf/qm/teamserver.properties".
CRJAZ1778I This server is configured as an application.
CRJAZ1781W The Public URI Root has not been set. Use the server setup wizard to enter the public URI. This property is required to enforce consistent URL management in the application. The public URI represents the URL that all clients must use to access the application.
CRJAZ1365I The server is attempting to connect to the following database: "//143.61.249.198:1433;databaseName=jazz;user=xxxxxxxx;password=xxxxxxxx;"
CRJAZ1364I The connection to the following database was successful:
Db Product Name: Microsoft SQL Server
Db Product Version: 10.00.4311
Db URL: jdbc:sqlserver://143.61.249.198:1433;databaseName=jazz;user=xxxxxxxx;password=xxxxxxxx;
Jdbc Driver Name: Microsoft SQL Server JDBC Driver 3.0
Jdbc Driver Version: 3.0.1301.101
CRJAZ1093I The following service class was not activated: "com.ibm.team.repository.service.internal.schemagen.PersistentMappingService"
CRJAZ1141I Cannot 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 "//143.61.249.198:1433;databaseName=jazz;user=xxxxxxxx;password=xxxxxxxx;" with indices.
CRJAZ1141I Cannot 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.

According to the help you need to create a system variable:

If you are connecting to your SQL Server database using WebSphere Application Server with JRE 6.0 or if you want to configure your Tomcat server to use Java Runtime Environment 6.0, perform the following steps:

Set the SQLSERVER_JDBC_DRIVER_FILE variable to point to the JRE 6.0 version of the JDBC driver named sqljdbc4.jar. This driver can be installed in a directory of your choice on the application server.
Set both repotools-jts.bat and repotools-<application>.bat to point to the new JRE. Open each file, search for set JAVA, and replace it with the path to the alternate JVM. For example, set JAVA=<Path>/jre/bin/java.

If you are connecting to your SQL Server database using WebSphere Application Server with JRE 5.0 or the packaged Tomcat, perform the following step:

Set the SQLSERVER_JDBC_DRIVER_FILE variable to point to the JRE 5.0 version of the JDBC driver named sqljdbc.jar. This driver can be installed in a directory of your choice on the application server.

Note: To avoid problems, do not use spaces in file paths. For the Program Files directory on 32-bit systems, you can use PROGRA~1. For the Program Files (x86) directory on 64-bit systems, you can use PROGRA~2.

rem The following four environment variables (*_ABSPATH) are used to point to a

rem directory that contains the appropriate JDBC jar file supplied by the

rem database vendor.  Users may set these variables; if they are set, the script

rem will respect their value.  If they are unset, we look in a directory under

rem <JazzInstallDir>/server by default.  (For example, the default location for

rem the Oracle JDBC driver is under <JazzInstallDir>/server/oracle).

Hi,

Which file does that SQLSERVER_JDBC_DRIVER_FILE variable go in?

server.startup? teamserver.properties?

Thanks in advance.

The "happy path" is to just put the driver in \sqlserver. Then you don't need to muck with any scripts or env variables.

If that is not an option and you are starting the server from the command line, then just added it to the server.startup and repotools scripts. You'll find references to the driver path in there already, for instance (taken from repotools-qm,bat):

rem The following four environment variables (*_ABSPATH) are used to point to a

rem directory that contains the appropriate JDBC jar file supplied by the

rem database vendor.  Users may set these variables; if they are set, the script

rem will respect their value.  If they are unset, we look in a directory under

rem <JazzInstallDir>/server by default.  (For example, the default location for

rem the Oracle JDBC driver is under <JazzInstallDir>/server/oracle).

Hi,

Which file does that SQLSERVER_JDBC_DRIVER_FILE variable go in?

server.startup? teamserver.properties?

Thanks in advance.

The "happy path" is to just put the driver in \sqlserver. Then you don't need to muck with any scripts or env variables.

If that is not an option and you are starting the server from the command line, then just added it to the server.startup and repotools scripts. You'll find references to the driver path in there already, for instance (taken from repotools-qm,bat):

rem The following four environment variables (*_ABSPATH) are used to point to a

rem directory that contains the appropriate JDBC jar file supplied by the

rem database vendor.  Users may set these variables; if they are set, the script

rem will respect their value.  If they are unset, we look in a directory under

rem <JazzInstallDir>/server by default.  (For example, the default location for

rem the Oracle JDBC driver is under <JazzInstallDir>/server/oracle).

Hi,

Which file does that SQLSERVER_JDBC_DRIVER_FILE variable go in?

server.startup? teamserver.properties?

Thanks in advance.

CRJAZ1093I The following service class was not activated: "com.ibm.team.repository.service.internal.schemagen.PersistentMappingService"

CRJAZ1141I Cannot 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=jts;user=xxxxxxxx;password=xxxxxxxx;" with indices.

CRJAZ1141I Cannot 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.