creating datawarehouse with sql server 2012 error ID CRJAZ1745E CRRTC8030E
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: |
3 answers
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)
|
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.
|
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,
|
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.
Comments
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.