Re: [Olap4j-devel] mdx validator error

[Julian H. <jh...@pe...>]

Looks like the name column of your level is an integer column. It needs to be a string (char or varchar). (We may loosen the rules in mondrian 4).

Julian


On Feb 1, 2013, at 11:21 AM, Borja Espejo García <bor...@gm...<mailto:bor...@gm...>> wrote:

If I only query with:

{[Time]} ON COLUMNS,
{[Location].[k]} ON ROWS
FROM [SunRadiationCube]
WHERE [Measures].[totalSunRadiation]'

I don't have any problems with the validation… (I haven't written the year)
……….
so, this is the error stack trace…. thank for your time!

org.olap4j.OlapException: Validation error
at mondrian.olap4j.MondrianOlap4jConnection$Helper.createException(MondrianOlap4jConnection.java:777)
at mondrian.olap4j.MondrianOlap4jConnection$MondrianOlap4jMdxValidator.validateSelect(MondrianOlap4jConnection.java:824)
at iaaa.olap.olap4j.AppTest.mdxValidator1(AppTest.java:94)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:45)
at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:15)
at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:42)
at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:20)
at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:28)
at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:30)
at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:263)
at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:68)
at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:47)
at org.junit.runners.ParentRunner$3.run(ParentRunner.java:231)
at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:60)
at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:229)
at org.junit.runners.ParentRunner.access$000(ParentRunner.java:50)
at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:222)
at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:28)
at org.junit.runners.ParentRunner.run(ParentRunner.java:300)
at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:50)
at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:467)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:683)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:390)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:197)
Caused by: mondrian.olap.MondrianException: Mondrian Error:Failed to parse query 'SELECT
{[Time].[2011]} ON COLUMNS,
{[Location].[k]} ON ROWS
FROM [SunRadiationCube]
WHERE [Measures].[totalSunRadiation]'
at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:912)
at mondrian.olap.ConnectionBase.parseStatement(ConnectionBase.java:144)
at mondrian.olap.ConnectionBase.parseStatement(ConnectionBase.java:71)
at mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:90)
at mondrian.olap4j.MondrianOlap4jConnection$MondrianOlap4jMdxValidator.validateSelect(MondrianOlap4jConnection.java:818)
... 27 more
Caused by: java.lang.reflect.UndeclaredThrowableException
at $Proxy10.lookupCompound(Unknown Source)
at mondrian.olap.Util.lookup(Util.java:954)
at mondrian.olap.Id.accept(Id.java:107)
at mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:80)
at mondrian.olap.fun.FunUtil.resolveFunArgs(FunUtil.java:1980)
at mondrian.mdx.UnresolvedFunCall.accept(UnresolvedFunCall.java:103)
at mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:80)
at mondrian.olap.QueryAxis.resolve(QueryAxis.java:217)
at mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:141)
at mondrian.olap.Query.resolve(Query.java:561)
at mondrian.olap.Query.resolve(Query.java:446)
at mondrian.olap.Query.<init>(Query.java:204)
at mondrian.olap.Query.<init>(Query.java:165)
at mondrian.olap.Parser$FactoryImpl.makeQuery(Parser.java:927)
at mondrian.parser.MdxParserImpl.selectStatement(MdxParserImpl.java:1185)
at mondrian.parser.MdxParserImpl.statement(MdxParserImpl.java:1017)
at mondrian.parser.MdxParserImpl.statementEof(MdxParserImpl.java:186)
at mondrian.parser.JavaccParserValidatorImpl.parseInternal(JavaccParserValidatorImpl.java:58)
at mondrian.olap.ConnectionBase.parseStatement(ConnectionBase.java:140)
... 30 more
Caused by: java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at mondrian.rolap.RolapUtil$1.invoke(RolapUtil.java:99)
... 49 more
Caused by: java.lang.ClassCastException: java.lang.Integer cannot be cast to java.lang.String
at mondrian.rolap.RolapMemberBase.getName(RolapMemberBase.java:259)
at mondrian.rolap.DelegatingRolapMember.getName(DelegatingRolapMember.java:155)
at mondrian.olap.Util.lookupHierarchyRootMember(Util.java:1125)
at mondrian.olap.HierarchyBase.lookupChild(HierarchyBase.java:166)
at mondrian.olap.DimensionBase.lookupChild(DimensionBase.java:109)
at mondrian.rolap.RolapSchemaReader.getElementChild(RolapSchemaReader.java:365)
at mondrian.olap.Util.lookupCompound(Util.java:771)
at mondrian.rolap.RolapSchemaReader.lookupCompoundInternal(RolapSchemaReader.java:427)
at mondrian.rolap.RolapSchemaReader.lookupCompound(RolapSchemaReader.java:412)
at mondrian.olap.DelegatingSchemaReader.lookupCompoundInternal(DelegatingSchemaReader.java:153)
at mondrian.olap.Query$QuerySchemaReader.lookupCompoundInternal(Query.java:1652)
at mondrian.olap.DelegatingSchemaReader.lookupCompound(DelegatingSchemaReader.java:137)
at mondrian.olap.Query$QuerySchemaReader.lookupCompoundInternal(Query.java:1623)
at mondrian.olap.DelegatingSchemaReader.lookupCompound(DelegatingSchemaReader.java:137)
at mondrian.olap.DelegatingSchemaReader.lookupCompoundInternal(DelegatingSchemaReader.java:153)
at mondrian.olap.Query$ScopedSchemaReader.lookupCompoundInternal(Query.java:1865)
at mondrian.olap.DelegatingSchemaReader.lookupCompound(DelegatingSchemaReader.java:137)
at mondrian.olap.DelegatingSchemaReader.lookupCompound(DelegatingSchemaReader.java:117)
... 54 more


------------------------------------------------------------------------------
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_jan_______________________________________________
olap4j-devel mailing list
ola...@li...
https://lists.sourceforge.net/lists/listinfo/olap4j-devel