mondrian+Jpviot页面报错

页面提示错误如下：

后台错误日志：

[JPivot] 21 十月 2015 14:53:01,420 ERROR [Session ] mondrian.xmla.XmlaServlet#doPost: Errors when handling XML/A messagemondrian.xmla.XmlaException: Mondrian Error:XMLA Discover unparse results errorat mondrian.xmla.XmlaHandler.discover(XmlaHandler.java:2737)at mondrian.xmla.XmlaHandler.process(XmlaHandler.java:549)at mondrian.xmla.impl.DefaultXmlaServlet.handleSoapBody(DefaultXmlaServlet.java:411)at mondrian.xmla.XmlaServlet.doPost(XmlaServlet.java:311)at javax.servlet.http.HttpServlet.service(HttpServlet.java:643)at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)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:103)at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:879)at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:617)at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1778)at java.lang.Thread.run(Thread.java:619)<span style="font-size:18px;color:#ff0000;">Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while creating SQL connection: Jdbc=jdbc:oracle:thin:@localhost:1521:orcl; JdbcUser=cdrdw; JdbcPassword=cdrdw</span>at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:816)at mondrian.olap.Util.newInternal(Util.java:1492)at mondrian.olap.Util.newError(Util.java:1508)at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:230)at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:174)at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:218)at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:53)at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:958)at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:755)at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:163)at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:92)at mondrian.olap.DriverManager.getConnection(DriverManager.java:110)at mondrian.olap.DriverManager.getConnection(DriverManager.java:74)at mondrian.xmla.XmlaHandler.getConnection(XmlaHandler.java:2831)at mondrian.xmla.RowsetDefinition$MdschemaDimensionsRowset.populate(RowsetDefinition.java:3962)at mondrian.xmla.Rowset.unparse(Rowset.java:161)at mondrian.xmla.XmlaHandler.discover(XmlaHandler.java:2732)... 17 moreCaused by: java.sql.SQLException: Listener refused the connection with the following error:ORA-12505, TNS:listener does not currently know of SID given in connect descriptorThe Connection descriptor used by the client was:localhost:1521:orclat oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:261)at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:387)at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:439)at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)at java.sql.DriverManager.getConnection(DriverManager.java:582)at java.sql.DriverManager.getConnection(DriverManager.java:154)at org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:51)at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290)at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:771)at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:95)at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:210)... 30 more[JPivot] 21 十月 2015 14:53:01,461 ERROR [Session 378B41D7866A8E10B4724678EFE40B6F] com.tonbeller.jpivot.tags.OlapModelProxy$MyState#initialize: com.tonbeller.jpivot.olap.model.OlapException: Soap Fault code=SOAP-ENV:Server.00HSBE02 fault string=XMLA Discover unparse results error fault actor=Mondriandetail:

原因是数据源连接不正确。检查mondrian的datasource.xml文件的xmla数据源配置。