AnsweredAssumed Answered

mondrian.olap.MondrianException: Mondrian Error:Internal error: Query required more than 12 iterations

Question asked by B241N7QV on Sep 28, 2018

Hi,

I am having the error "query required more than 12 iterations" in Mondrian. I have modified the property mondrian.rolap.evaluate.MaxEvalDepth in mondrian.properties to reduce the amount of errors but I'm still getting the same error.

The thing is that if I retry executing the same query again in Spoon right after getting the exception, it works fine!!!!

Any idea of how to solve this problem?

Thanks.

 

 

I attach the error:

 

2018/09/26 19:34:01 - realizar qry_gap_3.0 - ERROR (version 6.1.0.1-196, build 1 from 2016-04-07 12.08.49 by buildguy) : Unexpected error

2018/09/26 19:34:01 - realizar qry_gap_3.0 - ERROR (version 6.1.0.1-196, build 1 from 2016-04-07 12.08.49 by buildguy) : mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [with member [Measures].[visitas_mod] as 'IIf(IsEmpty([Measures].[Visitas]), 0, [Measures].[Visitas])'

2018/09/26 19:34:01 - realizar qry_gap_3.0 - select Crossjoin({[Tipo asistencia].[Tipo Asistencia].Members}, {[Measures].[visitas_mod]}) ON COLUMNS,

2018/09/26 19:34:01 - realizar qry_gap_3.0 -   {[Ubicacion].[GAP].Members} ON ROWS

2018/09/26 19:34:01 - realizar qry_gap_3.0 - from [Primaria AGG_V2]

2018/09/26 19:34:01 - realizar qry_gap_3.0 - where [TIEMPO.Tiempo].[2018].[3T].[8]

2018/09/26 19:34:01 - realizar qry_gap_3.0 - ]

2018/09/26 19:34:01 - realizar qry_gap_3.0 - at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:987)

2018/09/26 19:34:01 - realizar qry_gap_3.0 - at mondrian.olap.Util.newInternal(Util.java:2410)

2018/09/26 19:34:01 - realizar qry_gap_3.0 - at mondrian.olap.Util.newError(Util.java:2426)

2018/09/26 19:34:01 - realizar qry_gap_3.0 - at mondrian.rolap.RolapConnection.executeInternal(RolapConnection.java:707)

2018/09/26 19:34:01 - realizar qry_gap_3.0 - at mondrian.rolap.RolapConnection.access$000(RolapConnection.java:52)

2018/09/26 19:34:01 - realizar qry_gap_3.0 - at mondrian.rolap.RolapConnection$1.call(RolapConnection.java:623)

2018/09/26 19:34:01 - realizar qry_gap_3.0 - at mondrian.rolap.RolapConnection$1.call(RolapConnection.java:621)

2018/09/26 19:34:01 - realizar qry_gap_3.0 - at java.util.concurrent.FutureTask.run(Unknown Source)

2018/09/26 19:34:01 - realizar qry_gap_3.0 - at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

2018/09/26 19:34:01 - realizar qry_gap_3.0 - at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

2018/09/26 19:34:01 - realizar qry_gap_3.0 - at java.lang.Thread.run(Unknown Source)

2018/09/26 19:34:01 - realizar qry_gap_3.0 - Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: Query required more than 12 iterations

2018/09/26 19:34:01 - realizar qry_gap_3.0 - at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:984)

2018/09/26 19:34:01 - realizar qry_gap_3.0 - at mondrian.olap.Util.newInternal(Util.java:2403)

2018/09/26 19:34:01 - realizar qry_gap_3.0 - at mondrian.rolap.RolapResult.executeBody(RolapResult.java:1047)

2018/09/26 19:34:01 - realizar qry_gap_3.0 - at mondrian.rolap.RolapResult.<init>(RolapResult.java:504)

2018/09/26 19:34:01 - realizar qry_gap_3.0 - at mondrian.rolap.RolapConnection.executeInternal(RolapConnection.java:672)

2018/09/26 19:34:01 - realizar qry_gap_3.0 - ... 7 more

2018/09/26 19:34:01 - realizar qry_gap_3.0 - Finished reading query, closing connection.

2018/09/26 19:34:01 - realizar qry_gap_3.0 - Finished processing (I=0, O=0, R=0, W=0, U=0, E=1)

Outcomes