This content has been marked as final. Show 9 replies
That error means that you have not configured the adapter properly. Things to check:
1) You have imported and registered the adpater correctly
2) Machine profile is correctly referencing the FDM Server as source and the HFM server or cluster as target.
3) The account you are logging into FDM with has been given access to the HFM application if using unified security.
4) The HFM application name you have specified in the integration settings is correct
Thanks for the response.
I did all steps correctly as u mentioned.
I used FM11X-G6-A_1016 adapter to configure with FDM application.
please give me any suggestions.
Also make sure that the target HFM cluster/servers are registered in HFM Client on the FDM application server. After you have registered the HFM cluster/servers, verify that you can retrieve data in HFM Client from the target application and target HFM cluster and servers, particularly the target HFM cluster/server specified in the adapter's Machine Profile.
Edited by: Larry R on Jul 5, 2012 3:21 PM
There no longer exists an HFM Client "Cluster registration". They moved that functionality from the Windows Registry to the Shared Services Registry, but there is no actual method to "register" the cluster, the products are supposed to look at the HSS registry for that info, and I checked the HSS registry and it does have entries for the HFM Cluster but products like FDM an FR ARE NOT ABLE TO get that info and connect. I even used the single server name in the machine profile but the fConnect method fails. Anyone was able to connect the FDM HFM adapter to an HFM 18.104.22.168 app? or able to create an FR Data connection to an HFM 22.214.171.124 app?
Sounds like there were big changes with 126.96.36.199. If the instructions in the 188.8.131.52 EPM Install & Config Guide & the HFM Adapter ReadMe were followed, I would open an SR with Oracle. That may get you and answer faster and also give Oracle an opportunity to update the docs if something is missing.
have you enabled the UD3 and UD4 dimensions in the FM11x-G6-A adapter in the workbench? The adapter shipped without these two dimensions active in the adapter and the number of custom dims active in the adapter must match the number of custom dims in the HFM Application. IN 184.108.40.206 you can have more than 4 custom dims, so make sure they match.
Yes I agree with this post. we migrated 220.127.116.11 apps to 18.104.22.168 test servers. we had to activate the UD3 and UD4 and have been able to load data to HFM from FDM on 22.214.171.124. in case you try to use drill-back, we also had to make sure our FDM app was set to Unicode. we had to change that setting directly in the database in the tCtrlOption table in the Encoding row.
I am experiencing the same exact issues with FDM and FR connecting to the HFM cluster/server. If you could provide your method for connecting, I would greatly appreciate.
Thank tou for your replies.
Problem solved. We have to activate custom dimensions 3 and 4 then we will connect to HFM using FDM.