"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.