User unable to Log into FDM but can Log into HFM
> OK Oracle have provided me with the following solution:
>
> 1)Make sure the user experiencing this issue is not logged on HFM
> 2)Connect to the HFM database using Query Analyzer or equivalent SQL client
> 3)Run the following query:
>
> DELETE FROM appname_USERPARAMS WHERE Username LIKE '%youruser%'
>
> replacing "appname" with the application name and "youruser" with the username of the affected user. IMPORTANT: The USERPARAMS table stores user-based nformation such as HFM Cluster settings, Extended Analytics settings, Web Data Entry Form settings, Web Based Report Files. Executing the above SQL query will reset all these settings for the selected user.Log on with the user again and test.
>
> As we have tried a number of other scenarios now I believe the solution here will simply wipe the user logging information clean. The query will not effect any Hyperion setup.
>
> Therefore when the user logs in next it will be as if the user is logging in for the first time.
>
GKontos
Comments