POV Corruption - USERPARAMS table

POV Corruption in HFM

Symptoms

User gets errors when connecting to SmartView or opening HFM application in workspace. Other users are able to connect without issues.

Cause

POV corruption for the user in question

Solution

Log into the Database server. Open the SQL Server Management Studio. Find the HFM database and open a new query window.

Take a backup of the <app_name>_USERPARAMS table by running the below command:

SELECT * FROM <app_name>_USERPARAMS WHERE Username like '@%'

Run the below command to clear the Member Selection for the user in question only. Do not delete all.

DELETE FROM <app_name>_USERPARAMS WHERE Username like '@%'

Example

begin tran
delete from HFMAPP_USERPARAMS
           where USERNAME like 'USERNAME@%' and PARAMETERKEY ='UserMbrSel'
commit