Skip to main content
Language Selector

  1. Other Languages

    (machine translation)

Planview Customer Success Center

Pending Resource Changes don't clear

  1. Last updated
  2. Save as PDF

SYMPTOMS
There are several hundreds of resources having pending resource changes that won't clear out. The CPEffective job shows executed successfully.
 
We need a solution to clear out the pending resources changes. Can we change the 'updated' field of dbo.workgrouphistorymember from false to true to fix the issue? What's the impact of doing that?

REASON
The CPEffectiveDates job didn't actually execute by starting it in SQL. First, the database connection setting needed to be encrypted through login settings

RESOLUTION
• Go to Login Settings: C:\Program Files\Common Files\Compuware\Changepoint\LoginSettings on the IIS server and copy it.

• Go to the SQL Server and paste the Login Settings anywhere

• Execute Login Settings and select Windows Services from the first drop down menu

• Browse for CPEffectiveDates

• Encrypt the database log in settings and save

• Restart the CPEffectiveDates job