Cannot Create Database Connection For Financial Reports or run a Financial Report
(Doc ID 2731839.1)
Last updated on AUGUST 23, 2023
Applies to:
Hyperion BI+ - Version 11.2.0.0.000 and laterInformation in this document applies to any platform.
Symptoms
When trying to create a FR database connection the following error is thrown.
8001: The database connection could not be found: [UUID]
When trying to run a FR report the following error is thrown.
oracle.epm.repository.RepositoryException: java.sql.SQLSyntaxErrorException: ORA-00904: "DBMS_LOB"."SUBSTR": invalid identifier
This error will be in the FRLogging.log.
javax.jcr.PathNotFoundException: HRInternalFolder
com.hyperion.reporting.util.HyperionReportException: The object requested:
[HRInternalFolder] does not exist in the repository
Changes
The ORA-00904 error in conjunction with dbms_lob indicates that the execute privilege has not been granted to "PUBLIC" or has been revoked.
Cause
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
Symptoms |
Changes |
Cause |
Solution |