Receive Error: "Unable to cast COM object of type 'System.__ComObject' to interface type 'HSVMETADATALib.HsvMetadata'" when Integrating with HFM and FDM Installed in a 64bit OS

Receive Error: "Unable to cast COM object of type 'System.__ComObject' to interface type 'HSVMETADATALib.HsvMetadata'" when Integrating with HFM and FDM Installed in a 64bit OS
		Modified 26-MAY-2010

---

Applies to:

Hyperion Financial Data Quality Management - Version: 11.1.1.3.00<max_ver> and later   [Release: 11.1 and later ]
Information in this document applies to any platform.

Symptoms

Unable to integrate with HFM with the following error at line 393

Cause

When the Workbench is being used to register an adapter on a 64bit OS the "Register Adapter" as outlined in the Configuration Documentation has a problem distinguishing between 32bit and 64bit Operating Systems.

Solution

1. Launch DCOM (dcomcnfg)
2. Expand Component Services
3. Expand Computers
4. Expand My Computer
5. Expand COM+ Applications
6. Delete the Application called 'fdmFM11xG5C'
7. Launch a command prompt window
8. Navigate to the Microsoft.Net64 FrameWork (generally C:\Windows\Microsoft.Net\Framework64\v2.0.50727)
9. Find the following file in Windows Explorer:  fdmAdapterCOMadmin.
10. Enter the following command into the command prompt window but do not hit enter:
    
    RegASM /codebase

11. Drag and Drop the file "fdmAdapterCOMadmin.dll" onto the command window (Windows Explorer will automatically paste in the path to the file
12. Hit Enter to execute the command
13. Enter the following command into the command prompt window but do not hit enter:

    RegSVCS 

14. Drag and drop the file "fdmFM11xG5C.dll" onto the command window (Windows Explorer will automatically paste in the path to the file
15. Press Enter
16. Go back into the Workbench Win32
17. Expand the Target System Adapters
18. Right Click the HFM Adapter and choose "Configure"
19. Enter the COM+ Service Account Information