Categories
- All Categories
- Oracle Analytics Lounge
- 13 Oracle Analytics Technical
- 182 Oracle Analytics News
- 39 Oracle Analytics Videos
- 15.3K Oracle Analytics Forums
- 5.9K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 62 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Agent Condition Evaluates to False Despite Analysis Returning Rows
Hi everyone,
I'm setting up an agent in Oracle BI with a condition based on an analysis. The configuration is as follows:
- Create condition based on: Analysis
- Condition Data: (Path to the analysis)
- True If Row Count: is greater than 0
The issue:
✅ When I run the analysis independently, it returns rows.
❌ However, when I test the agent’s condition, it evaluates to False.
I've confirmed that the analysis produces output, so I’m unsure why the agent is not detecting it.
Possible Causes I'm Considering:
- Caching Issue – Would clearing the BI cache help resolve this?
- Row Count Handling – Does the agent interpret row counts differently (e.g., should I try "greater than or equal to 1")?
Has anyone encountered this issue before? Any ideas on what might be causing the agent to evaluate the condition incorrectly?
Thanks in advance for your help!
Answers
-
Hi @Basti,
If the report in condition is returning any row when executed individually, the row count should be greater than '0'.
Also if you execute the report individually first and then check the condition from the agent it should not be impacted via Cache as the cache holds results for the exact same report.
Couple of Questions:
- Can you please double check the report path for the both cases? wanted to make sure same copy of the report is getting checked. So it should be the same for agent condition and individual execution.
- Is the user same for individual execution and execution via agent? If it is not a same user then it might be due to role etc. the same report is behaving differently for the different users.
Also please try clearing browser cache & cookies, logout close the browser and log back in and then execute the agent condition to see if it is returning any rows
Thank You!
0
