Mondrian and Sybase

[pgdar]

Hi all

I am using Mondrian for an OLAP tool for an app that I am working on. It worked fine when I configured it will Access but now I have to get it working with Sybase 11.x. I am getting the following error when I try to do this.

----------------------------------------------------------
mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [select {[Measures].[TotalLongPosition]} ON columns
from [myCube]
]
at mondrian.olap.MondrianResource.newInternal(MondrianResource.java:45)
at mondrian.olap.Util.newError(Util.java:563)
at mondrian.rolap.RolapConnection.execute(RolapConnection.java:342)
at mondrian.web.servlet.MDXQueryServlet.processRequest(MDXQueryServlet.java:76)
at mondrian.web.servlet.MDXQueryServlet.doGet(MDXQueryServlet.java:206)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:536)
Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while loading segment; sql=[select sum("ProdCPCurrAgg"."LongPosition") as "m0" from "ProdCPCurrAgg" as "ProdCPCurrAgg"]
at mondrian.olap.MondrianResource.newInternal(MondrianResource.java:45)
at mondrian.olap.Util.newInternal(Util.java:551)
at mondrian.rolap.agg.Segment.load(Segment.java:356)
at mondrian.rolap.agg.Aggregation.load(Aggregation.java:141)
at mondrian.rolap.agg.AggregationManager.loadAggregation(AggregationManager.java:62)
at mondrian.rolap.FastBatchingCellReader$Batch.loadAggregation(FastBatchingCellReader.java:192)
at mondrian.rolap.FastBatchingCellReader.loadAggregations(FastBatchingCellReader.java:100)
at mondrian.rolap.RolapResult.executeBody(RolapResult.java:224)
at mondrian.rolap.RolapResult.<init>(RolapResult.java:143)
at mondrian.rolap.RolapConnection.execute(RolapConnection.java:326)
... 18 more
Caused by: com.sybase.jdbc2.jdbc.SybSQLException: Incorrect syntax near the keyword 'as'.

---------------------------------------------------------

Anyone has any idea what could be going wrong. I would really appreciate any suggestions.

- PGD

 

[justins57]

Is there more to the MDX than the simple select query at the top of the exception?