Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

BI Publisher Bursting Error!! Could not deliver the output for Delivery channel:null . Please check

Received Response
509
Views
12
Comments

Summary

BI Publisher Bursting Error!! Could not deliver the output for Delivery channel:null . Please check the Log for error details

Content

Hi,

I am using BI Publisher in EBS 12.1.3 and while executing bursting program , I am getting below error

Error!! Could not deliver the output for Delivery channel:null . Please check the Log for error details

Any pointers on this will be appreciated.

Thanks

«1

Answers

  • Vipin Agrawal-91274
    Vipin Agrawal-91274 Rank 2 - Community Beginner

    It looks like bursting program's output file for email is not getting generated at /usr/tmp location as I don't see file name , /usr/tmp/111517_125433713/17000325.pdf

  • Vipin Agrawal-91274
    Vipin Agrawal-91274 Rank 2 - Community Beginner

    We see the output as xls (spreadsheet) for the main data template based bi publisher request, its the bursting program that submitted after that isn't working , OPP log doesn't say anything and complete successfully.

    Thanks

  • User910243567
    User910243567 Rank 6 - Analytics Lead

    Can you please check if you can get more details from Output Post Processor log and share them here.

  • timdexter
    timdexter Rank 6 - Analytics Lead

    Well you need to get at the logs.

    The default setting will not give you much.

    Follow instructions on my post here to get  a more detailed log of whats happening

    https://blogs.oracle.com/xmlpublisher/debugging-bip-under-ebs

    Tim

  • Brajesh Shukla-95078
    Brajesh Shukla-95078 Rank 7 - Analytics Coach

    there could be several reason for this

    1. Check the mail id is present in the XML file(you can see the program XML by click request id > Diagnostics > View XML)

    2.  Please check in the Bursting control you have correctly specified the rtf template name with correct application name and locale

    3. Check the XML Administration responsibility > Administration Tab > Check the Temporary folder path....this path should physically exists in the application server with write permission.

  • Rajesh123
    Rajesh123 Rank 6 - Analytics Lead

    Hi please send your burst control file.

    Looks like your BCF is the problem.

  • Vipin Agrawal-91274
    Vipin Agrawal-91274 Rank 2 - Community Beginner

    Here is my bcs file

    <?xml version="1.0" encoding="utf-8"?>

    <xapi:requestset xmlns:xapi="http://xmlns.oracle.com/oxp/xapi" type="bursting">

       <xapi:request select="/XXABCPO/G_PARAMS/G_MAIN_PO">

          <xapi:delivery>

             <xapi:email id="123" server="mail.xyz.com" port="25" from="abc@xy.com" reply-to="abc@xy.com">

                <xapi:message id="123" to="${ABC_EMAIL}" attachment="true" content-type="html/text" subject="Test report ">This is a test report

    </xapi:message>

             </xapi:email>

          </xapi:delivery>

          <xapi:document key="${PO_NUMBER}" output="${PO_NUMBER}.xls" output-type="excel" delivery="123">

             <xapi:template type="rtf" location="xdo://XXABC.XXABC_PO.en.00/?getSource=true"/>

          </xapi:document>

       </xapi:request>

    </xapi:requestset>

    ------------

    Thanks

  • Vipin Agrawal-91274
    Vipin Agrawal-91274 Rank 2 - Community Beginner

    Hi Brajesh,

    1. email id is present in xml file  (under diagnostics> xml)

    2. rtf name is correct

    3.path /usr/tmp exists.

    Thanks

  • Brajesh Shukla-95078
    Brajesh Shukla-95078 Rank 7 - Analytics Coach

    Hi ,

    Hope you have all the valid values for server, email etc.

    Could you please paste program XML output and bursting program log file

  • sheebs_sheebs
    sheebs_sheebs Rank 2 - Community Beginner

    Is your location correct ? Is the template rtf or excel ? SELECT 'xdo://' || application_short_name || '.' || template_code || '.' || default_language || '.' || default_territory TEMPLATE_LOC FROM xdo_templates_vl WHERE template_code LIKE '%XXABC_PO%'; It should