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.


תגובות

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

פוסטים פופולריים מהבלוג הזה

FINS Data Transfer Utilities

תמונה
The best thing while working on siebel is you are never short of options. Recently we had requirement of updating a Service request from contact. Finally we did that using "EAI Siebel Adapter" business service. However during that time i came across another business service "FINS Data Transfer Utilities" popularly known as DTU business service. As i was not having prior knowledge of it going by the rule of not learning swimming lessons while drowning i decided not to go for it. Lately i have tried to explore this service and trust me it can do wonders. Here is a sample example update of Service Request from contact. We need to follow below steps in order to understand strength of this business service. 1 - Navigate to Site Map. Go to Administration - Application -> Data Map Administration tab. Create a new Record with following options: Name: Service Request Test Source Business Object: Contact Destination Business Object: Service Request Here the source business
המשך לקרוא

SBL-BPR-00191: The rowId of the active row of the primary buscomp '%1', '%2', does not match the Primary Id

Applies to: Product Release: V7 (Enterprise) Version: 7.5.3 [16157] ESN Database: Oracle 9.2.0.2 Application Server OS: Microsoft Windows 2000 Server SP 3 Database Server OS: Microsoft Windows 2000 Server SP 3 This document was previously published as Siebel SR 38-1386997031. Symptoms SBL-BPR-00191 We have a error with a workflow. This WF is excuted by policy when a particular activity is closed. The WF Business Object is 'Action'. Inside this WF, there is a subprocess that invokes a Business Service that creates a new activity. In a second subprocess, the region Id of this new activity is updated using the standar update method funcionality of Siebel workflow process. Error processing Siebel Operation for: Business Object 'Action' Business Component 'Action' Primary Id ''1-5NEI6' Operation 'Insert'(SBL-BPR-00100) -- The rowId of the active row of the primary buscomp 'Action', '1-4SNCV', does not match the Prima
המשך לקרוא

Profile Attributes and Open UI

תמונה
Yes, Profile Attributes! As the ever attentive, up-to-date Siebel CRM expert that you are when you read this, you know that in Siebel Open UI (since version 15), it is no longer allowed/supported to  set  Profile Attributes from browser-side script. But  getting  them is not a problem, since the  GetProfileAttr  function works perfectly fine. Recently I found a few vanilla Profile Attributes that came quite handy in my work in Open UI JavaScript: Navigation Type : stores the navigation type such as "NAVIGATION_TAB" ActiveViewName : does what it says on the tin IsOpenUI : returns "1" when the application runs in Open UI Is SUI Theme : when "TRUE", the application theme is Synergy (aka SUI) Position:  returns the currently active position Primary Responsibility Name : guess what this one is… Profile Image : returns the URL of the user's profile image Org.Name : returns the name of the user's organization Here's a sample line of
המשך לקרוא