mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while creating SQL connection: Jdbc=jdbc:optiq:model=file:/home/cloudera/Sistemas/optiq/mongodb/target/test-classes/mongo-zips-model-juanrh.json; JdbcUser=admin; JdbcPassword=admin

Google Groups | Juan Rodríguez Hortalá | 3 years ago
  1. 0

    Problem connecting optiq-mongo to Saiku

    Google Groups | 3 years ago | Juan Rodríguez Hortalá
    mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while creating SQL connection: Jdbc=jdbc:optiq:model=file:/home/cloudera/Sistemas/optiq/mongodb/target/test-classes/mongo-zips-model-juanrh.json; JdbcUser=admin; JdbcPassword=admin
  2. 0

    saiku mongo connection using optiq

    Google Groups | 3 years ago | Yogesh Jagtap
    mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while creating SQL connection: Jdbc=jdbc:optiq:model=file:/home/yogesh/optiq/mongodb/target/test-classes/mongo-zips-model.json
  3. 0

    mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while creating SQL connection: Jdbc=null at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:811) at mondrian.olap.Util.newInternal(Util.java:1472) at mondrian.olap.Util.newError(Util.java:1488) at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:241) at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:189) at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:231) at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:72) at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:953) at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:755) at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:176) at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:106) 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 org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.AbstractMDXDataFactory.open(AbstractMDXDataFactory.java:171) at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.open(CompoundDataFactory.java:143) at org.pentaho.reporting.engine.classic.core.states.CachingDataFactory.open(CachingDataFactory.java:113) at org.pentaho.reporting.engine.classic.core.modules.gui.base.ParameterReportControllerPane$InternalParameterContext.open(ParameterReportControllerPane.java:131) at org.pentaho.reporting.engine.classic.core.modules.gui.base.ParameterReportControllerPane$InternalParameterContext.update(ParameterReportControllerPane.java:188) at org.pentaho.reporting.engine.classic.core.modules.gui.base.ParameterReportControllerPane.reinit(ParameterReportControllerPane.java:343) at org.pentaho.reporting.engine.classic.core.modules.gui.base.ParameterReportControllerPane.setReport(ParameterReportControllerPane.java:288) at org.pentaho.reporting.engine.classic.core.modules.gui.base.ParameterReportController$ReportUpdateHandler.propertyChange(ParameterReportController.java:103) at java.beans.PropertyChangeSupport.firePropertyChange(Unknown Source) at java.beans.PropertyChangeSupport.firePropertyChange(Unknown Source) at java.beans.PropertyChangeSupport.firePropertyChange(Unknown Source) at java.awt.Component.firePropertyChange(Unknown Source) at org.pentaho.reporting.engine.classic.core.modules.gui.base.PreviewPane.setReportJob(PreviewPane.java:1030) at org.pentaho.reporting.designer.core.editor.preview.ReportPreviewComponent.updatePreview(ReportPreviewComponent.java:237) at org.pentaho.reporting.designer.core.editor.ReportRendererComponent.showPreview(ReportRendererComponent.java:462) at org.pentaho.reporting.designer.core.ReportDesignerFrame$FrameViewController.setPreviewVisible(ReportDesignerFrame.java:755) at org.pentaho.reporting.designer.core.actions.global.ShowPreviewPaneAction.actionPerformed(ShowPreviewPaneAction.java:68) at javax.swing.AbstractButton.fireActionPerformed(Unknown Source) at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source) at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source) at javax.swing.DefaultButtonModel.setPressed(Unknown Source) at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source) at java.awt.AWTEventMulticaster.mouseReleased(Unknown Source) at java.awt.Component.processMouseEvent(Unknown Source) at javax.swing.JComponent.processMouseEvent(Unknown Source) at java.awt.Component.processEvent(Unknown Source) at java.awt.Container.processEvent(Unknown Source) at java.awt.Component.dispatchEventImpl(Unknown Source) at java.awt.Container.dispatchEventImpl(Unknown Source) at java.awt.Component.dispatchEvent(Unknown Source) at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source) at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source) at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source) at java.awt.Container.dispatchEventImpl(Unknown Source) at java.awt.Window.dispatchEventImpl(Unknown Source) at java.awt.Component.dispatchEvent(Unknown Source) at java.awt.EventQueue.dispatchEvent(Unknown Source) at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.run(Unknown Source) Caused by: java.sql.SQLException: No suitable driver found for null at java.sql.DriverManager.getConnection(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) 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:840) at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:95) at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:222) ... 53 more Paths to repro: 1. Open RD 2.From the welcome screen open the legacy folder 3. Pick the MainVendorReport.report 4. In order to run this you need to establish the connections one more time. 5. Try to make a JNDI connection to hypersonic called sample data(make sure in your .pentaho folder u have the JNDI.properties) 6.. All the JDBC connections are made by reconnecting using the JNDI connection. 7.Reconnect the Mondrian connection and click ok. 8. Notice the error message.

    Pentaho BI Platform Tracking | 7 years ago | Golda David
    mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while creating SQL connection: Jdbc=null
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while creating SQL connection: Jdbc=null at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:811) at mondrian.olap.Util.newInternal(Util.java:1472) at mondrian.olap.Util.newError(Util.java:1488) at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:241) at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:189) at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:231) at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:72) at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:953) at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:755) at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:176) at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:106) 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 org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.AbstractMDXDataFactory.open(AbstractMDXDataFactory.java:171) at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.open(CompoundDataFactory.java:143) at org.pentaho.reporting.engine.classic.core.states.CachingDataFactory.open(CachingDataFactory.java:113) at org.pentaho.reporting.engine.classic.core.modules.gui.base.ParameterReportControllerPane$InternalParameterContext.open(ParameterReportControllerPane.java:131) at org.pentaho.reporting.engine.classic.core.modules.gui.base.ParameterReportControllerPane$InternalParameterContext.update(ParameterReportControllerPane.java:188) at org.pentaho.reporting.engine.classic.core.modules.gui.base.ParameterReportControllerPane.reinit(ParameterReportControllerPane.java:343) at org.pentaho.reporting.engine.classic.core.modules.gui.base.ParameterReportControllerPane.setReport(ParameterReportControllerPane.java:288) at org.pentaho.reporting.engine.classic.core.modules.gui.base.ParameterReportController$ReportUpdateHandler.propertyChange(ParameterReportController.java:103) at java.beans.PropertyChangeSupport.firePropertyChange(Unknown Source) at java.beans.PropertyChangeSupport.firePropertyChange(Unknown Source) at java.beans.PropertyChangeSupport.firePropertyChange(Unknown Source) at java.awt.Component.firePropertyChange(Unknown Source) at org.pentaho.reporting.engine.classic.core.modules.gui.base.PreviewPane.setReportJob(PreviewPane.java:1030) at org.pentaho.reporting.designer.core.editor.preview.ReportPreviewComponent.updatePreview(ReportPreviewComponent.java:237) at org.pentaho.reporting.designer.core.editor.ReportRendererComponent.showPreview(ReportRendererComponent.java:462) at org.pentaho.reporting.designer.core.ReportDesignerFrame$FrameViewController.setPreviewVisible(ReportDesignerFrame.java:755) at org.pentaho.reporting.designer.core.actions.global.ShowPreviewPaneAction.actionPerformed(ShowPreviewPaneAction.java:68) at javax.swing.AbstractButton.fireActionPerformed(Unknown Source) at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source) at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source) at javax.swing.DefaultButtonModel.setPressed(Unknown Source) at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source) at java.awt.AWTEventMulticaster.mouseReleased(Unknown Source) at java.awt.Component.processMouseEvent(Unknown Source) at javax.swing.JComponent.processMouseEvent(Unknown Source) at java.awt.Component.processEvent(Unknown Source) at java.awt.Container.processEvent(Unknown Source) at java.awt.Component.dispatchEventImpl(Unknown Source) at java.awt.Container.dispatchEventImpl(Unknown Source) at java.awt.Component.dispatchEvent(Unknown Source) at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source) at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source) at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source) at java.awt.Container.dispatchEventImpl(Unknown Source) at java.awt.Window.dispatchEventImpl(Unknown Source) at java.awt.Component.dispatchEvent(Unknown Source) at java.awt.EventQueue.dispatchEvent(Unknown Source) at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.run(Unknown Source) Caused by: java.sql.SQLException: No suitable driver found for null at java.sql.DriverManager.getConnection(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) 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:840) at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:95) at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:222) ... 53 more Paths to repro: 1. Open RD 2.From the welcome screen open the legacy folder 3. Pick the MainVendorReport.report 4. In order to run this you need to establish the connections one more time. 5. Try to make a JNDI connection to hypersonic called sample data(make sure in your .pentaho folder u have the JNDI.properties) 6.. All the JDBC connections are made by reconnecting using the JNDI connection. 7.Reconnect the Mondrian connection and click ok. 8. Notice the error message.

    Pentaho BI Platform Tracking | 7 years ago | Golda David
    mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while creating SQL connection: Jdbc=null
  6. 0

    Error when trying pio train

    Google Groups | 12 months ago | Kim Trang Le
    java.sql.SQLException: No suitable driver found for jdbc:mysql://192.168.1.73/pio

  1. jshakil 1 times, last 1 month ago
  2. linxiaolong 7101 times, last 3 weeks ago
  3. ruifung 1 times, last 3 months ago
  4. linxiaolong 838 times, last 3 months ago
  5. Juraji 1 times, last 8 months ago
49 unregistered visitors
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. java.sql.SQLException

    No suitable driver found for jdbc:optiq:model=file:/home/cloudera/Sistemas/optiq/mongodb/target/test-classes/mongo-zips-model-juanrh.json

    at java.sql.DriverManager.getConnection()
  2. Java RT
    DriverManager.getConnection
    1. java.sql.DriverManager.getConnection(DriverManager.java:602)
    2. java.sql.DriverManager.getConnection(DriverManager.java:154)
    2 frames
  3. Commons DBCP
    PoolableConnectionFactory.makeObject
    1. org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:68)
    2. org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:294)
    2 frames
  4. Commons Pool
    GenericObjectPool.borrowObject
    1. org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:974)
    1 frame
  5. Commons DBCP
    PoolingDataSource.getConnection
    1. org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:96)
    1 frame
  6. mondrian.rolap
    RolapConnection.<init>
    1. mondrian.rolap.RolapConnection.<init>(RolapConnection.java:226)
    2. mondrian.rolap.RolapSchema.<init>(RolapSchema.java:187)
    3. mondrian.rolap.RolapSchema.<init>(RolapSchema.java:215)
    4. mondrian.rolap.RolapSchemaPool.get(RolapSchemaPool.java:214)
    5. mondrian.rolap.RolapSchemaPool.get(RolapSchemaPool.java:66)
    6. mondrian.rolap.RolapConnection.<init>(RolapConnection.java:160)
    7. mondrian.rolap.RolapConnection.<init>(RolapConnection.java:90)
    7 frames
  7. mondrian.olap
    DriverManager.getConnection
    1. mondrian.olap.DriverManager.getConnection(DriverManager.java:112)
    2. mondrian.olap.DriverManager.getConnection(DriverManager.java:68)
    2 frames
  8. mondrian.olap4j
    MondrianOlap4jDriver.connect
    1. mondrian.olap4j.MondrianOlap4jConnection.<init>(MondrianOlap4jConnection.java:140)
    2. mondrian.olap4j.FactoryJdbc4Plus$AbstractConnection.<init>(FactoryJdbc4Plus.java:323)
    3. mondrian.olap4j.FactoryJdbc4Impl$MondrianOlap4jConnectionJdbc4.<init>(FactoryJdbc4Impl.java:104)
    4. mondrian.olap4j.FactoryJdbc4Impl.newConnection(FactoryJdbc4Impl.java:32)
    5. mondrian.olap4j.MondrianOlap4jDriver.connect(MondrianOlap4jDriver.java:132)
    5 frames
  9. Java RT
    DriverManager.getConnection
    1. java.sql.DriverManager.getConnection(DriverManager.java:582)
    2. java.sql.DriverManager.getConnection(DriverManager.java:185)
    2 frames
  10. org.saiku.datasources
    SaikuConnectionFactory.getConnection
    1. org.saiku.datasources.connection.SaikuOlapConnection.connect(SaikuOlapConnection.java:75)
    2. org.saiku.datasources.connection.SaikuOlapConnection.connect(SaikuOlapConnection.java:46)
    3. org.saiku.datasources.connection.SaikuConnectionFactory.getConnection(SaikuConnectionFactory.java:29)
    3 frames
  11. org.saiku.web
    SecurityAwareConnectionManager.getInternalConnection
    1. org.saiku.web.impl.SecurityAwareConnectionManager.connect(SecurityAwareConnectionManager.java:265)
    2. org.saiku.web.impl.SecurityAwareConnectionManager.getInternalConnection(SecurityAwareConnectionManager.java:80)
    2 frames
  12. org.saiku.datasources
    AbstractConnectionManager.getAllConnections
    1. org.saiku.datasources.connection.AbstractConnectionManager.getConnection(AbstractConnectionManager.java:93)
    2. org.saiku.datasources.connection.AbstractConnectionManager.getAllConnections(AbstractConnectionManager.java:119)
    2 frames
  13. org.saiku.web
    SecurityAwareConnectionManager.init
    1. org.saiku.web.impl.SecurityAwareConnectionManager.init(SecurityAwareConnectionManager.java:57)
    1 frame
  14. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    4. java.lang.reflect.Method.invoke(Method.java:597)
    4 frames
  15. Spring Beans
    DefaultListableBeanFactory.preInstantiateSingletons
    1. org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1536)
    2. org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1477)
    3. org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1409)
    4. org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519)
    5. org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
    6. org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:291)
    7. org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
    8. org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:288)
    9. org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:190)
    10. org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:574)
    10 frames
  16. Spring Context
    AbstractApplicationContext.refresh
    1. org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:895)
    2. org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:425)
    2 frames
  17. Spring
    ContextLoaderListener.contextInitialized
    1. org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:276)
    2. org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:197)
    3. org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:47)
    3 frames
  18. Glassfish Core
    Catalina.start
    1. org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3972)
    2. org.apache.catalina.core.StandardContext.start(StandardContext.java:4467)
    3. org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
    4. org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
    5. org.apache.catalina.core.StandardHost.addChild(StandardHost.java:526)
    6. org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1041)
    7. org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:964)
    8. org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:502)
    9. org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277)
    10. org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:321)
    11. org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
    12. org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
    13. org.apache.catalina.core.StandardHost.start(StandardHost.java:722)
    14. org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
    15. org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
    16. org.apache.catalina.core.StandardService.start(StandardService.java:516)
    17. org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
    18. org.apache.catalina.startup.Catalina.start(Catalina.java:593)
    18 frames
  19. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    4. java.lang.reflect.Method.invoke(Method.java:597)
    4 frames
  20. Glassfish Core
    Bootstrap.main
    1. org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
    2. org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
    2 frames