FDM Adapter Error: Adapter function [fConnect] failed.

Well, this was a waste of an afternoon... First, the obvious thing to check is if the adapter connection parameters are correct. However, this KB shows that this error can be generated even if everything is seemingly correct. This fixed my issue in 11.1.2.2 connecting FDM to HFM.


11.1.2.2 FDM FM11x-G6-A Adapter Integration Error "Error: Adapter Function [fConnect] Failed." [ID 1452164.1]
  Modified 12-JUN-2012     Type PROBLEM     Status PUBLISHED
In this Document
Symptoms
Cause
Solution
Applies to:

Hyperion Financial Data Quality Management - Version 11.1.2.2.000 and later
Information in this document applies to any platform.
Symptoms

When attempting to integrate with HFM by browsing for a target value in the mapping table the process fails with error:

Error: Adapter function [fConnect] failed.
Issue Clarification

Cause


From version 11.1.2.2, FM now allows for mutiple Custom dimensions in the application metadata (previously this was set at 4). Currently the active HFM application has four custom dimensions, however in the HFM Adapter by default, only Custom 1 and Custom 2 are active in the adapter. In order to successfully integrate the number of custom dimensions in the HFM Adapter must match the number of custom dimensions in the HFM Application.

Solution

1) Login to the FDM application via the workbench client
2) Expand Target System Adapters > FM11x-G5-6 > Dimensions
3) Right-Click on UD3 and choose "Properties". Check the "Active" box and click OK
4) Right-Click on UD4 and choose "Properties". Check the "Active" box and click OK