Oracle Analytics Cloud and Server

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

Scheduled BI Publisher Jobs remain running status (but job is succesfull)

Received Response
61
Views
4
Comments

Summary

Scheduled BI Publisher Jobs remain running status (but job is succesfull)

Content

I scheduled a job, normally it runs in 2-3 minutes but today, it can not finish.

Job status is running mode for almost 3 hours. There is no error or anything else

Also, i checked db logs if there is a query that comes from bipublisher and  nothing comes.

Can you help about that?

**********************************************************************************

I want to make a correction,

Bursting job (sends e-mail) works fine, After job works, e-mails were delivered to recipients.

But job status is still running mode.  I can not see if it finishes succesfully or not.

**********************************************************************************

Answers

  • Sherry George
    Sherry George Rank 7 - Analytics Coach

    Did you check the bipublisher.log?

    Edit: Also post the exact version of BI publisher. There are known issues with Bi publisher UI not updating the status of failed jobs. If you have access to my oracle support, just search for 'bi publisher job stuck in running status' or similar and you will see quite a few issues.

  • Sherry George
    Sherry George Rank 7 - Analytics Coach

    I would bump up the bipublisher.log to look for any clues. The best thing would be to upgrade to the latest 11g version.

  • Ramazankapukaya
    Ramazankapukaya Rank 3 - Community Apprentice

    Hi Sherry,

    Thank you for reply, I made a correction about job status.

    Have you any idea about that.

    Also, Version is 11.1.1.6

  • Ramazankapukaya
    Ramazankapukaya Rank 3 - Community Apprentice

    I will apply patch.