Siebel BI Publisher 11g Scheduled Reports Are Failing With Error (Doc ID 1999003.1)

Last updated on APRIL 18, 2017

Applies to:

Siebel Reports - Version 8.1.1.1 SIA [21211] to 16.9 [IP2016] [Release V8 to V16]
Information in this document applies to any platform.

Symptoms

BIP 11.1.1.7.0/11.1.1.9.0 :-

1. Enable scheduling in Siebel using BI Publisher 11.1.1.7.0/11.1.1.9.0
2. Schedule the report from Siebel.
3. Scheduled job record will get created under 'Report Job History' Page, but with Error/Problem. You will be receiving error "505 ERROR" On clicking Report Job Name in Report Job History page

BIP 11.1.1.7.160119/11.1.1.7.150120/11.1.1.9.160119 :-

1. Download latest BI Publisher patch Oracle BI Publisher 11.1.1.7.150120 Or 11.1.1.7.160119 Or 11.1.1.9.160119. patch from document "Overview of Available Update Patches for Oracle BI Publisher Enterprise 11g Article ID 1276869.1]"

2. Install, complete scheduling configuration steps to enable scheduling in Siebel
3. Test scheduling Out of the box report 'Account List'
4. Navigate to Report Job History page, find Job ID record returns with 'Problem'

After reviewing the bipublisher.log, it has the following errors

-------------------------------------------------
[2015-04-03T02:27:17.594-06:00] [AdminServer] [WARNING] [] [oracle.xdo] [tid: 20] [userId: BISystemUser] [ecid: 427ccb08a405c5e8:57255d9d:14c7ded7e41:-8000-0000000000000003,0] [APP: bipublisher#11.1.1] !!!!!!! BurstingReportProcessor.renderReport :: [ReportProcessor]Error rendering document for [INSTANCE_JOB_ID=1008][[
[JOB_ID=1008]
[OUTPUT_ID=1001]
[REPORT_URL=/SiebelCRMReports/Account List.xdo]
[TEMPLATE=null]
[OUTPUT_FORMAT=pdf]
::oracle.xdo.XDOException: java.lang.reflect.InvocationTargetException
at oracle.xdo.template.fo.util.FOUtility.generateFO(FOUtility.java:1237)
at oracle.xdo.template.fo.util.FOUtility.generateFO(FOUtility.java:282)
at oracle.xdo.template.FOProcessor.createFO(FOProcessor.java:1993)
at oracle.xdo.template.FOProcessor.generate(FOProcessor.java:1155)
at oracle.xdo.servlet.RTFCoreProcessor.transform(RTFCoreProcessor.java:124)
at oracle.xdo.servlet.CoreProcessor.processScheduledRequest(CoreProcessor.java:1150)
at oracle.xdo.servlet.CoreProcessor.generateScheduledDocument(CoreProcessor.java:183)
at oracle.xdo.servlet.ReportImpl.renderScheduledJob(ReportImpl.java:885)
at oracle.xdo.enterpriseScheduler.bursting.BurstingReportProcessor.renderReport(BurstingReportProcessor.java:389)
at oracle.xdo.enterpriseScheduler.bursting.BurstingReportProcessor.onMessage(BurstingReportProcessor.java:127)
at oracle.xdo.enterpriseScheduler.util.CheckpointEnabledListener.onMessage(CheckpointEnabledListener.java:26)
at oracle.xdo.enterpriseScheduler.jmswrapper.client.JMSMessageConsumer.processMessage(JMSMessageConsumer.java:231)
at oracle.xdo.enterpriseScheduler.jmswrapper.client.ThreadedMessageDispatcher$DispatchWorker.run(ThreadedMessageDispatcher.java:158)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:909)
at java.lang.Thread.run(Thread.java:662)
Caused by: java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at oracle.xdo.common.xml.XSLT10gR1.invokeNewXSLStylesheet(XSLT10gR1.java:835)
at oracle.xdo.common.xml.XSLT10gR1.transform(XSLT10gR1.java:572)
at oracle.xdo.common.xml.XSLT10gR1.transform(XSLT10gR1.java:327)
at oracle.xdo.common.xml.XSLTWrapper.transform(XSLTWrapper.java:212)
at oracle.xdo.template.fo.util.FOUtility.generateFO(FOUtility.java:1213)
at oracle.xdo.template.fo.util.FOUtility.generateFO(FOUtility.java:282)
at oracle.xdo.template.FOProcessor.createFO(FOProcessor.java:1993)
at oracle.xdo.template.FOProcessor.generate(FOProcessor.java:1155)
at oracle.xdo.servlet.RTFCoreProcessor.transform(RTFCoreProcessor.java:124)
at oracle.xdo.servlet.CoreProcessor.processScheduledRequest(CoreProcessor.java:1147)
at oracle.xdo.servlet.CoreProcessor.generateScheduledDocument(CoreProcessor.java:183)
at oracle.xdo.servlet.ReportImpl.renderScheduledJob(ReportImpl.java:885)
at oracle.xdo.enterpriseScheduler.bursting.BurstingReportProcessor.renderReport(BurstingReportProcessor.java:386)
at oracle.xdo.enterpriseScheduler.bursting.BurstingReportProcessor.onMessage(BurstingReportProcessor.java:127)
at oracle.xdo.enterpriseScheduler.util.CheckpointEnabledListener.onMessage(CheckpointEnabledListener.java:25)
at oracle.xdo.enterpriseScheduler.jmswrapper.client.JMSMessageConsumer.processMessage(JMSMessageConsumer.java:231)
at oracle.xdo.enterpriseScheduler.jmswrapper.client.ThreadedMessageDispatcher$DispatchWorker.run(ThreadedMessageDispatcher.java:157)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
... 1 more
Caused by: oracle.xdo11g.xpath.XPathException: Namespace prefix 'ns' used but not declared.
at oracle.xdo11g.xslt.XSLProcessor.reportException(XSLProcessor.java:965)
at oracle.xdo11g.xslt.XSLProcessor.newXSLStylesheet(XSLProcessor.java:725)
at oracle.xdo11g.parser.v2.XSLProcessor.newXSLStylesheet(XSLProcessor.java:391)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at oracle.xdo.common.xml.XSLT10gR1.invokeNewXSLStylesheet(XSLT10gR1.java:835)
at oracle.xdo.common.xml.XSLT10gR1.transform(XSLT10gR1.java:572)
at oracle.xdo.common.xml.XSLT10gR1.transform(XSLT10gR1.java:328)
at oracle.xdo.common.xml.XSLTWrapper.transform(XSLTWrapper.java:212)
at oracle.xdo.template.fo.util.FOUtility.generateFO(FOUtility.java:1213)
at oracle.xdo.template.fo.util.FOUtility.generateFO(FOUtility.java:282)
at oracle.xdo.template.FOProcessor.createFO(FOProcessor.java:1993)
at oracle.xdo.template.FOProcessor.generate(FOProcessor.java:1155)
at oracle.xdo.servlet.RTFCoreProcessor.transform(RTFCoreProcessor.java:124)
at oracle.xdo.servlet.CoreProcessor.processScheduledRequest(CoreProcessor.java:1150)
at oracle.xdo.servlet.CoreProcessor.generateScheduledDocument(CoreProcessor.java:183)
at oracle.xdo.servlet.ReportImpl.renderScheduledJob(ReportImpl.java:885)
at oracle.xdo.enterpriseScheduler.bursting.BurstingReportProcessor.renderReport(BurstingReportProcessor.java:389)
at oracle.xdo.enterpriseScheduler.bursting.BurstingReportProcessor.onMessage(BurstingReportProcessor.java:127)
at oracle.xdo.enterpriseScheduler.util.CheckpointEnabledListener.onMessage(CheckpointEnabledListener.java:26)
at oracle.xdo.enterpriseScheduler.jmswrapper.client.JMSMessageConsumer.processMessage(JMSMessageConsumer.java:231)
at oracle.xdo.enterpriseScheduler.jmswrapper.client.ThreadedMessageDispatcher$DispatchWorker.run(ThreadedMessageDispatcher.java:158)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:909)
... 1 more
!!!!!!!
]]
[2015-04-03T02:27:17.594-06:00] [AdminServer] [WARNING] [] [oracle.xdo] [tid: 20] [userId: BISystemUser] [ecid: 427ccb08a405c5e8:57255d9d:14c7ded7e41:-8000-0000000000000003,0] [APP: bipublisher#11.1.1] !!!!!!! BurstingReportProcessor.renderReport :: [ReportProcessor]Error rendering document::oracle.xdo.servlet.scheduler.ProcessingException: [ReportProcessor]Error rendering document[[
--------------------------------------------------------

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