Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

Scheduling BIP reports via Control M

Received Response
44
Views
1
Comments
Rynoh
Rynoh Rank 1 - Community Starter
in Oracle Analytics Cloud and Server

Summary

Scheduling BIP reports via Control M

Content

Hi All

we are trying to schedule BIP reports on Control M but i'm getting a ripple delivery error, anybody know what this means?

Environment information:

+--------------------+--------------------------------------------------+

|Account Name      
|LES_BIP                      
                   |

+--------------------+--------------------------------------------------+

|Oracle BI Server    |fxrepapplesq.it.nednet.co.za                    
|

+--------------------+--------------------------------------------------+

|User Name 
        |weblogic                                        
|

+--------------------+--------------------------------------------------+

Report details:

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

Report path:
/FCBIP_Reports/OPERATIONS/GROUP_PORTFOLIO_REPORT.xdo

Report type: Report

Report job name: GROUP_PORTFOLIO_REPORT.xdo

Report Parameters:

              
P_GROUP = '%'

              
P_BRANCH = '852'

              
P_RM = '%'

Output Format Template: Default

Output Format: Default

Calendar: Gregorian

Burst Report: N

Job ID: 1366

Report run failed

Job failure message:

Control-M for Oracle BI: ORACLE_BI0001 = Control-M for
Oracle BI: ORACLE_BI0001 = Job failed: RIPPLE_DELIVERY_FAILED
[INSTANCE_ID=fxrepapplesq.it.nednet.co.za.1458823838295] [OUTPUT_ID=1331]
RENDERING_REPORT_DOCUMENT [INSTANCE_ID=fxrepapplesq.it.nednet.co.za.1458823838295]

Job statistics:

+-------------------------+-------------------------+

|Start
Time             
|20171011103713           |

+-------------------------+-------------------------+

|End
Time               
|20171011103733           |

+-------------------------+-------------------------+

|Elapsed
Time           
|20                     
|

+-------------------------+-------------------------+

Exit Code    = 1

Exit Message = Control-M for Oracle BI: ORACLE_BI0001 =
Control-M for Oracle BI: ORACLE_BI0001 = Job failed: RIPPLE_DELIVERY_FAILED
[INSTANCE_ID=fxrepapplesq.it.nednet.co.za.1458823838295] [OUTPUT_ID=1331]
RENDERING_REPORT_DOCUMENT [INSTANCE_ID=fxrepapplesq.it.nednet.co

Answers

  • timdexter
    timdexter Rank 6 - Analytics Lead

    Hi

    I do not know the specific issue from the log, I can not see what type of delivery you have requested? However, it looks like Oracle Support have a doc that might help.

    https://support.oracle.com/knowledge/Oracle%20Cloud/2072632_1.html

    That mentions sftp but it might be a similar issue to yours.

    I would also check, can you run the same report from the BIP user interface? If so, then there is an issue with how Ctrl-M is calling the BIP server to run the report. If not, then there is an issue with your report definition and or the delivery configuration.

    Cheers

    Tim