Financial Reporting (FR) Reports Open In Workspace With A Blank Screen No Grid (Doc ID 1333320.1)

Last updated on MARCH 21, 2022

Applies to:

Symptoms

The Admin user is seeing the following behaviors when trying to view Financial Reporting report in Workspace:

• FR reports open in Workspace but they are blank.
• FR reports with database connection will show the POV on top but the actual grid doesn't show.
• No suppression is applied to the report.
• If the report contain just a text box, the report opens but nothing displays in the report.
• The report print preview in FR studio works correctly.
• No Service fixes has been installed.

Error in FRLogging0.log

[FinancialReporting0] [ERROR] [] [oracle.EPMFR.core] [tid: [ACTIVE].ExecuteThread: '10' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid: <ecid>] [SRC_CLASS: com.hyperion.reporting.webviewer.WebDynamicReport] [APP: FINANCIALREPORTING#11.1.2.0] [SRC_METHOD: getCurrDesign] [[
com.hyperion.reporting.util.HyperionReportException: ; nested exception is:
javax.jcr.RepositoryException: com.sqribe.transformer.AuthorizationException: com.sqribe.transformer.GetMiniContainerBySmartCutCommand.execute: Read access to "/TestReport" is not permitted.
at com.hyperion.reporting.reportstore.ReportStoreManagerImpl.getObject(Unknown Source)
at com.hyperion.reporting.reportstore.ReportStoreManagerImpl.retrieveObject(Unknown Source)

........
........

Caused by: javax.jcr.RepositoryException: com.sqribe.transformer.AuthorizationException: com.sqribe.transformer.GetMiniContainerBySmartCutCommand.execute: Read access to "/TestReport" is not permitted.
at com.hyperion.reporting.jsr283.foundation.FoundationSession.getNode(FoundationSession.java:324)
at com.hyperion.reporting.reportstore.ReportStoreManagerImpl.getObject(Unknown Source)
at com.hyperion.reporting.reportstore.ReportStoreManagerImpl.retrieveObject(Unknown Source)


Additional details:

• Windows 2008 64bits
• FR Studio installed and working http://server:8200
• FR Print Server service is installed and the service is running fine
• FR and Workspace are accessed via IIS as the Web Application server.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.