HFM Error: “EPMHFM-65536 – An Unexpected Error has Occurred”


EPMHFM-65536” is a very generic error message and can be caused by a number of different factors; ranging from an improper install to application processes crashing.

Below are some of the more common causes and solutions of the error:

 

1) User is Unable to Open the Application after applying 11.1.2.4.100 patch:

If you recently applied 11.1.2.4.100, please review and confirm the following:

a) Ensure you followed all steps in HFM 11.1.2.4.100 Patch 20455650 : Patch Set Update: 11.1.2.4.100 for Oracle Hyperion Financial Management Readme and applied the appropriate SQL script to upgrade the schema to 11.1.2.4.100. This is specifically listed as Step # 5 in the Readme; listed below:

FROM THE README for Patch 20455650: Patch Set Update: 11.1.2.4.100 for Oracle Hyperion Financial Management:

Execute the following sql command to upgrade the schema against the Financial Management database. Use appropriate sql as per your database type.

<EPM_ORACLE_HOME>\products\FinancialManagement\Server\conf\<DB Type>_from_11.1.2.4.000_to_11.1.2.4.100_SchemaUpgrade.sql

If you are using SQL Server, ignore the following warning:

Warning! The maximum key length is 900 bytes. The index ‘PK_XFM_PARAMETERS_NEW’ has maximum length of 1500 bytes. For some combination of large values, the insert/update operation will fail.

 

b) Rollback the patch and see if you still receive the error.

 

2) User is unable to open the Application After Installing or Upgrading to 11.1.2.4:

The problem could be the load stop and the data audit sequence have not been updated with the upgrade.

To solve the problem, please execute the following steps with the assistance of your DBA:

Note: Please make sure you have a FULL Database/System backup before applying any changes:

  

1. Identify the last data audit ID by executing the below query

select max(lrownum) from <Application name>_DATA_AUDIT;

2. Drop the data audit sequence

DROP SEQUENCE <Application name>_DATA_AUDIT_SEQ;

3. Create the data audit sequence with the correct ID number.

CREATE SEQUENCE <Application name>_DATA_AUDIT_SEQ

MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1

START WITH <Identified ID from the Query 1> CACHE 20 NOORDER NOCYCLE ;

 

3) 11.1.2.4 Upgrade Completed and Applications are Successfully Registered; however; error message is received when user opens the application: EPMHFM-66054: The system was unable to find the Datasource process for application <APPNAME>

To resolve, please check the following with the assistance of your DBA:

1. Confirm that the tables below exist:

XFM_PARAMETERS,
XFM_PARAMETERS_DEFAULTS,
HSX_ADMIN_TASKS,
HSX_DSN_DETAILS

2. Make sure that HFMTNS alias entry is added in tnsnames.ora file in:

  • \Oracle\Middleware\user_projects\config\dbclient\ AND
  • All DB client locations (\app\Administrator\product\11.2.0\client_1\network\admin)
  • Example:

HFMTNS =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = HFMSERVER)(PORT = 1521))
)
(CONNECT_DATA =
(SID = HEBEPM)
(SERVER = DEDICATED)
)
)

How To Create An Attribute Dimension With a Hierarchy From Essbase Studio


How to Create Hierarchy for Attributes from Essbase Studio

The goal is to create a hierarchy for a particular Attribute dimension from Essbase Studio and link it with another dimension at the leaf node.  For example, to accomplish creating an attribute dimension named Population which has a hierarchy. Population should be an attribute for Level 0 (State) in the Market dimension as shown in the screen shot below:

POPULATION attribute dimension

The attribute columns need to be added as a second “chain” to the dimension hierarchy. Then in the Essbase Model properties, click on the attribute in the hierarchy and check the box ‘Essbase attribute for’.

The POPULATION table below is shown in the Essbase Studio mini schema. Note the join between MARKET and POPULATION.

POPULATION in minischema

Data from the POPULATION table:

POPULATION table

Data from the MARKET table showing the POPULATIONID for each STATE. The tables are joined through the POPULATIONID.

Market table with POPULATIONID

Create a hierarchy called Market, and add the base dimension hierarchy columns (REGION.REGION->MARKET.STATE), as well as the attribute hierarchy columns with the level 0 column from the MARKET table. (POPULATION.POPGROUP-> POPULATION.POPULATION->MARKET.STATE)

Market Hierarchy w POPULATION

After creating the cube schema and the Essbase model, open the Essbase Model Properties.  For the POPGROUP in the Market dimension, check the ‘Essbase attribute for ‘STATE’ ‘ box, and type in the name you want for the attribute dimension, in this case ‘Population’.

Model Properties for POPULATION attribute

Close the window and perform a cube deployment.  When you deploy this cube, you will end up with an attribute to the Market dimension called Population, which has two levels.

POPULATION attribute dimension

Thanks,

~KKT~

How to Force User Synchronizing Within a PBCS Application


Planning in PBCS does not have a utility to force the sync of users and groups within the application.

However, when you import Access Permissions, a security sync is performed in the background.

It is performed as follows in Standard Interface:

– Export Security from the application with LCM

1. Open Application Management

2. Navigate to  Applications\<application>\Security

3. Select Access Permissions

4. Select Export

5. Provide a name
eg. <SecurityExport>

– Import the exact same file back in with LCM

1. Open Application Management

2. Navigate to Artifact Snapshots\<SecurityExport>

3. Select the Planning application

4. Select Access Permissions

5. Select Import

– Refresh the application

1. Launch the application

2. Select Administration -> Application -> Refresh Database

3. Select Database

4. Select Refresh

It is performed as follows in Simplified Interface:

– Export Security from the application with LCM

1. Navigator -> Migration

2. Select Planning Category

3. Select Security (It selects Access Permissions underneath

4. Select Export and give it a name

5. Once completed, close the Migration Status Report

-Import the exact same file back with LCM

1. Select Snapshots

2. Click the gear icon next to the export from step 4 and select Import

3. Click OK to Proceed

4. Once completed, close the Migration Status Report

– Refresh  the application

1. Select the Overview Card

2. Actions -> Refresh Database

3. Run a pre-created refresh job or click Create to create a new refresh job and run it

Thanks,

~KKT~

How to execute EPM Automate and list of Exit Codes


Windows-

Before running the EPM Automate Utility, ensure that you can access Oracle Planning and Budgeting Cloud from the computer from which you are running the utility.

To run the EPM Automate Utility on a Windows client:

  1. Click Start, then All Programs, then EPM Automate, and then Launch EPM Automate. The Launch EPM Automate command prompt is displayed.
  2. Optional: Navigate to the directory from which you want to perform operations using the EPM Automate Utility.
  3. Optional: Generate a password encryption file. You use the password encryption file to pass encrypted password to initiate a session.
    epmautomate encrypt P@ssword1 myKey C:/mySecuredir/password.epw
    
  4. Start a session as a Service Administrator. Use a command such as the following:
    • Using an unencrypted password:
      epmautomate login serviceAdmin P@ssword1 
      https://test-cloudpln.pbcs_us1.oraclecloud.com myIdentityDomain
      
    • Using an encrypted password:
      epmautomate login serviceAdmin C:\mySecuredir\password.epw 
      https://test-cloudpln.pbcs_us1.oraclecloud.com myIdentityDomain
      
  5. Enter commands to execute the tasks you want to complete.

    See Exit Codes below.

  6. Sign out of the service instance. Use the following command:
    epmautomate logout
    
    

Linux-

To run the EPM Automate Utility on a Linux client:

  1. Open a terminal window and navigate to the directory where you installed the EPM Automate Utility.
  2. Optional: Generate a password encryption file. You use the password encryption file to pass an encrypted password instead of an unencrypted password to initiate a session.
    epmautomate encrypt P@ssword1 myKey ../misc/encrypt/password.epw
    
  3. Start a session as a Service Administrator. Use a command such as the following:
    • Using an unencrypted password:
      ./bin/epmautomate.sh login serviceAdmin P@ssword1 
      https://test-cloudpln.pbcs_us1.oraclecloud.com myIdentityDomain
      
    • Using an encrypted password:
      ./bin/epmautomate.sh login serviceAdmin ../misc/encrypt/password.epw 
      https://test-cloudpln.pbcs_us1.oraclecloud.com myIdentityDomain
      
  4. Enter commands to execute the tasks you want to complete.

    See Exit Codes below.

  5. Sign out of the service instance. Use the following command:
    ./bin/epmautomate.sh logout

 

Exit Codes –

The EPM Automate Utility returns an exit code to indicate the status of the operation. Additionally, the utility creates a log file (COMMANDNAME_TIMESTAMP.log, for example,uploadfile_16_08_2016_11_27_10.log) for each failed command execution.

Table 2-1 EPM Automate Utility Exit Codes

Status Code Description
0 Operation completed without errors.
1 Command failed to execute because of a functional error.A message, which identifies the functional error that caused command execution failure, is displayed.
6 Service is not available.Similar to HTTP Error 404, this code indicates that the server could not find what was requested by the utility. This is not a functional error.
7 Invalid command.The command you attempted to execute is not supported by the utility or the command usage is incorrect. All client-side processing issues are reported using this code.
9 Invalid credentials or the credentials you used do not have sufficient privileges to complete the current operation.Similar to HTTP Error 401. Verify that the user name, password, and identity domain that you specified are valid.
11 Internal server error. This code indicates all internal errors excluding those that are not handled by other exit codes.Similar to HTTP Error 500. If the problem persists, contact Oracle.

How to know users who log-in to Oracle Planning and Budgeting Cloud Service currently?


You can see user audit report that contains who logs in PBCS by using EPM Automate.
EPM Automate generates a user audit report (.CSV file) and stores it in the inbox/outbox. This report contains information on the users who signed into a service instance over a specified period of time. It shows the IP address of the computer from which the user logged in and the date and time at which the user accessed the service instance.

[Sample: User Audit Report]

Type Of Report User Audit Report
Report Generated Date 06/08/2016

User Name IP Address Access Date and Time

prod_admin xxx.xxx.xxx.xxx June 8, 2016 04:49:10 UTC
prod_admin xxx.xxx.xxx.xxx June 7, 2016 08:34:57 UTC
test_admin xxx.xxx.xxx.xxx June 3, 2016 07:31:56 UTC

 

Steps to refer user audit report

1. If you didn’t install EPM Automate, download latest version from PBCS
1.1 login to the service via a browser with the account
1.2 Tools -> Install -> EPM Automate

2. Login to PBCS via EPM Automate

epmautomate login <USERNAME> <PASSWORD> <URL> <IDENTITYDOMAIN>

Example:
epmautomate login admin@oracle.com Pa$$w0rd https://planning-test-a123456.pbcs.us2.oraclecloud.com a123456

3. Generate a user audit report(.CSV file) and stores it in the inbox/outbox

epmautomate userauditreport <FROM_DATE> <TO_DATE> <REPORT_NAME>

Example:
epmautomate userauditreport 2016-06-03 2016-06-08 myAuditReport.CSV

4. Download the report

epmautomate downloadfile <REPORT_NAME>

If you cannot download the report, make sure the report is generated via following command;
epmautomate listfiles

5. Logout from PBCS

epmautomate logout

6. Refer the report

The report is downloaded in the directory which you run EPM Automate.

Thanks,

~KKT~