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 03, 2021
Applies to:Hyperion BI+ - Version 22.214.171.124.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: <ecid>] [APP: FINANCIALREPORTING#126.96.36.199] 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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document