APPLIES TO:
Hyperion Financial Management - Version 11.2.0.0.000 and later
Information in this document applies to any platform.
SYMPTOMS
11.1.2.4
Users getting ADF-FACES popup error after upgrade and attempting to open one of the Journals Modules:
ADF_FACES-60097:For more information, please see the server's error log for an entry beginning with:ADF_FACES-60096:Server Exception during PPR, #7
11.2
Users see pop-up error after upgrade and attempting to open one of the Journals Modules:
Review the HFM Web tier logs for the following entry:
- oracle-epm-fm.log - located in \Oracle\Middleware\user_projects\domains\EPMSystem\servers\HFMWeb0\logs\hfm\
oracle.epm.fm.common.exception.HFMException: EPMHFM-65886: An error occurred updating template columns.
CHANGES
Upgrade to HFM 11.1.2.4 or HFM 11.2 from older release
CAUSE
Issue with application upgrade utility not updating User specific settings for Template Filters.
SOLUTION
Workaround:
Ensure you have full database backup before proceeding.
- All users must be logged out of the HFM application. Application does not need to be shutdown.
- DBA needs to execute run the following query against appropriate database/schema:
delete from <appname>_USERPARAMS where ParameterKey = 'TemplatesQueryDef';
(Replace <appname> with affected HFM application)
- Retest
**Note that this will delete only user saved Template Filters but does not delete Templates. TemplatesQueryDef parameter is set from the following actions:
1. Journals Templates UI in workspace-> Save Filter
2. Smartview -> Save Template Filter
GKontos
Comments