IBM Support

Unable to import application - clustered server SQL environment

Technote (troubleshooting)


Problem(Abstract)

When attempting to import a deployment or create a new application in a new environment an error is received indicating only formatted files with a dependency defined in SQL can be used

Symptom

Error message:

Caused by: org.jawin.COMException: 80040e14: Unable to execute the statement. Cannot use file 'N:\database_file.mdf' for clustered server. Only formatted files on which the cluster resource of the server has a dependency can be used.
*Note: the N:\database_file.mdf is the customer's drive path and application .mdf file

Cause

SQL server drive dependency has not been configured or is incorrect

Resolving the problem

A SQL server drive dependency needs to configured, or the configuration needs to be reviewed and corrected.

The below Microsoft technote goes into details of setting up a dependency.
http://msdn.microsoft.com/en-us/library/ms177447.aspx


Document information

More support for: Cognos Planning
Contributor

Software version: 8.1, 8.3, 8.4, 8.4.1, 10.1, 10.1.1

Operating system(s): Windows

Reference #: 1641320

Modified date: 2013-06-19