Cannot create/save engagement budgets (2014)
SYMPTOMS
Cannot save budget or create budgets for engagements.
ERROR/WARNING MESSAGES:
Could not find stored procedure "Changepoint_CPTEMPDB.guid.~BGT_SaveBudgetRevisionItems".
REASON
CPTempDB is out of sync with the Changepoint DB.
RESOLUTION
Run SQL Script SQL17CreateCPTempDB.csp against the Changepoint DB
or
If available, execute the stored procedure DBM_SetupCPTempDB, like:
exec dbo.DBM_SetupCPTempDB <CPTempDBName>, <PathToMDF>, <PathToLDF>, <Version>
exec dbo.DBM_SetupCPTemptDB 'Changepoint_CPTEMPDB', 'C:\SQLData\Default\cptempdb', 'C:\SQLData\Default\cptempdb', '17.02.067.000'