It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Follow this question
Question details

×6,076
×4,288

question asked: Jul 16 '14, 8:37 a.m.
question was seen: 3,344 times
last updated: Aug 01 '14, 7:59 a.m.

Related questions

FAQ - How this Forum works

Creation of datawarehouse for CLM 4.0.6 failing

0
Cristian Zárate (18●5●8) | asked Jul 16 '14, 8:37 a.m.

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.

Comments
Donald Nong commented 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.

One answer

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Isabel Murakami (381●1●6●15) | answered Aug 01 '14, 7:59 a.m.
Check if the DB folder path is correct and if it has write permission.
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


Your answer

Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.