Financial Reports Error: "The Database Connection could not be found" When Running Financial Reporting Reports Against Essbase
Last updated on MAY 15, 2017
Applies to:Hyperion BI+ - Version 220.127.116.11.000 and later
Information in this document applies to any platform.
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#18.104.22.168] 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.
Any of the possible scenarios:
- The reports were migrated into an environment where the relevant substitution variables have not yet been defined.
- The report or the substitution variables have been edited in such a way that they are no longer compatible.
- If an Essbase cluster has been deleted and re-added, this can cause substitution variables to become undefined.
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