Skip to main content
Planview Customer Success Center

"MODIFY FILE failed." error when creating a CPtempDB

Symptoms

When creating a Changepoint CPTempDB, e.g. during an upgrade, an error is generated:

   2020-10-05 09:01:43     !!! MODIFY FILE failed. Specified size is less than or equal to current size.
   The file name 'CPTempDB' has been set.
   The file name 'CPTempDB_Log' has been set.

   2020-10-05 09:02:03     Importing Changepoint SQL code failed.


Reason

By default, Changepoint sets the data file size of the CPTempDB to 512 MB and the log file size to 128 MB to prevent multiple small increases and fragmentation during operations.

The error occurs when the 512 MB/128 MB file sizes are less than the current file sizes. 

Resolution

Because a new CPTempDB is copied from the model database, please ensure that the model database file size is set to less than 512 MB for the data file and less than 128 MB for the log file.