I have experienced this in more than 3 environments at different clients. I
thought the first time it was just this server but repeatedly facing it made me
realize its something from the OS that is missing.
I noticed there was ATL100.DLL missing. Copied it
from the other servers as the Internet on client servers are generally blocked.
This DLL is basically for Visual C++ 2010 Redistributable x86. In case you
find it missing just install the Visual C++ and you are good to go.
In case, you do NOT have the Internet then go-ahead
and copy from the server that has it.
C:\Windows\System32\ATL100.dll and C:\Windows\Systemwow64\ATL100.dll
and redeploy FDMEE.
We got this error when one of the long running rules was timing out. I knew I could fix this in a jiffy since we faced this issue multiple times but to my surprise that was not the case. I logged into the environment and found that there was no Oracle HTTP Server (OHS) , client had used IIS as the Web Server. I had to read quite a few documents related to Weblogic and IIS.
Here is first a little from what I understood about the two,
Weblogic uses IIS plugin. This plugin allows requests to be proxied from IIS server to the Weblogic Server. The static pages of the Hyperion website are rendered by the IIS server and all the dynamic pages like the JSPs, HTTP Servlets are rendered by the Weblogic (hfm.war) .
The directory structure of the epm instance will have a folder
D:\Oracle\Middleware\user_projects\httpconfig\virtualdirectories
This contains folder for every location like Planning , HFM , Reporting etc.
Each folder contains a file
IISPROXY.INI.
Issue Screenshot
Cause:
Timeout is set too low for current task to complete.
Solution for IIS Web Server
1.Go to the location of iisproxy.ini and add these values to the file
HungServerRecoverSecs=1800
WLIOTimeoutSecs=1800
Do not miss the '=' sign.
HungServerRecoverSecs is replaced by WLIOTimeoutSecs and
Solution for OHS Web Server
1. Go to the mod_wl_ohs.conf file and add WLIOTimeoutSecs to the respective location where issue exists.
<LocationMatch ^/aif>
SetHandler weblogic-handler
WeblogicCluster SERVERNAME:6550
WLIOTimeoutSecs 1800
</LocationMatch> .
These settings can be done at the time of setting up the environment as a preventive measure. Saves a downtime and loads of frustrated users.
Issue:
FDMEE Data Rule does not show Completed status . The data rule hangs in the running state forever.
Checking the ODI operator or process details reveals that the rule was successfully completed.
Tried updating many tables in the Oracle DB: AIF_PROCESSES and AIF_PROCESS_DETAILS but this does not contain data for Data Rule Summary Page.
Finally found that AIF_BALANCE_RULES table impacts the Data Rule Summary page.
To fix this:
- Connect to the Database .
- Connect to the FDMEE Schema
- Update the particular field using below query
SELECT PROCESS_ID FROM AIF_BALANCE_RULES WHERE STATUS='RUNNING';
- Note the process_id and update the status
UPDATE "HYP_FDMEE"."AIF_BALANCE_RULES"
SET STATUS = 'SUCCESS' WHERE PROCESS_ID = '<PROCESS_ID>'
This provides alternative solutions to this issue.
Error:
ERROR [AIF] : The script has failed to execute:
INFO [AIF]: E:\oracle\middleware\EPMSystem11R1\produts\FinancialDataQuality\bin\HFM_VALIDATE.vbs(9,1) (null): Unspecifiec error
Description:
Data load does not happen due to this issue. During ETL , validation happens during Transformation as an atomic process. This validation was failing hence the whole data load process is marked as failed.
Solution:
Option 1:
1. Launch Configuration Utility
2. Go FDMEE Register Adapter
3. Restart FDMEE and validate
Option 2:
1. Stop FDMEE Services
2. Go to E:\oracle\middleware\EPMSystem11R1\produts\FinancialDataQuality\bin\Unregister.vbs
3. Then Register HFM adapter again by using below command
RegisterHFM.vbs "WINDOWS DOMAIN\DCOM USERNAME" "PASSWORD" %EPM_ORACLE_INSTANCE%
Ex:
RegisterHFM.vbs "tm\hyperion" "password" E:\oracle\middleware\user_projects\epmsystem1\bin
NOTE: Ensure Security Registration is SUCCESSFUL.
4. Start the FDMEE service and run the validation again.
