It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Follow this question
Question details

×5,978
×4,197
×94
×1

question asked: Sep 22 '15, 8:16 p.m.
question was seen: 2,188 times
last updated: Sep 24 '15, 3:16 a.m.

Related questions

FAQ - How this Forum works

creating datawarehouse with sql server 2012 error ID CRJAZ1745E CRRTC8030E

0
Daniel Torres (7●4●9) | asked Sep 22 '15, 8:16 p.m.

Hi, i got this issue when trying to create the datawarehouse. I already did it installing JTS and DB on the same server without getting this error, but now i get 1 application server and 1 database server. After setting up the jazz configuration steps, I'm stuck on the datawarehouse setup step to set the table space path.

I created this folder on the database server D:\SQL_Data_App so I put it on the datawarehouse setup, but I got this error:

com.ibm.team.repository.common.TeamRepositoryException: ALTER DATABASE [BN_DW] ADD FILE ( NAME = N'VNF_32K', FILENAME = N'D:\SQL_Data_App\VNF_32K.ndf' , SIZE = 51200KB , FILEGROWTH = 51200KB ) TO FILEGROUP [VNF_32K] at com.ibm.team.datawarehouse.service.AbstractDataWarehouseDbProvider.internalExecuteSql(AbstractDataWarehouseDbProvider.java:409) at com.ibm.team.datawarehouse.service.AbstractDataWarehouseDbProvider.executeSql(AbstractDataWarehouseDbProvider.java:232) at com.ibm.team.datawarehouse.service.sqlserver.internal.SqlServerDataWarehouseDbProvider.setupDataWarehouseCoreSpace(SqlServerDataWarehouseDbProvider.java:33) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37) at java.lang.reflect.Method.invoke(Method.java:611) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:361) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:347) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56) at com.sun.proxy.$Proxy10995.setupDataWarehouseCoreSpace(Unknown Source) at com.ibm.team.datawarehouse.service.internal.RemoteDatabaseService$1.run(RemoteDatabaseService.java:237) at com.ibm.team.datawarehouse.service.internal.RemoteDatabaseService$6.run(RemoteDatabaseService.java:548) at com.ibm.team.repository.service.internal.rdb.ConnectionPoolService.withCurrentConnection(ConnectionPoolService.java:470) at com.ibm.team.datawarehouse.service.internal.RemoteDatabaseService.write(RemoteDatabaseService.java:510) at com.ibm.team.datawarehouse.service.internal.RemoteDatabaseService.createRemoteSchemas(RemoteDatabaseService.java:225) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37) at java.lang.reflect.Method.invoke(Method.java:611) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:361) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:347) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56) at com.sun.proxy.$Proxy10962.createRemoteSchemas(Unknown Source) at com.ibm.team.datawarehouse.service.internal.InternalDataWarehouseService$11.run(InternalDataWarehouseService.java:1306) 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 com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515) at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:792) at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:689) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155) at com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:662) at com.ibm.team.repository.service.internal.db.jdbcwrappers.stat.StatementStatWrapper.execute(StatementStatWrapper.java:233) at com.ibm.team.repository.service.internal.db.jdbcwrappers.errlog.StatementErrLogWrapper.execute(StatementErrLogWrapper.java:173) at com.ibm.team.repository.service.internal.db.jdbcwrappers.leak.StatementLeakWrapper.execute(StatementLeakWrapper.java:71) at com.ibm.team.datawarehouse.service.AbstractDataWarehouseDbProvider.executeStatement(AbstractDataWarehouseDbProvider.java:262) at com.ibm.team.datawarehouse.service.AbstractDataWarehouseDbProvider.internalExecuteSql(AbstractDataWarehouseDbProvider.java:384) ... 24 more
Comments
Lily Wang commented Sep 23 '15, 12:51 a.m.

 What's the full java stack of the error? Could you see anything in the stack like "Caused by ..." which may give you the detail reason of the error.


In addition, please refer https://jazz.net/forum/questions/158429/creation-of-datawarehouse-for-clm-406-failing to check the folder/file permission.

3 answers

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Francesco Chiossi (5.7k●1●8●19) | answered Sep 23 '15, 3:51 a.m.
Hello Daniel,

you might also try to run the alter statement in the error directly on SQL Server and see what error you get.

Best Regards
Francesco Chiossi
Comments
Daniel Torres commented Sep 23 '15, 9:06 p.m.

Hi Francesco,

The Filegroups were created, so I just execute the sentence to add the file:

ALTER DATABASE [BN_DW] ADD FILE ( NAME = N'VNF_32K', FILENAME = N'D:\SQL_Data_App\VNF_32K.ndf' , SIZE = 51200KB , FILEGROWTH = 51200KB ) TO FILEGROUP [VNF_32K]

But got the same error message "One or more files listed in the statement could not be found or could not be initialized".

Francesco Chiossi commented Sep 24 '15, 3:16 a.m.

Hello Daniel,

since you get the same error also running the command directly, this seems to be a problem with your database server.
You might want to consider contacting Microsoft support, if you have access to them.

Best Regards,

Francesco Chiossi

0
permanent link
Daniel Torres (7●4●9) | answered Sep 23 '15, 5:16 p.m.

The message error is "Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: One or more files listed in the statement could not be found or could not be initialized".

Any idea why I'm getting this error?

Comments
Lily Wang commented Sep 23 '15, 8:22 p.m.

For this error, please check:

- The user has administrative access on the database server.
- There's enough space on "D:" drive.
- The file "D:\SQL_Data_App\VNF_32K.ndf" doesn't exist and not used by other database.

0
permanent link
Daniel Torres (7●4●9) | answered Sep 23 '15, 8:53 p.m.
Hi Lily,
About your questions:
- The user has administrative access on the database server.  (yes, I'm using an admin account)
- There's enough space on "D:" drive.  (yes, more than 100GB)
- The file "D:\SQL_Data_App\VNF_32K.ndf" doesn't exist and not used by other database. (yes, it doesn't exist, just the folder D:\SQL_Data_App)

Your answer

Register or to post your answer.