Intermittent FDM/HFM connection issue
We installed Hyperion 11.1.2.1, on 2 64bit Windows 2008 R2 servers: one for all products except FDM, the second for FDM only. The FDM server has Excel 2010 and Oracle client 11.2.0.1, both 32bit, and HFM client 64bit (which Oracle support states that is fine).
On a regular basis, we receive issues with FDM not being able to query the HFM applications. This manifests itself when we do the mapping from the application, which gives the followiong error:
Adapter function [fConnect] failed
When I look at the log file, it states:
Error:
Code............13
Description.....Unable to cast COM object of type 'System.__ComObject' to interface type 'HSVSESSIONLib.HsvSession'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{5EF95A40-7C62-11D2-B436-006008B6FD2D}' failed due to the following error: A security package specific error occurred. (Exception from HRESULT: 0x80070721).
Procedure.......clsFMAdapter.fConnect
Component.......C:\oracle\Middleware\EPMSystem11R1\products\FinancialDataQuality\SharedComponents\AdapterComponents\fdmFM11xG5E\fdmFM11XG5E.dll
Version.........145
I have verified that the adapter is registered, and tried re-registering it. This if FDM 11.1.2.1, so the issue with registering with 64bit is resolved. I can connect to the HFM application using the HFM client on the FDM server. I see a process started on the HFM server. This typically occurs after a couple of loads from FDM to HFM.
The problem will eventually go away, after maybe a day, then remanifests itself.
Has anyone encountered this scenario?