Not able to complete QC 12.6 installation getting java.sql.SQLException

  • Questions
  • Not able to complete QC 12.6 installation getting java.sql.SQLException
Question ID: 108744
0
0

We are getting this error when trying to install QC 12.60:

java.sql.SQLException: [Mercury][SQLServer JDBC Driver][SQLServer]Directory lookup for the file "E:\\Data\\qcsiteadm1260_db.mdf" failed with the operating system error 2(The system cannot find the file specified.).
at com.mercury.jdbc.sqlserverbase.ddcw.b(Unknown Source)
at com.mercury.jdbc.sqlserverbase.ddcw.a(Unknown Source)
at com.mercury.jdbc.sqlserverbase.ddcv.b(Unknown Source)
at com.mercury.jdbc.sqlserverbase.ddcv.a(Unknown Source)
at com.mercury.jdbc.sqlserver.tds.ddr.v(Unknown Source)
at com.mercury.jdbc.sqlserver.tds.ddr.a(Unknown Source)
at com.mercury.jdbc.sqlserver.tds.ddr.a(Unknown Source)
at com.mercury.jdbc.sqlserver.dda3.m(Unknown Source)
at com.mercury.jdbc.sqlserverbase.dde7.e(Unknown Source)
at com.mercury.jdbc.sqlserverbase.dde7.a(Unknown Source)
at com.mercury.jdbc.sqlserverbase.dde7.w(Unknown Source)
at com.mercury.jdbc.sqlserverbase.dde7.s(Unknown Source)
at com.mercury.jdbc.sqlserverbase.dde7.execute(Unknown Source)
at com.hp.alm.platform.db.convertor.CMSSQLDBCreator$1.execute(CMSSQLDBCreator.java:243)
wrapped in com.hp.alm.platform.db.CTdDbException:
at com.hp.alm.platform.db.convertor.CMSSQLDBCreator$1.execute(CMSSQLDBCreator.java:245)
at com.mercury.optane.core.RetriableOperationExecutor.execute(RetriableOperationExecutor.java:47)
wrapped in com.hp.alm.platform.exception.CTdException:
at com.mercury.optane.core.RetriableOperationExecutor.execute(RetriableOperationExecutor.java:63)
at com.mercury.optane.core.DbRetriableOperationExecutor.execute(DbRetriableOperationExecutor.java:21)
wrapped in com.hp.alm.platform.db.CTdDbException:
at com.mercury.optane.core.DbRetriableOperationExecutor.execute(DbRetriableOperationExecutor.java:23)
at com.hp.alm.platform.db.convertor.CMSSQLDBCreator.createDB(CMSSQLDBCreator.java:231)
wrapped in com.hp.alm.platform.exception.CTdException: CMSSQLCreator : Unable to create database qcsitead

Marked as spam
Posted by (Questions: 74, Answers: 4)
Asked on November 5, 2018 4:20 pm
6 views
Answers (1)
0
Private answer

This file:
E:Dataqcsiteadm1260_db.mdf

Is related to SQL-Server and should be on the SQL-Server file-store (where SQL-Server stores the files for each of it's databases).
Talk to the DBA about the underlying LDF and MDF files that relate to the SQL-Server database ''qcsiteadm1260_db'' -- if it has already been created, OR look into how it (SQL-server) wants to create them.

They may have been moved, the disk is out of room or blocked by some security or something.
This issue is ALL related to SQL-Server not being able to access or create the database due to not getting to the underlying files.

Marked as spam
Posted by (Questions: 3, Answers: 466)
Answered on November 5, 2018 4:24 pm