Using db2 as database in 3.0 rc0
When installing 3.0 rc0 I tried to use DB2 9.7 as the database. I created the DBs for JTS, RM, CCM, QM and datawarehouse. I used the repotools for each of the respectively.
When going through the configuration and trying to set the DW database it warns me that the tables are not created and it will create them. Shortly after starting with that i get this:
Now the documentation is a little unclear for this step.. Can someone provide some clarification?
When going through the configuration and trying to set the DW database it warns me that the tables are not created and it will create them. Shortly after starting with that i get this:
An error occurred while creating data warehouse tables. Please try again.ID CRJAZ1745E
hide details
The database creation failed with an exception
com.ibm.team.repository.common.TeamRepositoryException: CREATE TEMPORARY TABLESPACE TEMPSPACE32K IN DATABASE PARTITION GROUP IBMTEMPGROUP PAGESIZE 32768 MANAGED BY SYSTEM USING ('/jazzdw/tempspace32k') BUFFERPOOL BPTEMP32K at com.ibm.team.datawarehouse.service.AbstractDataWarehouseVendor.executeSql(AbstractDataWarehouseVendor.java:124) at
Now the documentation is a little unclear for this step.. Can someone provide some clarification?
9 answers
I got this error, and it was because I had skipped one step in my DB2 setup. Assuming you used the defaults for the DB2 setup, you just need to run the following commands in a normal terminal (as root):
This creates the directory for the
mkdir /jazzdw mkdir /jazzdw/tempspace32k chown -R db2inst1:db2iadm1 /jazzdw
This creates the directory for the
TEMPSPACE BUFFERPOOL. Just be sure to replace the username db2inst1 and group db2iadm1 with the correct ones you decided on from your DB2 setup. Once I did this, I was able to successfully create my tables during jts setup. Hopefully, if someone else comes across this, they may find it useful.
When installing 3.0 rc0 I tried to use DB2 9.7 as the database. I created the DBs for JTS, RM, CCM, QM and datawarehouse. I used the repotools for each of the respectively.
When going through the configuration and trying to set the DW database it warns me that the tables are not created and it will create them. Shortly after starting with that i get this:
An error occurred while creating data warehouse tables. Please try again.ID CRJAZ1745E
hide details
The database creation failed with an exception
com.ibm.team.repository.common.TeamRepositoryException: CREATE TEMPORARY TABLESPACE TEMPSPACE32K IN DATABASE PARTITION GROUP IBMTEMPGROUP PAGESIZE 32768 MANAGED BY SYSTEM USING ('/jazzdw/tempspace32k') BUFFERPOOL BPTEMP32K at com.ibm.team.datawarehouse.service.AbstractDataWarehouseVendor.executeSql(AbstractDataWarehouseVendor.java:124) at
Now the documentation is a little unclear for this step.. Can someone provide some clarification?
There should be an exception in the log file under the server folder. Can check that and post the exception stack along with the db error? It is possible it failed for a number of reasons, including not enough disk space for the size of the backing file for the tablespace or that the db user does not have enough authority on the db to create a tablespace or something else altogether.
Justin,
the db2admin user has grant all on the DW database in this case. I don't see how this could be a problem... When I have some free time i'll pull together another install and try it again, this time with more attention to the logs :) After running into trouble with this stuff I just did it with Derby...
the db2admin user has grant all on the DW database in this case. I don't see how this could be a problem... When I have some free time i'll pull together another install and try it again, this time with more attention to the logs :) After running into trouble with this stuff I just did it with Derby...
I ran into this when the "Database Table Space Folder" in the setup wizard was not pointing to an existing directory. I'm on a windows system and had left the default (/jazzdw) - when I tested the connection it created the bufferpools but failed on the table space create. If I tried to run again without cleaning up the bufferpools, it would fail trying to create the bufferpools. To cleanup, I had to stop the applications in WAS (ccm and jts in my case), delete the bufferpools in DB2, and restart the applications. Once I cleaned up, created an empty folder on the server (c:\jazzdw), and changed the setup to reference the new dir - it worked.
Hi All,
I am facing the same problem for SQL Server 2008. I am configuring the Data Warehouse and getting the exceptions. It says " specified database exists but there are no data warehouse tables present. Please click the "Create Tables" button below to create the required tables. Table creation may take a few minutes" but when i click on "Create Tables" it gives me the below exceptions. I have configured the teamserver.properties file and created the seperate database for JTS and for dataware house. i have followed the instructions from http://jazz.net/help-dev/rational-team-concert/index.jsp?topic=/com.ibm.jazz.install.doc/topics/c_post_install.html site. I am configuring it for JTS only at the moment. Can anyone help in resolving this problem?
Exception:
The database creation failed with an exception
com.ibm.team.repository.common.TeamRepositoryException: USE at com.ibm.team.datawarehouse.service.AbstractDataWarehouseVendor.executeSql(AbstractDataWarehouseVendor.java:124) at com.ibm.team.datawarehouse.service.sqlserver.internal.SqlServerDataWarehouseVendor.initializeDataWarehouse(SqlServerDataWarehouseVendor.java:24) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:618) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:370) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:356) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56) at $Proxy1374.initializeDataWarehouse(Unknown Source) at com.ibm.team.datawarehouse.service.internal.RemoteDatabaseService$1.run(RemoteDatabaseService.java:84) at com.ibm.team.datawarehouse.service.internal.RemoteDatabaseService$3.run(RemoteDatabaseService.java:127) at com.ibm.team.repository.service.internal.rdb.ConnectionPoolService.withCurrentConnection(ConnectionPoolService.java:332) at com.ibm.team.datawarehouse.service.internal.RemoteDatabaseService.write(RemoteDatabaseService.java:117) at com.ibm.team.datawarehouse.service.internal.RemoteDatabaseService.createRemoteSchemas(RemoteDatabaseService.java:76) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:618) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:370) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:356) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56) at $Proxy1350.createRemoteSchemas(Unknown Source) at com.ibm.team.datawarehouse.service.internal.InternalDataWarehouseService$7.run(InternalDataWarehouseService.java:1026) Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Database 'RIDW' does not exist. Make sure that the name is entered correctly. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(Unknown Source) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(Unknown Source) at com.ibm.team.repository.service.internal.db.jdbcwrappers.stat.StatementStatWrapper.execute(StatementStatWrapper.java:178) at com.ibm.team.repository.service.internal.db.jdbcwrappers.errlog.StatementErrLogWrapper.execute(StatementErrLogWrapper.java:169) at com.ibm.team.repository.service.internal.db.jdbcwrappers.leak.StatementLeakWrapper.execute(StatementLeakWrapper.java:70) at com.ibm.team.datawarehouse.service.AbstractDataWarehouseVendor.executeSql(AbstractDataWarehouseVendor.java:122) ... 23 more
Regards,
Darshan Patel
I am facing the same problem for SQL Server 2008. I am configuring the Data Warehouse and getting the exceptions. It says " specified database exists but there are no data warehouse tables present. Please click the "Create Tables" button below to create the required tables. Table creation may take a few minutes" but when i click on "Create Tables" it gives me the below exceptions. I have configured the teamserver.properties file and created the seperate database for JTS and for dataware house. i have followed the instructions from http://jazz.net/help-dev/rational-team-concert/index.jsp?topic=/com.ibm.jazz.install.doc/topics/c_post_install.html site. I am configuring it for JTS only at the moment. Can anyone help in resolving this problem?
Exception:
The database creation failed with an exception
com.ibm.team.repository.common.TeamRepositoryException: USE at com.ibm.team.datawarehouse.service.AbstractDataWarehouseVendor.executeSql(AbstractDataWarehouseVendor.java:124) at com.ibm.team.datawarehouse.service.sqlserver.internal.SqlServerDataWarehouseVendor.initializeDataWarehouse(SqlServerDataWarehouseVendor.java:24) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:618) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:370) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:356) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56) at $Proxy1374.initializeDataWarehouse(Unknown Source) at com.ibm.team.datawarehouse.service.internal.RemoteDatabaseService$1.run(RemoteDatabaseService.java:84) at com.ibm.team.datawarehouse.service.internal.RemoteDatabaseService$3.run(RemoteDatabaseService.java:127) at com.ibm.team.repository.service.internal.rdb.ConnectionPoolService.withCurrentConnection(ConnectionPoolService.java:332) at com.ibm.team.datawarehouse.service.internal.RemoteDatabaseService.write(RemoteDatabaseService.java:117) at com.ibm.team.datawarehouse.service.internal.RemoteDatabaseService.createRemoteSchemas(RemoteDatabaseService.java:76) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:618) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:370) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:356) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56) at $Proxy1350.createRemoteSchemas(Unknown Source) at com.ibm.team.datawarehouse.service.internal.InternalDataWarehouseService$7.run(InternalDataWarehouseService.java:1026) Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Database 'RIDW' does not exist. Make sure that the name is entered correctly. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(Unknown Source) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(Unknown Source) at com.ibm.team.repository.service.internal.db.jdbcwrappers.stat.StatementStatWrapper.execute(StatementStatWrapper.java:178) at com.ibm.team.repository.service.internal.db.jdbcwrappers.errlog.StatementErrLogWrapper.execute(StatementErrLogWrapper.java:169) at com.ibm.team.repository.service.internal.db.jdbcwrappers.leak.StatementLeakWrapper.execute(StatementLeakWrapper.java:70) at com.ibm.team.datawarehouse.service.AbstractDataWarehouseVendor.executeSql(AbstractDataWarehouseVendor.java:122) ... 23 more
Regards,
Darshan Patel
Hi Darshan,
Can you please open a bug report in Jazz Foundation, filed against
Reporting? We've successfully done this on SQL Server in the beta, so
I'd like to understand what is different about your setup.
Thanks,
james
CLM Reporting Team Lead
On 10/4/2010 10:23 AM, darshan wrote:
Can you please open a bug report in Jazz Foundation, filed against
Reporting? We've successfully done this on SQL Server in the beta, so
I'd like to understand what is different about your setup.
Thanks,
james
CLM Reporting Team Lead
On 10/4/2010 10:23 AM, darshan wrote:
Hi All,
I am facing the same problem for SQL Server 2008. I am configuring the
Data Warehouse and getting the exceptions. It says " specified
database exists but there are no data warehouse tables present.
Please click the "Create Tables" button below to create the
required tables. Table creation may take a few minutes" but when
i click on "Create Tables" it gives me the below
exceptions. I have configured the teamserver.properties file and
created the seperate database for JTS and for dataware house. i have
followed the instructions from
http://jazz.net/help-dev/rational-team-concert/index.jsp?topic=/com.ibm.jazz.install.doc/topics/c_post_install.html
site. I am configuring it for JTS only at the moment. Can anyone help
in resolving this problem?
Exception:
The database creation failed with an exception
com.ibm.team.repository.common.TeamRepositoryException: USE at
com.ibm.team.datawarehouse.service.AbstractDataWarehouseVendor.executeSql(AbstractDataWarehouseVendor.java:124)
at
com.ibm.team.datawarehouse.service.sqlserver.internal.SqlServerDataWarehouseVendor.initializeDataWarehouse(SqlServerDataWarehouseVendor.java:24)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618) at
org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:370)
at
org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:356)
at
org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at $Proxy1374.initializeDataWarehouse(Unknown Source) at
com.ibm.team.datawarehouse.service.internal.RemoteDatabaseService$1.run(RemoteDatabaseService.java:84)
at
com.ibm.team.datawarehouse.service.internal.RemoteDatabaseService$3.run(RemoteDatabaseService.java:127)
at
com.ibm.team.repository.service.internal.rdb.ConnectionPoolService.withCurrentConnection(ConnectionPoolService.java:332)
at
com.ibm.team.datawarehouse.service.internal.RemoteDatabaseService.write(RemoteDatabaseService.java:117)
at
com.ibm.team.datawarehouse.service.internal.RemoteDatabaseService.createRemoteSchemas(RemoteDatabaseService.java:76)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618) at
org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:370)
at
org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:356)
at
org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at $Proxy1350.createRemoteSchemas(Unknown Source) at
com.ibm.team.datawarehouse.service.internal.InternalDataWarehouseService$7.run(InternalDataWarehouseService.java:1026)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Database
'RIDW' does not exist. Make sure that the name is entered correctly.
at
com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown
Source) at
com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(Unknown
Source) at
com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(Unknown
Source) at
com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(Unknown
Source) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(Unknown
Source) at
com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(Unknown
Source) at
com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(Unknown
Source) at
com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(Unknown
Source) at
com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(Unknown
Source) at
com.ibm.team.repository.service.internal.db.jdbcwrappers.stat.StatementStatWrapper.execute(StatementStatWrapper.java:178)
at
com.ibm.team.repository.service.internal.db.jdbcwrappers.errlog.StatementErrLogWrapper.execute(StatementErrLogWrapper.java:169)
at
com.ibm.team.repository.service.internal.db.jdbcwrappers.leak.StatementLeakWrapper.execute(StatementLeakWrapper.java:70)
at
com.ibm.team.datawarehouse.service.AbstractDataWarehouseVendor.executeSql(AbstractDataWarehouseVendor.java:122)
.. 23 more
Regards,
Darshan Patel
I get an error setting up datawarehouse on Oracle using RTC 3.0.1 RC2.
I'm using the /jts/setp wizard.
The database creation failed with an exception
com.ibm.team.repository.common.TeamRepositoryException: CREATE TABLESPACE VNF_IDX LOGGING DATAFILE '/rtcdbqwlk1g/oracle/dbdata/app01/rtceq1/jazzdw/VNF_IDX_1.ora' SIZE 200M AUTOEXTEND ON NEXT 50M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO at com.ibm.team.datawarehouse.service.AbstractDataWarehouseDbProvider.internalExecuteSql(AbstractDataWarehouseDbProvider.java:229) at com.ibm.team.datawarehouse.service.AbstractDataWarehouseDbProvider.executeSql(AbstractDataWarehouseDbProvider.java:93) at com.ibm.team.datawarehouse.service.oracle.internal.OracleDataWarehouseDbProvider.setupDataWarehouse(OracleDataWarehouseDbProvider.java:25) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at
Are there any more details on what could cause this issue
regards
Mike Brosnan
I'm using the /jts/setp wizard.
The database creation failed with an exception
com.ibm.team.repository.common.TeamRepositoryException: CREATE TABLESPACE VNF_IDX LOGGING DATAFILE '/rtcdbqwlk1g/oracle/dbdata/app01/rtceq1/jazzdw/VNF_IDX_1.ora' SIZE 200M AUTOEXTEND ON NEXT 50M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO at com.ibm.team.datawarehouse.service.AbstractDataWarehouseDbProvider.internalExecuteSql(AbstractDataWarehouseDbProvider.java:229) at com.ibm.team.datawarehouse.service.AbstractDataWarehouseDbProvider.executeSql(AbstractDataWarehouseDbProvider.java:93) at com.ibm.team.datawarehouse.service.oracle.internal.OracleDataWarehouseDbProvider.setupDataWarehouse(OracleDataWarehouseDbProvider.java:25) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at
Are there any more details on what could cause this issue
regards
Mike Brosnan
Mike,
I got the same error and found a WI on the subject:
https://jazz.net/jazz/web/projects/Jazz%20Foundation#action=com.ibm.team.workitem.viewWorkItem&id=158448
Feel free to subscribe to it...
Regards
I got the same error and found a WI on the subject:
https://jazz.net/jazz/web/projects/Jazz%20Foundation#action=com.ibm.team.workitem.viewWorkItem&id=158448
Feel free to subscribe to it...
Regards
Hi,
i'm getting below error message while configuring RTC3.0.1 in windows 2008 server. The MSSQL 2008 has configured. Please help me
The database creation failed with an exception
com.ibm.team.repository.common.TeamRepositoryException: The database is not set to support case-sensitivity in string comparison operations at com.ibm.team.repository.service.db.provider.CaseSensitivityValidator.checkResultSetSize(CaseSensitivityValidator.java:210) at com.ibm.team.repository.service.db.provider.CaseSensitivityValidator.testCaseSensitivity(CaseSensitivityValidator.java:219) at com.ibm.team.repository.service.db.provider.AbstractDbProvider.assertCaseSensitivity(AbstractDbProvider.java:1167) at com.ibm.team.repository.service.db.provider.AbstractDbProvider.checkDatabaseConfiguration(AbstractDbProvider.java:1159) at com.ibm.team.repository.service.db.provider.AbstractDbProvider.prepareDbForInitialization(AbstractDbProvider.java:554) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:618) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:370) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:356) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56) at $Proxy56.prepareDbForInitialization(Unknown Source) at com.ibm.team.repository.service.internal.rdb.AbstractDatabaseService.internalCreateAllSchemas(AbstractDatabaseService.java:189) at com.ibm.team.repository.service.internal.rdb.DatabaseCreationService$1.run(DatabaseCreationService.java:48) at com.ibm.team.repository.service.internal.rdb.ConnectionRunnable.runWithResult(ConnectionRunnable.java:40) at com.ibm.team.repository.service.internal.rdb.ConnectionRunnable.run(ConnectionRunnable.java:34) at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase$Transaction.run(RepositoryDatabase.java:458) at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase$1.run(RepositoryDatabase.java:285) at com.ibm.team.repository.service.internal.rdb.ConnectionPoolService.withCurrentConnection(ConnectionPoolService.java:379) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:618) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:370) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:356) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56) at $Proxy58.withCurrentConnection(Unknown Source) at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runTransaction(RepositoryDatabase.java:281) at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runExclusive(RepositoryDatabase.java:259) at com.ibm.team.repository.service.internal.TransactionService.runExclusive(TransactionService.java:139) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:618) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:370) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:356) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56) at $Proxy92.runExclusive(Unknown Source) at com.ibm.team.repository.service.internal.rdb.DatabaseCreationService.createAllSchemas(DatabaseCreationService.java:43) at com.ibm.team.repository.service.internal.rdb.DatabaseCreationService.createAllSchemas(DatabaseCreationService.java:39) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:618) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:370) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:356) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56) at $Proxy114.createAllSchemas(Unknown Source) at com.ibm.team.repository.service.internal.DatabaseCreationRestService$1.run(DatabaseCreationRestService.java:50) at java.lang.Thread.run(Thread.java:811)
i'm getting below error message while configuring RTC3.0.1 in windows 2008 server. The MSSQL 2008 has configured. Please help me
The database creation failed with an exception
com.ibm.team.repository.common.TeamRepositoryException: The database is not set to support case-sensitivity in string comparison operations at com.ibm.team.repository.service.db.provider.CaseSensitivityValidator.checkResultSetSize(CaseSensitivityValidator.java:210) at com.ibm.team.repository.service.db.provider.CaseSensitivityValidator.testCaseSensitivity(CaseSensitivityValidator.java:219) at com.ibm.team.repository.service.db.provider.AbstractDbProvider.assertCaseSensitivity(AbstractDbProvider.java:1167) at com.ibm.team.repository.service.db.provider.AbstractDbProvider.checkDatabaseConfiguration(AbstractDbProvider.java:1159) at com.ibm.team.repository.service.db.provider.AbstractDbProvider.prepareDbForInitialization(AbstractDbProvider.java:554) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:618) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:370) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:356) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56) at $Proxy56.prepareDbForInitialization(Unknown Source) at com.ibm.team.repository.service.internal.rdb.AbstractDatabaseService.internalCreateAllSchemas(AbstractDatabaseService.java:189) at com.ibm.team.repository.service.internal.rdb.DatabaseCreationService$1.run(DatabaseCreationService.java:48) at com.ibm.team.repository.service.internal.rdb.ConnectionRunnable.runWithResult(ConnectionRunnable.java:40) at com.ibm.team.repository.service.internal.rdb.ConnectionRunnable.run(ConnectionRunnable.java:34) at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase$Transaction.run(RepositoryDatabase.java:458) at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase$1.run(RepositoryDatabase.java:285) at com.ibm.team.repository.service.internal.rdb.ConnectionPoolService.withCurrentConnection(ConnectionPoolService.java:379) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:618) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:370) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:356) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56) at $Proxy58.withCurrentConnection(Unknown Source) at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runTransaction(RepositoryDatabase.java:281) at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runExclusive(RepositoryDatabase.java:259) at com.ibm.team.repository.service.internal.TransactionService.runExclusive(TransactionService.java:139) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:618) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:370) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:356) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56) at $Proxy92.runExclusive(Unknown Source) at com.ibm.team.repository.service.internal.rdb.DatabaseCreationService.createAllSchemas(DatabaseCreationService.java:43) at com.ibm.team.repository.service.internal.rdb.DatabaseCreationService.createAllSchemas(DatabaseCreationService.java:39) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:618) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:370) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:356) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56) at $Proxy114.createAllSchemas(Unknown Source) at com.ibm.team.repository.service.internal.DatabaseCreationRestService$1.run(DatabaseCreationRestService.java:50) at java.lang.Thread.run(Thread.java:811)