Skip to Content
0

Partial Results error

Apr 26, 2017 at 11:18 AM

18

avatar image

Hi,

We have a query that in schedule mode executes within 30minutes. There are times when it gives “Partial results” message with no row displayed.

For example, this morning it was all good, while in the afternoon it showed no rows and “Partial Results”.

The report’s SQL is based on 2 derived tables with a long and complicated sql definition.

Any ideas on what has to be changed in order not to show Partial Results message?

It should fetch about 1200 rows, so it’s not that much.

Version :BOXI3

Source: universe/Oracle db

Many thanks

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Rg12 Rg12 Apr 26, 2017 at 11:55 AM
0

Could it be because of the limit on execution time at universe level? What would be the downfalls if I set it to 60 miuntes?


xycma.png (63.9 kB)
Share
10 |10000 characters needed characters left characters exceeded