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

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

    Automated exception search integrated into your IDE

  5. 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
  6. 0

    Servlet using Datanucleus JDO can't find MySQL Driver

    Stack Overflow | 5 years ago | Kenny
    java.sql.SQLException: No suitable driver found for jdbc:mysql://192.168.2.203:3306/jdo
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