Tuesday, July 7, 2015

Hyperion FDMEE Data load failure Log analysis




Hyperion FDMEE Data load failure Log analysis



FDMEE different log file location and details


Audience : Hyperion Administrator / Hyperion Support / Development team.


1. Process Log

Whenever you trigger a load, FDMEE generates a process ID and log file in the FDMEE application folder under Outbox Folder.

Path : FDMEE Application Root Folder\Outbox\Logs  

You can find the process ID number from Data Management (FDMEE) console form workspace under process details menu.
Log file would be generated in the FDMEE Application Root Folder\Outbox\Logs  folder with target application name with process ID appended 


2.  ERPIntegrator0.log (FDMEE or ERPI log)
This is FDMEE application server log files. This would help you to find more detailed server errors 
\Oracle\Middleware\user_projects\domains\domain\servers\ErpIntergrator0\logs


3. ODI Agent Log

This is ODI agent log file. If ODI agent is not triggered / failed / timed out , please check this log.

\Oracle\Middleware/user_projects/domains/EPMSystem/servers/ErpIntegrator0/logs/oracledi




Manually Register HFM adapter  in  FDMEE 11.1.2.3.x


Steps:
Go to D:\Oracle\Middleware\user_projects\epmsystem1



Type the below Syntax

C:\windows\Microsoft.NET\Framework64\v4.0.30319\regsvcs.exe /tlb:”D:\Oracle\Middleware\user_projects\epmsystem1\FinancialDataQuality\erpiHFMAdapter.tlb” “D:\Oracle\Middleware\EPMSystem11R1\products\FinancialDataQuality\lib\Windows\erpiHFMAdapter.dll”