mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [select NON EMPTY Crossjoin([Promotions].Members, [Gender].Members) ON COLUMNS from [VirtualSalesTest] ]

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via Pentaho BI Platform Tracking by Martijn van den Broek, 1 year ago
Mondrian Error:Internal error: Error while executing query [select NON EMPTY Crossjoin([Promotions].Members, [Gender].Members) ON COLUMNS from [VirtualSalesTest] ]
via Pentaho BI Platform Tracking by Martijn van den Broek, 1 year ago
Mondrian Error:Internal error: Error while executing query [select NON EMPTY Crossjoin([Promotions].Members, [Gender].Members) ON COLUMNS from [VirtualSalesTest] ]
via Pentaho BI Platform Tracking by Matt Campbell, 1 year ago
Mondrian Error:Internal error: Error while executing query [select [Store].[Store].[Store Name].Members ON COLUMNS from [Sales] ]
via Pentaho BI Platform Tracking by Matt Campbell, 1 year ago
Mondrian Error:Internal error: Error while executing query [select [Store].[Store].[Store Name].Members ON COLUMNS from [Sales] ]
via GitHub by maximecaron
, 2 years ago
Mondrian Error:Internal error: Error while executing query [with set [dateRange] as '{([Time].[Date].[2012].[August].[2012-08-29] : [Time].[Date].[2012].[September].[2012-09-05])}' set [Time-Date] as '[dateRange]' member [Time].[Date].[Time-Date
via Pentaho BI Platform Tracking by Maxime Caron, 8 months ago
Mondrian Error:Internal error: Error while executing query [with set [dateRange] as '{([Time].[Date].[2012].[August].[2012-08-29] : [Time].[Date].[2012].[September].[2012-09-05])}' set [Time-Date] as '[dateRange]' member [Time].[Date].[Time-Date
mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [select NON EMPTY Crossjoin([Promotions].Members, [Gender].Members) ON COLUMNS from [VirtualSalesTest] ]
at mondrian.rolap.SqlConstraintUtils.joinLevelTableToFactTable(SqlConstraintUtils.java:684)
at mondrian.rolap.SqlConstraintUtils.addRoleAccessConstraints(SqlConstraintUtils.java:299)
at mondrian.rolap.SqlConstraintUtils.addContextConstraint(SqlConstraintUtils.java:215)
at mondrian.rolap.SqlContextConstraint.addConstraint(SqlContextConstraint.java:308)
at mondrian.rolap.SqlTupleReader.generateSelectForLevels(SqlTupleReader.java:923)
at mondrian.rolap.SqlTupleReader.makeLevelMembersSql(SqlTupleReader.java:784)
at mondrian.rolap.SqlTupleReader.prepareTuples(SqlTupleReader.java:390)
at mondrian.rolap.SqlTupleReader.readMembers(SqlTupleReader.java:506)
at mondrian.rolap.SqlMemberSource.getMembersInLevel(SqlMemberSource.java:508)
at mondrian.rolap.SmartMemberReader.getMembersInLevel(SmartMemberReader.java:146)
at mondrian.rolap.RolapCubeHierarchy$CacheRolapCubeHierarchyMemberReader.getMembersInLevel(RolapCubeHierarchy.java:727)
at mondrian.rolap.RestrictedMemberReader.getMembersInLevel(RestrictedMemberReader.java:241)
at mondrian.rolap.SubstitutingMemberReader.getMembersInLevel(SubstitutingMemberReader.java:185)
at mondrian.rolap.RolapSchemaReader.getLevelMembers(RolapSchemaReader.java:547)
at mondrian.olap.DelegatingSchemaReader.getLevelMembers(DelegatingSchemaReader.java:242)
at mondrian.olap.fun.FunUtil.getNonEmptyLevelMembers(FunUtil.java:2195)
at mondrian.olap.fun.FunUtil.hierarchyMembers(FunUtil.java:2231)
at mondrian.olap.fun.BuiltinFunTable$27$1.evaluateList(BuiltinFunTable.java:957)
at mondrian.calc.impl.AbstractListCalc.evaluateIterable(AbstractListCalc.java:71)
at mondrian.olap.fun.CrossJoinFunDef$CrossJoinIterCalc.evaluateIterable(CrossJoinFunDef.java:185)
at mondrian.rolap.RolapResult.executeAxis(RolapResult.java:875)
at mondrian.rolap.RolapResult.evalLoad(RolapResult.java:700)
at mondrian.rolap.RolapResult.loadMembers(RolapResult.java:656)
at mondrian.rolap.RolapResult.(RolapResult.java:288)
at mondrian.rolap.RolapConnection.executeInternal(RolapConnection.java:671)
at mondrian.rolap.RolapConnection.access$000(RolapConnection.java:51)
at mondrian.rolap.RolapConnection$1.call(RolapConnection.java:622)
at mondrian.rolap.RolapConnection$1.call(RolapConnection.java:620)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
at java.util.concurrent.FutureTask.run(FutureTask.java:166)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
at java.lang.Thread.run(Thread.java:722)

Users with the same issue

You are the first who have seen this exception. Write a tip to help other users and build your expert profile.

Know the solutions? Share your knowledge to help other developers to debug faster.