Configuration about query timeout doesn't work

Questions & Answers
1

Hi everyone,

I have had problems with query timeout and I tried to add the following configuration:

    [mondrian.rolap]
    queryTimeout = 240

But it doesn’t work, the EazyBI still responding 503 when the query hits 50 seconds. This is the query that I’m trying to perform:

    -- annotations.group=Percentile
Cache(
  Count(
    Filter(Descendants([Issue].CurrentMember, [Issue].[Issue]),
      DateBetween(
        [Issue].CurrentHierarchyMember.Get('Resolved at'),
        [Measures].[Sprint end date minus 90 days],
        [Measures].[Sprint end date]
      )
      AND [Measures].[Issues resolved] > 0)
  )
)

Thanks,
Ricardo Tulio

2

Hi @ricardotulio!

The increase of timeout works only if you have enabled the eazyBI child process. Please check if you have done so.

Regarding the formula, I imagine we could make it simpler by using the Time period instead of iterating through issues. If you wish to sum all issues that are resolved between Sprint dates, you could use the DateMembersBetween function with Time day members. Please try if the following works faster

  Sum( -- sum issues resolved in the Sprint period calculated from Sprint end date
    [Time].[Day].DateMembersBetween(
      [Measures].[Sprint end date minus 90 days], 
      [Measures].[Sprint end date]
    ), [Measures].[Issues resolved]
  )

Lauma / support@eazybi.com