SBL-RPT-50529

pplies to:

Siebel Reports - Version 8.0.0.10 SIA [20436] and later
Information in this document applies to any platform.

Symptoms

When attempting to run BI Publisher Report,
the following error occurs:

In XMLP Report Server log the following error is shown:

ObjMgrLog Error 1 000008d94f563cce:0 2012-03-07 13:27:34 (soapbinding.cpp (564)) SBL-EAI-04304: Unknown Part ':oracle.apps.xdo.webservice.exception.OperationFailedException' for Operation 'runReport' exists in SOAP message.
ObjMgrBusServiceLog Error 1 000008d94f563cce:0 2012-03-07 13:27:34 (outdisp.cpp (201)) SBL-EAI-04308: Operation 'runReport' of Web Service 'http://xmlns.oracle.com/oxp/service/v11/PublicReportService.PublicReportServiceService' at port 'PublicReportService_v11' failed with the following explanation: "oracle.apps.xdo.webservice.exception.OperationFailedException: PublicReportService::generateReport failed: due to oracle.apps.xdo.XDOException".
ObjMgrBusServiceLog InvokeMethod 4 000008d94f563cce:0 2012-03-07 13:27:34 Business Service 'PublicReportService' invoke method 'runReport' Execute Time: 4.594 seconds.
ObjMgrBusServiceLog InvokeMethod 4 000008d94f563cce:0 2012-03-07 13:27:34 End: Business Service 'PublicReportService' invoke method: 'runReport' at 917a248
ObjMgrBusServiceLog Delete 4 000008d94f563cce:0 2012-03-07 13:27:34 Business Service 'PublicReportService' (address: '917a248')was unregsitered at model '116ca50' for session ''
ObjMgrBusServiceLog Delete 4 000008d94f563cce:0 2012-03-07 13:27:34 Business Service 'PublicReportService' was deleted at 917a248
XMLPReportLog XMLPReportError 1 000008d94f563cce:0 2012-03-07 13:27:34 Invalid User Name and Password for BIP Server
ObjMgrBusServiceLog Error 1 000008d94f563cce:0 2012-03-07 13:27:34 (xmlpadaptersvc.cpp (1940)) SBL-RPT-50529: Verify BI Publisher Server Userid and Password.
XMLPReportLog XMLPReportError 1 000008d94f563cce:0 2012-03-07 13:27:35 Error in generating Report Output file /int-sbl-poc-01/siebel/siebsrvr/xmlp/reports/EStestreport1-9P27A4.PDF in the XMLP Engine
ObjMgrBusServiceLog Error 1 000008d94f563cce:0 2012-03-07 13:27:35 (xmlpadaptersvc.cpp (2333)) SBL-RPT-50524: BI Publisher engine failed to generate report.

xdo.log shows the following error:
---------------------------------

[030812_085559797][oracle.apps.xdo.common.xml.XSLTWrapper][ERROR] XSL error:

<Line 34, Column 86>: XML-22008: (Error) Namespace prefix 'ref' used but not declared.

Cause

The issue is caused because of the incorrect references to the Integration Component Fields in rtf template.

rtf template ->field Properties -> show the code = "<?ref:xdo0008?>"

So the report generation failed and xdo.log shows the error "<Line 34, Column 86>: XML-22008: (Error) Namespace prefix 'ref' used but not declared."

Solution

1) Open the rtf template using BI Publisher Desktop
2) Load Sample XML
3) Click on 'Add Ins' Menu > Tools > Field Browser
4) Here, we can see all the fields and their codes.
5) Check for any entries similar to <?ref:xdo0007?>
6) Here, it was observed that the field (ssAccount) -> Right Click -> BI Publisher -> Properties -> had the entry -> (<?ref:xdo0007?>).
7) This is an invalid reference.
8) Correct the invalid references (to exact field name) in rtf template
9) Re-upload the report from Siebel and generate the report.