mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while creating SQL connection: Jdbc=null

Pentaho BI Platform Tracking | Golda David | 7 years ago
  1. 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
  2. 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
  3. 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
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 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
  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 4 weeks ago
  3. ruifung 1 times, last 3 months ago
  4. linxiaolong 838 times, last 3 months ago
  5. Juraji 1 times, last 9 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 null

    at java.sql.DriverManager.getConnection()
  2. Java RT
    DriverManager.getConnection
    1. java.sql.DriverManager.getConnection(Unknown Source)
    2. java.sql.DriverManager.getConnection(Unknown Source)
    2 frames
  3. Commons DBCP
    PoolableConnectionFactory.makeObject
    1. org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:51)
    2. org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290)
    2 frames
  4. Commons Pool
    GenericObjectPool.borrowObject
    1. org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:840)
    1 frame
  5. Commons DBCP
    PoolingDataSource.getConnection
    1. org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:95)
    1 frame
  6. mondrian.rolap
    RolapConnection.<init>
    1. mondrian.rolap.RolapConnection.<init>(RolapConnection.java:222)
    2. mondrian.rolap.RolapSchema.<init>(RolapSchema.java:189)
    3. mondrian.rolap.RolapSchema.<init>(RolapSchema.java:231)
    4. mondrian.rolap.RolapSchema.<init>(RolapSchema.java:72)
    5. mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:953)
    6. mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:755)
    7. mondrian.rolap.RolapConnection.<init>(RolapConnection.java:176)
    8. mondrian.rolap.RolapConnection.<init>(RolapConnection.java:106)
    8 frames
  7. mondrian.olap
    DriverManager.getConnection
    1. mondrian.olap.DriverManager.getConnection(DriverManager.java:110)
    2. mondrian.olap.DriverManager.getConnection(DriverManager.java:74)
    3. mondrian.olap.DriverManager.getConnection(DriverManager.java:55)
    3 frames
  8. org.pentaho.reporting
    ParameterReportController$ReportUpdateHandler.propertyChange
    1. org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.AbstractMDXDataFactory.open(AbstractMDXDataFactory.java:171)
    2. org.pentaho.reporting.engine.classic.core.CompoundDataFactory.open(CompoundDataFactory.java:143)
    3. org.pentaho.reporting.engine.classic.core.states.CachingDataFactory.open(CachingDataFactory.java:113)
    4. org.pentaho.reporting.engine.classic.core.modules.gui.base.ParameterReportControllerPane$InternalParameterContext.open(ParameterReportControllerPane.java:131)
    5. org.pentaho.reporting.engine.classic.core.modules.gui.base.ParameterReportControllerPane$InternalParameterContext.update(ParameterReportControllerPane.java:188)
    6. org.pentaho.reporting.engine.classic.core.modules.gui.base.ParameterReportControllerPane.reinit(ParameterReportControllerPane.java:343)
    7. org.pentaho.reporting.engine.classic.core.modules.gui.base.ParameterReportControllerPane.setReport(ParameterReportControllerPane.java:288)
    8. org.pentaho.reporting.engine.classic.core.modules.gui.base.ParameterReportController$ReportUpdateHandler.propertyChange(ParameterReportController.java:103)
    8 frames
  9. Java RT
    Component.firePropertyChange
    1. java.beans.PropertyChangeSupport.firePropertyChange(Unknown Source)
    2. java.beans.PropertyChangeSupport.firePropertyChange(Unknown Source)
    3. java.beans.PropertyChangeSupport.firePropertyChange(Unknown Source)
    4. java.awt.Component.firePropertyChange(Unknown Source)
    4 frames
  10. org.pentaho.reporting
    ShowPreviewPaneAction.actionPerformed
    1. org.pentaho.reporting.engine.classic.core.modules.gui.base.PreviewPane.setReportJob(PreviewPane.java:1030)
    2. org.pentaho.reporting.designer.core.editor.preview.ReportPreviewComponent.updatePreview(ReportPreviewComponent.java:237)
    3. org.pentaho.reporting.designer.core.editor.ReportRendererComponent.showPreview(ReportRendererComponent.java:462)
    4. org.pentaho.reporting.designer.core.ReportDesignerFrame$FrameViewController.setPreviewVisible(ReportDesignerFrame.java:755)
    5. org.pentaho.reporting.designer.core.actions.global.ShowPreviewPaneAction.actionPerformed(ShowPreviewPaneAction.java:68)
    5 frames
  11. Java RT
    EventDispatchThread.run
    1. javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
    2. javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
    3. javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
    4. javax.swing.DefaultButtonModel.setPressed(Unknown Source)
    5. javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
    6. java.awt.AWTEventMulticaster.mouseReleased(Unknown Source)
    7. java.awt.Component.processMouseEvent(Unknown Source)
    8. javax.swing.JComponent.processMouseEvent(Unknown Source)
    9. java.awt.Component.processEvent(Unknown Source)
    10. java.awt.Container.processEvent(Unknown Source)
    11. java.awt.Component.dispatchEventImpl(Unknown Source)
    12. java.awt.Container.dispatchEventImpl(Unknown Source)
    13. java.awt.Component.dispatchEvent(Unknown Source)
    14. java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
    15. java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
    16. java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
    17. java.awt.Container.dispatchEventImpl(Unknown Source)
    18. java.awt.Window.dispatchEventImpl(Unknown Source)
    19. java.awt.Component.dispatchEvent(Unknown Source)
    20. java.awt.EventQueue.dispatchEvent(Unknown Source)
    21. java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
    22. java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
    23. java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
    24. java.awt.EventDispatchThread.pumpEvents(Unknown Source)
    25. java.awt.EventDispatchThread.pumpEvents(Unknown Source)
    26. java.awt.EventDispatchThread.run(Unknown Source)
    26 frames