| Failure to Create New FDM Application on 64-bit Windows [ID 1090074.1] | |||||
|
|
|||||
| Modified 26-AUG-2010 | |||||
Applies to:
Hyperion Financial Management - Version: 11.1.1.3.00 to 11.1.1.3.00 - Release: 11.1 to 11.1Hyperion Financial Data Quality Management - Version: 11.1.1.3.00 to 11.1.1.3.00 [Release: 11.1 to 11.1]
Microsoft Windows (32-bit)
Microsoft Windows x64 (64-bit)
Tech environment :
- Oracle EPM System 11.1.1.3 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
Symptoms
When creating a new application using FDM Workbench Win32 Client it givesError: "Error: Database user ID and password are required for login!"
Cause
This 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.
Solution
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.
References
NOTE:781432.1 - Considerations Using The Oracle Client With Microsoft Products on 64 bit Operating SystemNOTE:795602.1 - How To Install Both 32-bit and 64-bit ODP, OLEDB, And ODBC Oracle Software on 64-bit Windows
GKontos
Comments