Hello Oracle Community, A client has been encountering an issue with their OTBI agents, which have been running smoothly for the past few years. Recently, the agents no longer run automatically unless they are logged in. When they open OTBI and manually trigger the agent, it runs perfectly, but unless they are logged in and actively watching the process, the agents do not execute as expected. The client has already tried troubleshooting with the following steps: * Verified the agent schedule and ownership settings. * Ensured that the agent’s associated user account has the necessary permissions. * Checked if the agents are set to run autonomously (independent of a logged-in session). * Tested the delivery profile for issues. * Cleared the browser cache and tested with a different browser. Despite these efforts, the issue persists. Has anyone experienced something similar or can provide further guidance on what could be causing this? Any documentation or suggestions would be appreciated! Thanks in advance!

Oracle Communities

Oracle Analytics and AI

Child Item

Issue with OTBI agents

Hello Oracle Community,

A client has been encountering an issue with their OTBI agents, which have been running smoothly for the past few years. Recently, the agents no longer run automatically unless they are logged in. When they open OTBI and manually trigger the agent, it runs perfectly, but unless they are logged in and actively watching the process, the agents do not execute as expected.

The client has already tried troubleshooting with the following steps:

Verified the agent schedule and ownership settings.
Ensured that the agent’s associated user account has the necessary permissions.
Checked if the agents are set to run autonomously (independent of a logged-in session).
Tested the delivery profile for issues.
Cleared the browser cache and tested with a different browser.

Despite these efforts, the issue persists. Has anyone experienced something similar or can provide further guidance on what could be causing this? Any documentation or suggestions would be appreciated!

Thanks in advance!

Find more posts tagged with

OTBI

Accepted answers

All comments

Bhaskar Konar

Hi @Basti,

One question:

Has the customer tried creating a new schedule with a new name and see if it is working fine?

(Just thinking in case the schedule itself got corrupted or not working somehow….)

Cheers,

Basti

Hi @Bhaskar Konar,

Thank you for your recommendation! I will ask the customer to give this a try.

Best Regards,
Sebastian

Basti

Hello OTBI Community, I'm still looking into additional recommendations to ensure we have a comprehensive set of solutions for the customer.

Best regards,
Sebastian

Basti

Hi @Bhaskar Konar

The customer created a completely new bot with a different name and schedule from the previous one. It ran successfully on Saturday and Sunday but did not execute this morning. We are also seeking additional help or thoughts on this.

Bhaskar Konar

Hi @Basti,

As the OTBI agent log is not available to the users, probably it's a good idea to raise an SR with Oracle support to investigate the Root Cause. Oracle Support will have access to those Agent logs in the Server and they will be able to suggest better.

Cheers,

Bhaskar Konar

Hi @Basti,

I had created the following Idea back in JUL-22, if it would have been available we can investigate the issue by our own.

Please take a look and feel free to vote if you like so that Oracle might consider in future.

Detailed log for OTBI Agent — Oracle Analytics

Thank You!

Cheers,

Riyaz Ali-Oracle

Try the below:

Session Dependency Issue

Some OTBI agents may be tied to an active session. Check if the agent is configured to run asynchronously rather than requiring an active user session.

Authentication & Security Settings

If recent security updates were applied, they might be preventing agents from running in the background. Verify if any Single Sign-On (SSO) or authentication changes have affected scheduled processes.

3.Agent Ownership & Permissions

Even though you've checked permissions, try reassigning the agent to a different user with full access and test if it runs automatically.

ravikiran goda-Oracle

HI @Basti

Is LBAC enabled in your environment?