My Oracle Support Banner

Moving From Primary Servers to Disaster Recovery Servers - Error: EPMHFM-66054: The system was unable to find the Datasource process for application error (Doc ID 2923664.1)

Last updated on FEBRUARY 03, 2023

Applies to:

Hyperion Financial Management - Version 11.2.10.0.000 and later
Information in this document applies to any platform.

Symptoms

 Users can log in to Workspace and also navigate to Consolidation Administration but cannot open HFM application. HFM throws error EPMHFM-66054: The system was unable to find the Data source process for application error. 

The issue only happens when DR Testing was initiated and it only impacted HFM EPM applications, other EPM applications open fine example : Planning / Essbase.

Changes

 For Disaster Recovery testing,  few steps like below were performed

1) Servers are copied in real time to DR using a VMWare tool, in this case VM's will have same hostname in primary and DR and different IP's.

2) Database is copied to the DR. 

3) And also, after moving the below files were updated with Database information , Note: During installation and configuration Oracle database string was used so that it connects to both primary and DR databases.

 Files updated after moving to DR Servers:

D:\Oracle\Middleware\user_projects\domains\EPMSystem\config\fmwconfig

jps-config.xml

jps-config-jse.xml 

D:\Oracle\Middleware\user_projects\domains\EPMSystem\config\jdbc

LocalSvcTblDataSource-jdbc.xml

opss-audit-jdbc.xml

opss-auditview-jdbc.xml

opss-datasource-jdbc.xml

WLSSchemaDataSource-jdbc.xml

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.