Partial results in WEBI

general discussion
1

Hello All,

User has created one report and expecting it to fetch 11 lac records in BO. But report is partially executing.

We have 11 Lac rows in our DB which are getting retrieved at SQL server in just 2 min.

We have made changes in universe and connection setting as follows:

Limit Execution Time to: 60 min

Connection settings are as follows:

Pool Time out: 60 min

Array Fetch size: 1000

Array Bind size: 5000

Login Time out: 600 Seconds

No restrictions are set to report level.

Also report is based on universe where only one table is there. and that table is actually a view created on SQL server.

Report is exactly running for 60 min but retrieving only 1 lac 12 thousand rows.

Please help.

kushal.pardeshi (BOB member since 2017-02-15)

2

The retrieval process starts before 60 minutes is up but has not completed until after that limit has been reached, hence partial results.

I’d question why they are trying to bring that many rows back rather than using aggregates. What does the report do, that necessitates it returning 1.1 million rows?

3

Is this the full result set though?
Most SQL query tools usually only return a subset of the full results of a query.

Mak 1 :uk: (BOB member since 2005-01-06)

4

Good point. It’s started to retrieve it in two minutes - how long does it take to return all the results? I’d imagine the Webi Server is getting heavily loaded if it’s a report with lots of calculations, which are probably needed if you’re returning that many rows.