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.
#Pentaho