Error when creating a new FR connection

If you face the following errors when creating a new database connection of Financial Rerporting on a 64-bit server and 11.1.2 version you just will need to change some JVM Options of Financial Reporting Server to solve this issue.

Errors

  • “Error connecting to database connection <server/database>: com/hyperion/ap/adm/HssConn”
  • “Error connection to database connection <server/database>: no HssJNIDriver950 in java.library.path”

Solution

  • Open the registry editor (regedit.exe);
  • Open the path “HKEY_LOCAL_MACHINE\SOFTWARE\HyperionSolutions\FinancialReporting0\HyS9FRReports”;
  • At the JVM Options JVMOption13, JMOption17 and Env2, change the path
    “C:\Oracle\Middleware\EPMSystem11R1\common\ADM-64\11.1.2.0\bin” for
    “C:\Oracle\Middleware\EPMSystem11R1\common\ADM\11.1.2.0\bin-64”;
  • Restart the “Hyperion Financial Reporting – Web Application” service;

This is a Known Issue and is already posted at the Readme of the 11.1.2 Reporting and Analysis.

Igor Simoes.

Advertisements
This entry was posted in Oracle Hyperion Financial Reporting and tagged , , , , , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s