Oracle Fusion BI Publisher: BI Report Jobs are often failing with "Failed to retrieve data from Presentation ServerCould not connect to OBI Presentation Service" (Doc ID 2089660.1)

Last updated on JUNE 02, 2016

Applies to:

Oracle Fusion Application Toolkit - Version 11.1.9.2.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.1.9.2.0 version, Technology Management - BI & Reporting

ALCOA:P563 Bi Publisher Reports issues

Related SR 3-11656991861, we are facing issues again. Please note that the issues are observed intermittently and faced across both the scaled out servers. The services are running since more than two to three weeks now.

Need help in identifying if root cause of this issue. Last time it was resolved by bouncing the services (please refer to SR: 3-11656991861)

The issue is that many of the bursting sql fail with similar errors
 
ERROR
-----------------------
"::JOB_PROCESSOR_EXCEPTION::[INSTANCE_ID=adela540p.1447476142162] [INSTANCE_JOB_ID=33360]::oracle.xdo.servlet.scheduler.ProcessingException: ::ERROR_GETTING_REPORT_DATA::[INSTANCE_ID=adela540p.1447476142162] DataException:[INSTANCE_JOB_ID=33360] Invalid parameters requested.
oracle.xdo.servlet.data.DataException: Invalid parameters requested.
at oracle.xdo.servlet.ReportImpl.renderReportXML(ReportImpl.java:756)
at oracle.xdo.enterpriseScheduler.bursting.BurstingJobProcessor.getReportData(Burst"


"::JOB_PROCESSOR_EXCEPTION::[INSTANCE_ID=adela540p.1447476142162] [INSTANCE_JOB_ID=33245]::oracle.xdo.servlet.scheduler.ProcessingException: ::ERROR_GETTING_REPORT_DATA::[INSTANCE_ID=adela540p.1447476142162] DataException:[INSTANCE_JOB_ID=33245] java.sql.SQLSyntaxErrorException: ORA-01722: invalid number

oracle.xdo.XDOException: java.sql.SQLSyntaxErrorException: ORA-01722: invalid number

at oracle.xdo.dataengine.XMLPGEN.processMergedDataSet(XMLPGEN.java:1653)
at oracle.xdo.dataengine.DataPro"

"::JOB_PROCESSOR_EXCEPTION::[INSTANCE_ID=adela540p.1447476142162] [INSTANCE_JOB_ID=33246]::oracle.xdo.servlet.scheduler.ProcessingException: ::ERROR_GETTING_REPORT_DATA::[INSTANCE_ID=adela540p.1447476142162] DataException:[INSTANCE_JOB_ID=33246] Invalid parameters requested.
oracle.xdo.servlet.data.DataException: Invalid parameters requested.
at oracle.xdo.servlet.ReportImpl.renderReportXML(ReportImpl.java:756)
at oracle.xdo.enterpriseScheduler.bursting.BurstingJobProcessor.getReportData(Burst"


"::JOB_PROCESSOR_EXCEPTION::[INSTANCE_ID=adela540p.1447476142162] [INSTANCE_JOB_ID=33248]::oracle.xdo.servlet.scheduler.ProcessingException: ::ERROR_GETTING_REPORT_DATA::[INSTANCE_ID=adela540p.1447476142162] DataException:[INSTANCE_JOB_ID=33248] Failed to retrieve data from Presentation ServerCould not connect to OBI Presentation Service
java.lang.RuntimeException: Failed to retrieve data from Presentation ServerCould not connect to OBI Presentation Service
at oracle.xdo.servlet.data.SawDataSou"


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
These two reports are scheduled to run daily, weekly and monthly:
/Alcoa HCM Reports/TM Monitor Performance Process.xdo
/Alcoa HCM Reports/TM Performance Document Details.xdo

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot .

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