Financial Reporting (FR) Reports Fail With Error: "Essbase Error (1007090): Unknown Member Name [null] In Outline Query" (Doc ID 2135867.1)

Last updated on MAY 12, 2016

Applies to:

Hyperion Financial Management - Version 11.1.2.4.000 and later
Information in this document applies to any platform.

Symptoms

When some users attempt to open/run FR reports, the below error message is seen:

Error executing query: Error: Select members failed [Cannot query members by name: Essbase Error(1007090): Unknown member name [Current Point of View for Year] in outline query].

In the FRLogging.log file (<Oracle_Home>\Middleware\user_projects\domains\EPMSystem\servers\FinancialReporting0\logs), the following error appears:

[2016-04-05T11:37:23.050+00:00] [FinancialReporting0] [NOTIFICATION] [] [oracle.EPMFR.performance] [tid: Thread-53] [userId: <anonymous>] [ecid: 0000LEdSTcpBh4H6yv7i6G1Mx1Jo000000,1:29975] [APP: FINANCIALREPORTING#11.1.2.0] [SRC_CLASS: com.hyperion.reporting.util.HRLogTimer] [SRC_METHOD: logTimeEnd] PERF: 000092: 0000000000 DataQuery createCubeViews
[2016-04-05T11:37:23.050+00:00] [FinancialReporting0] [NOTIFICATION] [] [oracle.EPMFR.performance] [tid: Thread-53] [userId: <anonymous>] [ecid: 0000LEdSTcpBh4H6yv7i6G1Mx1Jo000000,1:29975] [APP: FINANCIALREPORTING#11.1.2.0] [SRC_CLASS: com.hyperion.reporting.util.HRLogTimer] [SRC_METHOD: logTimeEnd] PERF: 000092: 0000000000 DataQuery initAdmCubeViews
[2016-04-05T11:37:23.052+00:00] [FinancialReporting0] [ERROR] [] [oracle.EPMFR.core] [tid: Thread-53] [userId: <anonymous>] [ecid: 0000LEdSTcpBh4H6yv7i6G1Mx1Jo000000,1:29975] [APP: FINANCIALREPORTING#11.1.2.0] [SRC_CLASS: com.hyperion.reporting.results.ExecGrid] [SRC_METHOD: executeGridObject] 5206[[
com.hyperion.reporting.util.HyperionReportException: Cannot find dimension xxxxxxxxxx
at com.hyperion.reporting.haradm.EssbaseMDXDataQuery.createAdmQry(EssbaseMDXDataQuery.java:633)
at com.hyperion.reporting.results.ExecGrid.executeGridObject(ExecGrid.java:1212)
at com.hyperion.reporting.results.ExecReport.executeReport(ExecReport.java:448)
at com.hyperion.reporting.reportserver.FetchInstanceThread.runDesign(FetchInstanceThread.java:180)
at com.hyperion.reporting.reportserver.FetchInstanceThread.run(FetchInstanceThread.java:107)

[2016-04-05T11:37:28.789+00:00] [FinancialReporting0] [ERROR] [] [oracle.EPMFR.core] [tid: [ACTIVE].ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid: 005Bvh52FRRBh4H6yv7i6G000Bgy000KuC,0:1] [APP: FINANCIALREPORTING#11.1.2.0] [SRC_CLASS: com.hyperion.reporting.security.jaas.FRUserPreferences] [SRC_METHOD: setPov] [[
com.hyperion.reporting.util.HyperionReportException: ; nested exception is:
javax.jcr.RepositoryException: com.sqribe.transformer.AuthorizationException: com.sqribe.transformer.GetFolderByPathCommand.translatePathToFolder: Read access to "/HRInternalFolder/UserPov" is not permitted.

 

When an administrator user runs the same reports, there are no errors.

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