Skip to main content
Planview Customer Success Center

CPTEMPDB error during patch installation

Symptoms
Every time we install a patch manually it drops the CPTEMPDB and gives this error:

Error/Warning Messages
Directory lookup for the file "E:\XXXXXX\CPTEMPDB.mdf" failed with the operating system error 2(The system cannot find the file specified.).
CREATE DATABASE failed. Some file names listed could not be created.
Check related errors.

User does not have permission to alter database 'CPTEMPDB', the database does not exists, or the database is not in a state that allows access checks.
ALTER DATABASE statement failed.

Reason
The Database server, server properties>>Database settings was set to E:\
After running the CPTempdb_InstallParameter.sql, the location parameters were not updated


Resolution
Ran the CPTempdb_InstallParameter.sql and updated the CPTEMPDB_MDF_FILE_PATH and CPTEMPDB_LDF_FILE_PATH with the correct location information (F:\)

Optionally change the CPTEMPDB path on the Database Server as follows:
1. Launch SQL Server Management
2. Right click on the Server, click Properties
3. In the Server Properties page, click Database settings
4. Under the Database default locations, change the data path
5. Click Ok