nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Scheduled Agent only returns 250 rows from a report with over 3k records.

User_XBGA6

Hi Everyone,

I have a scheduled agent that successfully runs but only pulls 250 records from an analysis of over 3k records and growing. I have tried having the Agent use a condition such that the analysis row count is 3k which returns True when I test but still doesn't attach all the data in an excel whenever the agent runs. I have tested the delivery content using both Dashboard Page options and Condition Analysis and they both send the same results. I am seeking expert help from anyone here so that I can get over this blocker. We use OBIEE 11g (11.1.1). Thank you.

Find more posts tagged with

Agents

Scheduling or Agents

Accepted answers

All comments

Mallikarjuna Kuppauru-Oracle

Hi @ User_XBGA6 ,

Welcome to the Oracle Analytics Online Forum!

To enhance your experience and foster meaningful interactions, we encourage you to personalize your profile by setting up a display name and uploading a profile picture. Your display name will be how others recognize and engage with you in discussions, while a profile picture adds a personal touch to your forum presence. Take a moment to update your profile with a display name and an image representing you. Let's create a vibrant and engaging community together!

Refer below MOS doc -

OBIEE 11g & 12c: How To Increase the Number of Rows Displayed in a Report in an Agent (Doc ID 1381801.1)

Regards,

Arjun

Mallikarjuna Kuppauru-Oracle

Hi @ User_XBGA6 ,

Support Identifier --> you may request/check with your sales team or Admin who can able to provide an access to oracle support portal access.

The <DefaultRowsDisplayedInDelivery> parameter in instanceconfig.xml controls the number of rows to be delivered in an Agent. For example, to set the limit to 25000 rows, you would set the parameter as follows:

Better to do at /em console level instead of file change.

Regards,

Arjun

User_XBGA6

Thank you for sharing critical information from the document. I will liaise with my Admin to get this Support Identifier so that I can have full access.

Federico Venturin - Oracle

Hi @User_XBGA6 ,

In addition to what has been suggested by @Mallikarjuna Kuppauru-Oracle , I would also check that the physical queries generated by the analysis and the agent are exactly the same.

Moreover.. Since OBIEE 11g is really old and no longer supported, I highly recommend to migrate to the latest version of OAS, or OAC.

User_XBGA6

Thank you for your additional feedback @Federico Venturin. I'm not sure if I understand you correctly but I built this analysis from a subject area, added a date prompt to the dashboard alongside the analysis then tried to schedule it. I strongly believe the query to be the same. I'm 2 months into using OBIEE in a new role that I recently started. I previously worked with different BI tools so forgive me if I don't come across accurately. And yes, I already found discussions on moving to OAS/OAC so I am hoping that we do migrate soon. Cheers!

Federico Venturin - Oracle

Hi @User_XBGA6 ,

There is nothing to forgive! In OBIEE things could be more complex than they actually look, and I'm paranoid by default :)

If you scheduled the dashboard page then the physical queries are expected to be the same (the agent will apply the default selections made in dashboard prompts). If you scheduled the analysis, then the agent allows you to manually select values for each is prompted filter (which could be different from the default selections in dashboard prompts).

You should also take into consideration which user is running the dashboard page and the agent. If they are executed by different users and row-level security is in place, then they can potentially get a different result set.

Mallikarjuna Kuppauru-Oracle

Hi @ User_XBGA6

Any update on this Thread. If you think we have answered your quesiton, you may accept the answer so that other community user can refer the same.

Regards

Arjun

User_XBGA6

Hi @Mallikarjuna Kuppauru-Oracle. My IT Admin couldn't get me the Support Identifier. I, however, used the other option of changing the <DefaultRowsDisplayedInDelivery> parameter in instanceconfig.xml controls which still didn't work for us. I appreciate your valuable help, nevertheless. I just wish that I had access to the document you shared. We resolved to have the report sent out to group emails manually by exporting the report weekly in the meantime.

Thank you.

Madasamy -Oracle

I see you are using 11.1.1.* ( maybe 11.1.1.9)

Please check the session log of the analysis execution through the Agent and see how many records have been fetched. You can check if there is a RUN AS used in the General configuration of the agent.
If the same user runs the same session, we assume that the records retrieved is 3000?
Check if there are any configuration set to 250 for obips and in the Enterprise Manager Console -> BI Home application -> Capacity Management .