Skip to main content
Planview Customer Success Center

When editing a project budget, the following error is generated: The name of the database should be ChangepointT_CPTempDB and not Changepoint_CPTempDB (CP 2014)

Error/Warning messages:

  • The name of the database should be ChangepointT_CPTempDB and not Changepoint_CPTempDB
  • Cannot open database "Changepoint_CPTempDB" requested by the login.
  • The login failed.
  • The login failed for user 'CPSQLUser'.

Reason:

After restoring the CPTempDb using the SQL17CreateCPtempdb.csp file from the installation package as per the 2014 installation guide.

Then updating the table (ServerSettings.CPTempDB) value to reflect the correct database name, the cache and worker process caches were not restarted.

Changing the name in the database (ServerSettings.CPTempDB) does not force a cache renewal, since the user interface is not exposed to the change.


Resolution:

  1. Update the ServerSettings.CPTempDB with the correct CPTempt_DB name.
  2. Restart both the cache and worker process caches.
  3. Also, use the http://<localhost:80>/flushcache.aspx page to clear the CPTempDB region