Help! Error in Basic interface for ad hoc queries

134 views
Skip to first unread message

Zhiyong Cheng

unread,
May 26, 2011, 7:50:02 AM5/26/11
to PHI's Mondrian OLAP Group
Hi,

I am a newbie to Mondrian. I tried to set up Mondrian + MySQL.
I followed the instructions on websites :http://business-
intelligence.phi-integration.com/2008/04/mondrian-mysql-setup.html and
http://pentaho-en.phi-integration.com/mondrian/configuring-mondrian-sample.
It's very helpful. When I go to the Mondrian examples page, all tests
run successfully except Basic interface for ad hoc queries, I get the
list of queries and I can show all the queries, no problem. But when I
go to process the MDX query I get this error message:

mondrian.olap.MondrianException: Mondrian Error:Internal error:
Connect string '@mondrian.webapp.connectString@=; Catalog='null'' must
contain either 'Jdbc' or 'DataSource'
at mondrian.resource.MondrianResource
$_Def0.ex(MondrianResource.java:838)
at mondrian.olap.Util.newInternal(Util.java:1532)
at
mondrian.rolap.RolapConnection.createDataSource(RolapConnection.java:
412)
at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:
152)
at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:95)
at mondrian.olap.DriverManager.getConnection(DriverManager.java:
110)
at mondrian.olap.DriverManager.getConnection(DriverManager.java:
74)
at mondrian.olap.DriverManager.getConnection(DriverManager.java:
55)
at
mondrian.web.servlet.MdxQueryServlet.processRequest(MdxQueryServlet.java:
90)
at mondrian.web.servlet.MdxQueryServlet.doGet(MdxQueryServlet.java:
241)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:
290)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:
206)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:
233)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:
191)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:
127)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:
102)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:
109)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:
298)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:
859)
at org.apache.coyote.http11.Http11Protocol
$Http11ConnectionHandler.process(Http11Protocol.java:588)
at org.apache.tomcat.util.net.JIoEndpoint
$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Unknown Source)


I have already change the web.xml and mondrian.properties:
web.xml:
<context-param>
<param-name>connectString</param-name>
<param-value>Provider=mondrian;Jdbc=jdbc:mysql://localhost/
foodmart;JdbcUser=root;JdbcPassword=123456;Catalog=/WEB-INF/queries/
FoodMart.xml;JdbcDrivers=com.mysql.jdbc.Driver;</param-value>
</context-param>
.....
<servlet>
<servlet-name>MDXQueryServlet</servlet-name>
<servlet-class>mondrian.web.servlet.MdxQueryServlet</servlet-
class>
<init-param>
<param-name>connectString</param-name>
<param-value>@mondrian.webapp.connectString@</param-value>
</init-param>
</servlet>

mondrian.properties:
mondrian.webapp.connectString=Provider=mondrian;Jdbc=jdbc:mysql://
localhost/foodmart;JdbcUser=root;JdbcPassword=123456;Catalog=/WEB-INF/
queries/FoodMart.xml;JdbcDrivers=com.mysql.jdbc.Driver;


By the way, my Operating System is windows 7. Tomcat 6.0.32, Mondrian
3.2.1
Can you help me fix this problem?
Many Thanks!

Regards,
Cheng Zhiyong
Reply all
Reply to author
Forward
0 new messages