יום חמישי, 4 באוקטובר 2012

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.


אין תגובות:

הוסף רשומת תגובה