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

Scheduler Diagnostics

Received Response
21
Views
6
Comments
Maxwell Mumba
Maxwell Mumba Rank 3 - Community Apprentice
edited Aug 13, 2024 6:06PM in Oracle Analytics Cloud and Server

Hello,

Am running OBIEE 11.1.1.9.0  with  weblogic server version 10.3.6.0. I have scaled and increased the number of managed servers to four managed servers.

On bipublisher scheduler diagnostics, the enterprises scheduler status is "Instance - exalytics-bi01.1472943727200 's status has expired. Check the network connection and verify the instance is still running"

On weblogic the managed server state is running and the health is OK. Please assist

Answers

  • YGUTTIKONDA
    YGUTTIKONDA Rank 6 - Analytics Lead

    In the scheduler configuration please test the connection, my doubt is its not able to communicate to the database. it uses the bip_datasource ..

    you can find the DB connect string "you go to weblogic console  --> datasources --> bip_datasource"

    hope this helps

    --YG

  • Maxwell Mumba
    Maxwell Mumba Rank 3 - Community Apprentice

    Thank YG however, the datasource test connection is successfull on bip_datasource.  Attached is the error screen shoot:

    pastedImage_0.png

  • YGUTTIKONDA
    YGUTTIKONDA Rank 6 - Analytics Lead

    Can you please verify and perform the below steps .. (https://docs.oracle.com/cd/E28280_01/bi.1111/e22255/config_sched.htm#BIPAD4715)

    7.6.1 Resolving Quartz Configuration Errors

    The following is a common Quartz configuration error in the Scheduler Diagnostics page:

    Error Description and Resolution

    During the BI Publisher start up (when the WebLogic Managed server or Admin server are started) if the JNDI data source configured as jdbc/bip_datasource is unavailable, then the Quartz initialization will fail. The Scheduler Diagnostics page displays an error for Quartz Configuration.

    If this occurs, perform the following:

        1.Verify that the data source configured as jdbc/bip_datasource is available. On the Scheduler Configuration page, click Test Connection to ensure the connection is working.

        2.On the Scheduler Diagnostics page locate the "Database Schema" diagnostics item and ensure it passed.

        3.Go back to the Scheduler Configuration page and change the Scheduler Selection from "Quartz" to "None" and click Apply. Now change it back to "Quartz" and click Apply again.

        4.On the Scheduler Diagnostics verify that the Quartz error has cleared.

  • Maxwell Mumba
    Maxwell Mumba Rank 3 - Community Apprentice

    Hello YG, I have changed the scheduler configurations page; the Scheduler Selection from "Quartz" to "None" and click Apply. changed it back to "Quartz" and click Apply again, the error is still not resolved. Is this an scheduler error or the managed server instance expiring?

  • Maxwell Mumba
    Maxwell Mumba Rank 3 - Community Apprentice

    Hello YG, I have changed the scheduler configurations page; the Scheduler Selection from "Quartz" to "None" and click Apply. changed it back to "Quartz" and click Apply again, the error is still not resolved. Is this an scheduler error or the managed server instance expiring?

  • YGUTTIKONDA
    YGUTTIKONDA Rank 6 - Analytics Lead

    at this point i would suggest to raise and SR with oracle support