Financial Management Audit Data Export Utility or Error Log Viewer Fail to Connect to Repository Database Using Encrypted UDL File

(Doc ID 1384404.1)

Last updated on AUGUST 08, 2016

Applies to:

Hyperion Financial Management - Version: 11.1.2.1.000 and later   [Release: 11.1 and later ]
Information in this document applies to any platform.

Symptoms

Financial Management (HFM) Audit Data Export Utility (HFMAuditExtractUtility.exe) and Log Viewer (HFMErrorLogViewer.exe) fail to connect to HFM repository database if encrypted UDL file is used. When unencrypted UDL file is used, both utilities connect successfully.

32-bit systems
 
Audit Data Export Utility fails to connect using encrypted UDL file with the following error message:

Failed to connect to the database!
Failed to return a list of applications using database provided
SQL:
Error: Unknown (-2147217843)


Invalid UDL file. The database connect file is either invalid or points to a database that contains no HFM applications! Please go to the (sec) Select Source page and select a valid UDL file


The Log Viewer utility connects successfully using both encrypted and unencrypted UDL files, when selecting option File > Open an Error Log From a Database

64-bit systems

The Audit Data Export Utility fails to connect using both encrypted or unencrypted UDL files. In both cases the following error is received:

Failed to connect to the database!
Failed to return a list of applications using database provided
SQL:
Error: Unknown (-2147217843)

Invalid UDL file. The database connect file is either invalid or points to a database that contains no HFM applications! Please go to the (sec) Select Source page and select a valid UDL file


When running the Log Viewer utility, then choosing File > Open an Error Log From a Database option and selecting the UDL file, the connection works only when unencrypted UDL file is used.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms