Skip to Content
Feb 15, 2017 at 04:47 AM

Partial results in WEBI


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.