Creation of datawarehouse for CLM 4.0.6 failing
Hi all,
I am trying to setup a CLM 4.0.6 with JTS, QM, RM and CCM modules in the same server. I created the BBDD (jts, dw,qm and ccm) in SQL Server 2012 (too in the same server that CLM). But the setup fails in the data warehouse creation.
Data:
Database Table Space Folder: D:\SQLSERVER2012\MSSQL11.MSSQLSERVER\MSSQL\tblspace
Custom Repot Database User: RPTUSER
Error message on the setup screen has following errors (abstract):
com.ibm.team.repository.common.TeamRepositoryException: ALTER DATABASE [dw] ADD FILE ( NAME = N'VNF_32K', FILENAME = N'D:\SQLSERVER2012\MSSQL11.MSSQLSERVER\MSSQL\tblspace\VNF_32K.ndf' , SIZE = 51200KB , FILEGROWTH = 51200KB ) TO FILEGROUP [VNF_32K] at com.ibm.team.datawarehouse.service.AbstractDataWarehouseDbProvider.internalExecuteSql(AbstractDataWarehouseDbProvider.java:366) at …
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: One or more files listed in the statement could not be found or could not be initialized. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216) at …
Data base user is owner to dw BBDD.
Someone has had a similar problem?
Thank in advance,
Kind regards,
Cristian.
One answer
If the folder is correct, look inside the folder if the VNF_32K.ndf was not already created during a previous execution.
If it is not empty, in order to run the jts/setup for the dw configuration again, you will need to delete the content created on this DW folder and also drop the database.
Check this article: https://jazz.net/wiki/bin/view/Main/MoreControlOverTheSQLServerDataWarehouseSetup
Comments
Donald Nong
Jul 16 '14, 11:41 p.m.Treat it as a pure SQL Server issue. Search "One or more files listed in the statement could not be found or could not be initialized". And this one may help.
http://www.sql-server-performance.com/2007/file-could-not-be-found-or-initialized/
Also, make sure that the user (OS, not DB) running the application server (Tomcat/WAS) has the permission to create file as described.