Skip to Content

Partial results in WEBI

Feb 15, 2017 at 04:47 AM


avatar image
Former Member

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.

10 |10000 characters needed characters left characters exceeded
Former Member

Does scheduling the report fetches all 11 Lac records?

* Please Login or Register to Answer, Follow or Comment.

1 Answer

avatar image
Former Member Feb 21, 2017 at 07:48 AM

Try scheduling the report to narrow down the issue.

If scheduling gives you 11 Lac records you can check for Web intelligence process service parameters.

Also Check following things:

UDT: In universe parameters -> Controls tab -> Limit result set size

IDT: In Information Design Tool look for tab 'Query Options' under Universe Parameters under Business Layer "Limit Size of Result set".

10 |10000 characters needed characters left characters exceeded