AnsweredAssumed Answered

Error query MDX "Query required more than 12 iterations"

Question asked by B241N7QV on Jul 16, 2018
Latest reply on Jul 20, 2018 by Paulo Pires

I have a .ktr file with some Mondrian input steps.

When I process the job .kjb via command line, it fails and launches a "mondrian.olap.MondrianException: Mondrian Error:Internal error: Query required more than 12 iterations". But if I process the .ktr file using spoon there is no such an error.

Any help? Thanks.

 

I attach the query and the entire query:

 

WITH

SET [~TIEMPO_TIEMPO.Tiempo_Mes] AS

    {[TIEMPO.Tiempo].[${anio}].[${trim}].[${mes}]}

SET [~ROWS] AS

    {[CIAS].[CIAS].Members}

SELECT

{[Measures].[Dias Consulta], [Measures].[Cupo total], [Measures].[Presión total], [Measures].[Frecuentación]} ON COLUMNS,

NON EMPTY [~ROWS] ON ROWS

FROM [Primaria AGG_V2]

WHERE [~TIEMPO_TIEMPO.Tiempo_Mes]

 

 

2018/07/14 04:50:34 - cargar query prof2.0 - ERROR (version 6.1.0.1-196, build 1 from 2016-04-07 12.08.49 by buildguy) : Unexpected error

2018/07/14 04:50:34 - cargar query prof2.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 set [~TIEMPO_TIEMPO.Tiempo_Mes] as '{[TIEMPO.Tiempo].[2018].[2T].[6]}'

2018/07/14 04:50:34 - cargar query prof2.0 -   set [~ROWS] as '{[CIAS].[CIAS].Members}'

2018/07/14 04:50:34 - cargar query prof2.0 - select {[Measures].[Dias Consulta], [Measures].[Cupo total], [Measures].[Presión total], [Measures].[Frecuentación]} ON COLUMNS,

2018/07/14 04:50:34 - cargar query prof2.0 -   NON EMPTY [~ROWS] ON ROWS

2018/07/14 04:50:34 - cargar query prof2.0 - from [Primaria AGG_V2]

2018/07/14 04:50:34 - cargar query prof2.0 - where [~TIEMPO_TIEMPO.Tiempo_Mes]

2018/07/14 04:50:34 - cargar query prof2.0 - ]

2018/07/14 04:50:34 - cargar query prof2.0 -      at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:987)

2018/07/14 04:50:34 - cargar query prof2.0 -      at mondrian.olap.Util.newInternal(Util.java:2410)

2018/07/14 04:50:34 - cargar query prof2.0 -      at mondrian.olap.Util.newError(Util.java:2426)

2018/07/14 04:50:34 - cargar query prof2.0 -      at mondrian.rolap.RolapConnection.executeInternal(RolapConnection.java:707)

2018/07/14 04:50:34 - cargar query prof2.0 -      at mondrian.rolap.RolapConnection.access$000(RolapConnection.java:52)

2018/07/14 04:50:34 - cargar query prof2.0 -      at mondrian.rolap.RolapConnection$1.call(RolapConnection.java:623)

2018/07/14 04:50:34 - cargar query prof2.0 -      at mondrian.rolap.RolapConnection$1.call(RolapConnection.java:621)

2018/07/14 04:50:34 - cargar query prof2.0 -      at java.util.concurrent.FutureTask.run(Unknown Source)

2018/07/14 04:50:34 - cargar query prof2.0 -      at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

2018/07/14 04:50:34 - cargar query prof2.0 -      at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

2018/07/14 04:50:34 - cargar query prof2.0 -      at java.lang.Thread.run(Unknown Source)

2018/07/14 04:50:34 - cargar query prof2.0 - Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: Query required more than 12 iterations

2018/07/14 04:50:34 - cargar query prof2.0 -      at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:984)

2018/07/14 04:50:34 - cargar query prof2.0 -      at mondrian.olap.Util.newInternal(Util.java:2403)

2018/07/14 04:50:34 - cargar query prof2.0 -      at mondrian.rolap.RolapResult.executeBody(RolapResult.java:1047)

2018/07/14 04:50:34 - cargar query prof2.0 -      at mondrian.rolap.RolapResult.<init>(RolapResult.java:504)

2018/07/14 04:50:34 - cargar query prof2.0 -      at mondrian.rolap.RolapConnection.executeInternal(RolapConnection.java:672)

2018/07/14 04:50:34 - cargar query prof2.0 -      ... 7 more

2018/07/14 04:50:34 - cargar query prof2.0 - Finished reading query, closing connection.

Outcomes