Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forum› Oracle Analytics Forum

Categories

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

BI Publisher - Report Jobs do not seem to work

Received Response
871
Views
29
Comments
2

Answers

  • Ioanna Kat-Oracle
    Ioanna Kat-Oracle Rank 4 - Community Specialist

    @Thomas,

    I configured the connection with the correct username and password and when I test it it says success.

    Anyway the email is not being sent, even if I looked with a different user.

  • Sherry George
    Sherry George Rank 7 - Analytics & AI Coach

    In addition to what Thomas Dodds has said, check the bipublisher.log file to see any additional error/warning messages

  • Ioanna Kat-Oracle
    Ioanna Kat-Oracle Rank 4 - Community Specialist

    @Thomas

    Thank you !!!

    I tried this query and it returned no results.

    So the H means status Held/Waiting.

    Any ideas on how to debug this?

    The xmlp_sched_output has no records.

    Thank you again ,

    Ioanna

  • Ioanna Kat-Oracle
    Ioanna Kat-Oracle Rank 4 - Community Specialist

    ​ There are no logs, neither in bipublisher.log nor in the bipublisher.out.

    Do you know in which logger should I increase the log level??

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics & AI Strategist

    Also ... post a pic of the Report template list ... do you have one marked default?  And is your scheduled job pointing to that specific template as output?

  • Ioanna Kat-Oracle
    Ioanna Kat-Oracle Rank 4 - Community Specialist

    Hello ​,

    I tried and increased the log level, thanks !! So the errors that I am getting are the following:

    Requested layout null not found: Default Layout

    ​  I tried the query but still no results :/

    Do you have any insights of this? I checked the layout but it seems fine.

  • Sherry George
    Sherry George Rank 7 - Analytics & AI Coach

    It seems that you have a number of errors in the bipublisher log. Can you copy and  paste all the messages from the bipublisher.log (you can download the file from EM)  file with a timestamp close to the report run time.

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics & AI Strategist

    ​ thx for helping to tag-team this one!

  • Sherry George
    Sherry George Rank 7 - Analytics & AI Coach

    You are welcome, just trying to get as much information as possible. Difficult to troubleshoot with bits and pieces of information. Hopefully this gets resolved.

  • Sherry George
    Sherry George Rank 7 - Analytics & AI Coach

    Hi Ioanna,

    Could you also check that you have no errors in scheduler diagnostics. This is under Administration->System Maintenance->Scheduler Diagnostics