Financial Reports Error: "The Database Connection could not be found" When Running Financial Reporting Reports Against Essbase (Doc ID 1348199.1)

Last updated on MAY 15, 2017

Applies to:

Hyperion BI+ - Version 11.1.2.1.000 and later
Information in this document applies to any platform.
12.9.15

Symptoms

When you run a Financial Reporting report which uses an Essbase data source, the report fails with the error:

The Database Connection could not be found:  __DTS__<UUID of datasource>

Only reports using substitution variables are affected. The FRLogging.log file (under Oracle\Middleware\user_projects\domains\servers\FinancialReporting0\logs) shows error similar to:

[2011-08-11T11:14:42.622-04:00] [FinancialReporting0] [ERROR] [] [oracle.EPMOHPS] [tid: 27] [userId: <anonymous>] [ecid: 0000J6pFmsQ5qYWFLzQLOA1EGi4H000000,1:16935] [APP: FINANCIALREPORTING#11.1.2.0] Cannot get variable. Essbase Error(1051083): Substitution variable CurYr does not exist[[com.essbase.api.base.EssException: Cannot get variable. Essbase Error(1051083): Substitution variable CurYr does not exist.

Changes

Any of the possible scenarios:

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