BI Publisher 12.2.1.2.0 scheduleService v2 -scheduleReport Issue

Hareesh Yaddalapudi

Summary

BI Publisher 12.2.1.2.0 scheduleService v2 -scheduleReport Issue

Content

Hello everyone,

I'm facing a problem when trying to schedule a Report to specific future date using V2/ScheduleService in BI Publisher release 12.2.1.2.0.

I'm using soapUI 4.6.4 as the service consumer.

The soapUI message and error message am getting while scheduling a report:: I have follow the below two approaches. Please guide me the right approach to schedule a report.

1. Approach One.

     Scheduling the report to a specific date(20 14 22 23 MAR ? 2017) by passing repeatCount and repeatInterval as '0', but am getting the Exception as below

Input Schedule Request:-

     <v2:scheduleRequest>

           <v2:recurrenceExpression>ss mm HH dd MM ? yyyy</v2:recurrenceExpression>

            <v2:recurrenceExpressionType>cron</v2:recurrenceExpressionType>

            <v2:repeatCount>0</v2:repeatCount>

            <v2:repeatInterval>0</v2:repeatInterval>

           <v2:startDate>2017-03-23T09:51:18</v2:startDate>

      </v2:scheduleRequest>

Error:-

         <faultcode>soapenv:Server.userException</faultcode>

         <faultstring>oracle.xdo.webservice.exception.OperationFailedException: ScheduleServiceImpl::scheduleReport failure due to: null</faultstring>

       

2. Approach Two.

     Scheduling the report to a specific date(20 14 22 23 MAR ? 2017) by passing repeatCount and repeatInterval as '1', scheduled properly but the scheduled report is executing twice. See the below response on Report Job History .

Input Schedule Request:-

     <v2:scheduleRequest>

           <v2:recurrenceExpression>ss mm HH dd MM ? yyyy</v2:recurrenceExpression>

            <v2:recurrenceExpressionType>cron</v2:recurrenceExpressionType>

            <v2:repeatCount>1</v2:repeatCount>

            <v2:repeatInterval>1</v2:repeatInterval>

           <v2:startDate>2017-03-23T09:51:18</v2:startDate>

      </v2:scheduleRequest>

Report Job History  :- executed scheduled report twice at the same time.

     TestReport1 Company Sales Report.xdo  Success Mar 21, 2017 11:55:45 AM Mar 21, 2017 11:55:45 AM weblogic Public

     TestReport1 Company Sales Report.xdo  Success Mar 21, 2017 11:55:45 AM Mar 21, 2017 11:55:45 AM weblogic Public

The soapUI message I'm using to schedule the report is given bellow:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:v2="http://xmlns.oracle.com/oxp/service/v2">
   <soapenv:Header/>
   <soapenv:Body>
      <v2:scheduleReport>
         <v2:scheduleRequest>
            <v2:bookBindingOutputOption>false</v2:bookBindingOutputOption>
            <v2:dataModelUrl>/Sample Lite/Published Reporting/Data Models/Company Sales Report DM.xdm</v2:dataModelUrl>
            <v2:deliveryChannels>
               <v2:localOptions>
                  <v2:item>
                     <v2:destination>/tmp/Company Sales Report.pdf</v2:destination>
                  </v2:item>
               </v2:localOptions>
            </v2:deliveryChannels>
            <v2:jobLocale>en_US</v2:jobLocale>
            <v2:jobTZ>America/Chicago</v2:jobTZ>
            <v2:mergeOutputOption>false</v2:mergeOutputOption>
            <v2:notifyHttpWhenFailed>false</v2:notifyHttpWhenFailed>
            <v2:notifyHttpWhenSkipped>false</v2:notifyHttpWhenSkipped>
            <v2:notifyHttpWhenSuccess>false</v2:notifyHttpWhenSuccess>
            <v2:notifyHttpWhenWarning>false</v2:notifyHttpWhenWarning>
            <v2:notifyWhenFailed>false</v2:notifyWhenFailed>
            <v2:notifyWhenSkipped>false</v2:notifyWhenSkipped>
            <v2:notifyWhenSuccess>false</v2:notifyWhenSuccess>
            <v2:notifyWhenWarning>false</v2:notifyWhenWarning>
            <v2:recurrenceExpression>20 14 22 23 MAR ? 2017</v2:recurrenceExpression>
            <v2:recurrenceExpressionType>cron</v2:recurrenceExpressionType>
            <v2:repeatCount>1</v2:repeatCount>
            <v2:repeatInterval>1</v2:repeatInterval>
            <v2:reportRequest>
               <v2:attributeCalendar>Gregorian</v2:attributeCalendar>
               <v2:attributeFormat>pdf</v2:attributeFormat>
               <v2:attributeLocale>en_US</v2:attributeLocale>
               <v2:attributeTemplate>Sales by Company Org.</v2:attributeTemplate>
               <v2:attributeTimezone>America/Chicago</v2:attributeTimezone>
               <v2:byPassCache>true</v2:byPassCache>
               <v2:flattenXML>false</v2:flattenXML>
               <v2:parameterNameValues>
                  <v2:listOfParamNameValues>
                     <v2:item>
                        <v2:dataType>Integer</v2:dataType>
                        <v2:multiValuesAllowed>false</v2:multiValuesAllowed>
                        <v2:name>Year</v2:name>
                        <v2:refreshParamOnChange>true</v2:refreshParamOnChange>
                        <v2:selectAll>false</v2:selectAll>
                        <v2:templateParam>false</v2:templateParam>
                        <v2:useNullForAll>false</v2:useNullForAll>
                        <v2:values>
                           <v2:item>2009</v2:item>
                        </v2:values>
                     </v2:item>
                  </v2:listOfParamNameValues>
               </v2:parameterNameValues>
               <v2:reportAbsolutePath>/Sample Lite/Published Reporting/Reports/Company Sales Report.xdo</v2:reportAbsolutePath>
               <v2:sizeOfDataChunkDownload>-1</v2:sizeOfDataChunkDownload>
            </v2:reportRequest>
            <v2:saveDataOption>true</v2:saveDataOption>
            <v2:saveOutputOption>true</v2:saveOutputOption>
            <v2:scheduleBurstingOption>false</v2:scheduleBurstingOption>
            <v2:scheduleBurstringOption>false</v2:scheduleBurstringOption>
            <v2:schedulePublicOption>true</v2:schedulePublicOption>
            <v2:startDate>2017-03-23T09:51:18</v2:startDate>
            <v2:userJobName>Test55</v2:userJobName>
         </v2:scheduleRequest>
         <v2:userID>weblogic</v2:userID>
         <v2:password>weblogic1</v2:password>
      </v2:scheduleReport>
   </soapenv:Body>
</soapenv:Envelope>

Some help would be very appreciated.

Thanks & Regards

Hareesh