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

How to cancel agent executions

Received Response
226
Views
9
Comments
Paula Jaime
Paula Jaime Rank 2 - Community Beginner
edited Aug 27, 2024 5:17PM in Oracle Analytics Cloud and Server

Hi! I need to run an agent, but I get the error

[nQSError: 67020] The maximum number of concurrent instances of a scheduled job has been exceeded. The maximum limit is 1.

I see the same agent that I need to run in the Manage Agent Session view, so I want to cancel it. How can I do this?

Answers

  • Sumanth V -Oracle
    Sumanth V -Oracle Rank 8 - Analytics Strategist

    @PVJ - This error occurs when an agent is run and a prior job for the same agent has not yet completed.

    - Wait for the first Agent job to complete.
    - Once it is completed, another job can then be initiated for the Agent.

  • Paula Jaime
    Paula Jaime Rank 2 - Community Beginner

    Hello @Ashish-Oracle

    I have seen this doc, but I would like to cancel the agents, because they have been running for more than 5 hours, and they do not finish, and I need to get the results of the their execution.

  • Sumanth V -Oracle
    Sumanth V -Oracle Rank 8 - Analytics Strategist

    Hi @PVJ - You can use job manager client tool to cancel the jobs. Please refer the below document for details:

    https://docs.oracle.com/middleware/1221/biee/BIESJ/schedjobmgr.htm#i1023231

    You can restart the OBISCH component and that should also kill all the running or queued jobs at the time. Job manager is the recommended approach.

  • Ashish-Oracle
    Ashish-Oracle Rank 7 - Analytics Coach

    @PVJ Apart from what @Sumanth V -Oracle has suggested, below KM notes also talks about "Steps to Kill an Active Query". Please check if it helps:-


    What Are the Steps to Kill an Active Query When an Agent Keeps Running
    And It Prevents Scheduled Agent To Run (Doc ID 2783635.1)

  • Paula Jaime
    Paula Jaime Rank 2 - Community Beginner

    Thank you for your answers!

    I'm using OAC.

    Is the Scheduler Job Manager available in OAC? Is it a different tool from the Admin Tool?

    and in the admin tool, I open the repository in cloud mode, so Manage > Sessions is not able to select (the option is disabled)

    Paula

  • SivaB -Oracle
    SivaB -Oracle Rank 4 - Community Specialist

    @PVJ

    Users can cancel any delivery that they own.

    Admin user can suspend temporarily the agents which are created by other users

    Console> >Monitor Deliveries >Action menu

    image.png
  • Paula Jaime
    Paula Jaime Rank 2 - Community Beginner

    Thank you @SivaB -Oracle, but that doesn't work either.

    We have restarted the OAC service, but the agents are still visible in the Manage Agent Session view:

    image.png

    and I get the same error when I try to run the agent:

    image.png
  • Harriet Huang-Oracle
    Harriet Huang-Oracle Rank 5 - Community Champion

    @PVJ,

    Probably raise a SR to support team to assist on this.

  • User_TQH9C
    User_TQH9C Rank 1 - Community Starter

    @Paula Jaime Do you still have this issue with the OAS agent. I had this issue in OAS and restarting OAS services resolved the issue for me.