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

OBIEE 12.2.1.4.0 Agent won't run when using conditions

Received Response
53
Views
4
Comments
User_4Q6C0
User_4Q6C0 Rank 1 - Community Starter
edited Aug 13, 2024 7:25PM in Oracle Analytics Cloud and Server

Hello,

so we are using Agents for automated exports in OBIEE. Thing is, when I try to use a condition in the Agent, the Agent runs trough, gives me no error message, but doesn't export the PDF like it does when no condition is used. I tried setting it up with the False statement (since we only used the True part) but no matter how I set it up, it just won't export. I check the condition, and it says it's true. Not sure if it's a bug, since conditions work just fine for reports and analyses.

Anyone had such problem?

Answers

  • Ertugrul Dagsuyu
    Ertugrul Dagsuyu Rank 1 - Community Starter

    Hi,  i'm working on same version, there is no bug such as.

    Please, double check your condition analysis. If it is ok , then try your agent True If Row Count for equal your condition.

    If there are all ok then please add your analysis and condition info.

    Good lock

  • User_4Q6C0
    User_4Q6C0 Rank 1 - Community Starter

    Well, the condition is based on an analysis where a row shows up for different categories of products. If in that category there is none, nothing shows up. Now, I set up the analysis in such a way that it's restricted to a specific category, so that the condition would work. If I test it for bigger or for greater than 0, it comes as true, yet the Agent still won't work. That's why I think it's a bug. This is quite frustrating.

  • Gianni Ceresa
    Gianni Ceresa Mod

    Did you check the logs of the executed queries? When the agent is supposed to run (or if you execute it by hand), you must see the logs of the condition analysis executed, including the logical query etc.

    Look for that: is the query executed? Is it right? With which user it is executed? If the agent run as recipient you maybe have some row-level security jumping in etc.

  • User_4Q6C0
    User_4Q6C0 Rank 1 - Community Starter

    Thanks for the suggestion. Found a seperate log file for each time I ran the Agent and it wasn't exporting it. Turns out that even tho I specified a specific variable value, if a Presentation variable is still defined it will trigger the error. After I took that out and only left the specific value, it works. Thanks for the help!