Failure to Create New FDM Application on 64-bit Windows
Posted by Priya Doyle on 04 February 2011 01:07 PM
|Failure to Create New FDM Application on 64-bit Windows [ID 1090074.1]|
| ||Modified 26-AUG-2010|| |
Applies to:Hyperion Financial Management - Version: 22.214.171.124.00 to 126.96.36.199.00 - Release: 11.1 to 11.1
Hyperion Financial Data Quality Management - Version: 188.8.131.52.00 to 184.108.40.206.00 [Release: 11.1 to 11.1]
Microsoft Windows (32-bit)
Microsoft Windows x64 (64-bit)
Tech environment :
- Oracle EPM System 220.127.116.11 on 64-bit Windows.
- HFM, FDM (FDM is running in 32-bit emulation mode)
- Oracle server 10g and Oracle client 10.2.0.4.0 - 64-bit Windows
- IIS is on 32 bit mode
SymptomsWhen creating a new application using FDM Workbench Win32 Client it gives
Error: "Error: Database user ID and password are required for login!"
CauseThis error is returned when the information provided on the database configuration page is not correct or has become invalid.
This error message can also be returned when the Oracle 32- bit Client is not installed on a 64- bit Windows machine.
When using the Oracle software on 64-bit Windows:
1. Install 32- bit Oracle Client on 64 - bit machine (steps are outlined in NOTE :795602.1).
2. Reconfigure using 32- bit Client and reboot the server.
Appropriate database providers include:
a. Oracle Provider for OLE DB installed on Workbench Win32 Client machine
b. Microsoft OLE DB Provider for SQL Server
These providers must exist on the users system in order for FDM to be able to connect to the database successfully via the Workbench Client.
On 64-bit Windows, the 32-bit and 64-bit Oracle Software gets installed separately and used separately. The 64-bit Oracle software will not recognize if the 32-bit Oracle software is installed. They operate separately when both are installed on 64-bit Windows platform.
ReferencesNOTE:781432.1 - Considerations Using The Oracle Client With Microsoft Products on 64 bit Operating System
NOTE:795602.1 - How To Install Both 32-bit and 64-bit ODP, OLEDB, And ODBC Oracle Software on 64-bit Windows