Creation of datawarehouse for CLM 3.0.1 failing
Hi there,
I am trying to setup a CLM 3.0.1 with jts, qm, rm and ccm modules running in the same server. However the database itself is a Microsoft sql server. I have managed to create the swl tables for the jts part, however the setup fails in the datawarehouse creation.
What was tried was to generate the tables under the database jts and tablespace dw (as far as I have understood it). The error message on the setup screen has following errors:
1st error:
com.ibm.team.repository.common.TeamRepositoryException: ALTER DATABASE ADD FILE ( NAME = N'VNF_32K', FILENAME = N'dw\VNF_32K.ndf' , SIZE = 51200KB , FILEGROWTH = 51200KB ) TO FILEGROUP
2nd error (further down on the log):
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: A file activation error occurred. The physical file name 'dw\VNF_32K.ndf' may be incorrect. Diagnose and correct additional errors, and retry the operation.
The interpretation is that it is trying to create the file under the dw tablespace but is failing.
According to the setup instruction the repotools-jts -createTables and -createWarehouse should be run to create the needed structures. Still no success.
Has somebody found out a workaround or a solution to this problem?
With best regards
Erkki
I am trying to setup a CLM 3.0.1 with jts, qm, rm and ccm modules running in the same server. However the database itself is a Microsoft sql server. I have managed to create the swl tables for the jts part, however the setup fails in the datawarehouse creation.
What was tried was to generate the tables under the database jts and tablespace dw (as far as I have understood it). The error message on the setup screen has following errors:
1st error:
com.ibm.team.repository.common.TeamRepositoryException: ALTER DATABASE ADD FILE ( NAME = N'VNF_32K', FILENAME = N'dw\VNF_32K.ndf' , SIZE = 51200KB , FILEGROWTH = 51200KB ) TO FILEGROUP
2nd error (further down on the log):
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: A file activation error occurred. The physical file name 'dw\VNF_32K.ndf' may be incorrect. Diagnose and correct additional errors, and retry the operation.
The interpretation is that it is trying to create the file under the dw tablespace but is failing.
According to the setup instruction the repotools-jts -createTables and -createWarehouse should be run to create the needed structures. Still no success.
Has somebody found out a workaround or a solution to this problem?
With best regards
Erkki
One answer
On SQL Server the data warehouse should be a completely separate database. From what I recall all you need to do is create a new database (RIDW is the conventional name) along with a user that owner permission for that database.
When you run through the /jts/setup you should just need to specify the connection details for the RIDW database and you should be able to press the "create tables" button to have it create the database for you.
The documentation for SQL server has the exact commands you need to run to create and properly configure the datawarehouse.
When you run through the /jts/setup you should just need to specify the connection details for the RIDW database and you should be able to press the "create tables" button to have it create the database for you.
The documentation for SQL server has the exact commands you need to run to create and properly configure the datawarehouse.
Hi there,
I am trying to setup a CLM 3.0.1 with jts, qm, rm and ccm modules running in the same server. However the database itself is a Microsoft sql server. I have managed to create the swl tables for the jts part, however the setup fails in the datawarehouse creation.
What was tried was to generate the tables under the database jts and tablespace dw (as far as I have understood it). The error message on the setup screen has following errors:
1st error:
com.ibm.team.repository.common.TeamRepositoryException: ALTER DATABASE ADD FILE ( NAME = N'VNF_32K', FILENAME = N'dw\VNF_32K.ndf' , SIZE = 51200KB , FILEGROWTH = 51200KB ) TO FILEGROUP
2nd error (further down on the log):
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: A file activation error occurred. The physical file name 'dw\VNF_32K.ndf' may be incorrect. Diagnose and correct additional errors, and retry the operation.
The interpretation is that it is trying to create the file under the dw tablespace but is failing.
According to the setup instruction the repotools-jts -createTables and -createWarehouse should be run to create the needed structures. Still no success.
Has somebody found out a workaround or a solution to this problem?
With best regards
Erkki