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)