Sporadic "Access Denied" Messages for Reports with Hyperion Financial Management (HFM) Data Source

Sporadic "Access Denied" Messages for Reports with Hyperion Financial Management (HFM) Data Source
		Modified 29-APR-2010

---

Applies to:

Hyperion Reports - Version: 7.2.1.0.00 to 7.2.5.2.00 - Release: 7.2 to 7.2
Hyperion BI+ - Version: 9.0.1.0.00 to 11.1.2.0.00   [Release: 9.0 to 11.1]
Hyperion Financial Management - Version: 3.0.4.0.00 to 11.1.2.0.00   [Release: 3.0 to 11.1]
Information in this document applies to any platform.

Symptoms

Running reports with an HFM data source in Workspace, or opening them in Studio, you sporadically receive the error "access denied".  Other error messages you may receive are as follows:

"DCOM got error 'General access denied error'"
"Could not connect to the server" 
"Could not connect to any server in the specified cluster"

With repeated trials, the report will eventually open or run.

Cause

Microsoft changed  DCOM handling with Windows 2003 SP1 and SP2, and has discovered code issues with their RPC layer.  

You can find more information at http://support.microsoft.com.  You can search for "time bind" or "RPC".  

This behavior is a Microsoft code issue.

Solution

Make the following changes on all servers and workstations with the HFM ADM and HFM Client components, including HFM and Financial Reporting servers and workstations.

A. If the server is running on Windows 2003 SP1, apply SP2.

B. Make the following registry change on servers and workstations:

     1. Click Start > Run, type regedit, and click OK.

     2. Locate and then click the following registry subkey:  HKEY_LOCAL_MACHINE\SOFTWARE\Policies\Microsoft\Windows NT\Rpc
         If the Rpc key doesn't exist, create it by right-clicking on "Windows NT" and click New: Key.

     3. Right-click on "Rpc" and select New, and then click DWORD Value.

     4. Type Server2003NegotiateDisable as the name of the new DWORD Value.

     5. Right-click Server2003NegotiateDisable, and click Modify.

     6. In the Value Data box, type 1, and then click OK. 
         This setting disables the bind time negotiation and multiple transfer syntax negotiation.

    7. Quit the Registry Editor and re-boot the machine.

References

Hyperion Financial Management Readme