FDM: How To Register The Essbase Adapter and Troubleshoot Common Issues in 11.1.2.1

FDM: How To Register The Essbase Adapter and Troubleshoot Common Issues in 11.1.2.1 [ID 1345340.1]
Modified 03-NOV-2011 Type TROUBLESHOOTING Status PUBLISHED
In this Document
Purpose
Last Review Date
Instructions for the Reader
Troubleshooting Details
What are the prerequisites in Essbase?
How to register the Essbase Adapter
Troubleshooting
References

Applies to:

Hyperion FDM Essbase Adaptor - Version: 11.1.2.0.00 and later [Release: 11.1 and later ]
Information in this document applies to any platform.
Purpose

This will detail how to register the Essbase Adapter for FDM version 11.1.2.1 in 32bit and 64bit operating systems and how to troubleshoot common issues.
Last Review Date

August 10, 2011
Instructions for the Reader

A Troubleshooting Guide is provided to assist in debugging a specific issue. When possible, diagnostic tools are included in the document to assist in troubleshooting.
Troubleshooting Details

What are the prerequisites in Essbase?

-Ensure that the Essbase 32bit Runtime Client is installed on the FDM Application Server. FDM is a 32bit product and so the 32bit Runtime client is required even on a 64bit Operating System

-Check that the Essbase pathing variables are set up correctly. These are different for 32bit and 64bit machines. Both options are shown in the steps below.

1. From My Computer, right-click and select Properties. The System Properties dialog box is displayed.
2. Select the Advanced tab.
3. Click Environment Variables. The Environment Variables screen is displayed.

If this is a maintenance installation then there might still be User Variables called ESSBASEPATH and ARBORPATH- these can be deleted.

4. In the System Variables Portion of the window (bottom).
5. Select the variable name "ESSBASEPATH" and click Edit. If this variable doesn't exist then create it by selecting the New button.
6. In the Variable Value field enter the path \common\EssbaseRTC\11.1.2.0 and click OK e.g.
Oracle\Middleware\EPMSystem11R1\common\EssbaseRTC\11.1.2.0
7. Select the variable name 'Path' and click Edit
8. At the start of the path add the following value depending on the operating system
On 32bit systems
%ESSBASEPATH%\bin
On 64bit system
\bin-32;%ESSBASEPATH%\bin;\Products\Essbase\EssbaseClient-32\bin


How to register the Essbase Adapter

1) Copy the appropriate FDM Essbase adapter .exe file (e.g. ES11xG4H.exe) to the \common\EssbaseRTC\11.1.2.0\bin
2) Launch the FDM Workbench and log in
3) Choose File/Register Adapter and browse to the \common\EssbaseRTC\11.1.2.0\bin folder and select the es11xg4h.exe file and click "open" to register the adapter.

Troubleshooting

If any of the steps above have been missed, then there are various errors that can occur.

Error
When exporting from FDM to Essbase receiving the error
Error: Export failed.
Detail: File not found: esbapin.DLL
At Line: 128

Resolution
The esbapin.dll file is located in the \common\EssbaseRTC\11.1.2.0\bin folder. In order that FDM can locate this, the Essbase Adapter must be registered from this folder. Please see the section on how to register the adapter above.

Error
When browsing to the target system from mapping tables receiving the error
"Error: File not found ESBAPIN.DLL

Resolution
The 32bit client is not installed
To resolve this see KM Document 948857.1

Error
When browsing to the target receiving the error
"Procedure :[EsbInit] Threw Code : 1030803 AT Line 124."

Resolution
The pathing is not correct, see above or KM Document 1342362.1




References

NOTE:1342362.1 - Unable To Connect To Essbase From Fdm Version 11.1.2.1
NOTE:948857.1 - File Not Found Esbapin.dll When Attempting to Connect to Essbase From FDM

Related
Products
Middleware > Enterprise Performance Management > Financial Data Quality Management > Hyperion FDM Essbase Adaptor
Keywords
32BIT; 64BIT; ADAPTER; ESSBASE; FDM; FILE NOT FOUND ESBAPIN.DLL; INSTALL & CONFIGURE; RUNTIME

Back to top