"Document partially refreshed" while schduling a w

Hi,

I am getting “Document partially refreshed” message when i am trying to schedule a webi report.
Please let me know the probable cause of this issue and what parameter needs to be checked.

Regards,
DB


D.bhat (BOB member since 2010-06-04)

Universe - Universe Parameter - Control Tab - Limit Size of result set to

Also check if there are limits enforced on Properties tab on the webi query.

Cheers.


BO_Stuffed (BOB member since 2008-03-29)

Reult set is set to 400000 and time is 20 minutes.

Report also includes 10 prompts.


D.bhat (BOB member since 2010-06-04)

In webi query properties

Max Rows are set to : 400000
And Max Time set to 1200.

Bothe the check bobes are not checked.

Also i experienced this problem intermittently.

What could be the cause of this message.

Regards,
DB


D.bhat (BOB member since 2010-06-04)

Check your universe properties, you need to increase the result set in the universe, not just in Webi. If you run the report manually do you get a partial results message?

I would assume that it is intermittent because sometimes the query hits the result set limit and sometimes it doesn’t.


foxymophandlemama :new_zealand: (BOB member since 2008-06-24)

Any other reason for the behavior as i am trying the same report which gave the message yesterday.

Yesterday it pops the message " Document partially refreshed" and today it did not.

BR,
DB


D.bhat (BOB member since 2010-06-04)