java.lang.NullPointerException

Pentaho BI Platform Tracking | Golda David | 7 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    1.Create a new transformation. 2.Add a new database connection to your local database. 3.Click the Design tab, and open the Lookup folder, Drag the Database lookup step and double click on it. 4.In the Database Value Lookup dialog, select an existing connection for Connection 5.Click on the Browse button to browse for a Lookup table. 6.Though the Database explorer dialog comes up, in the spoon console you get NPE. DEBUG 30-07 09:21:58,266 - org.pentaho.di.trans.steps.databaselookup.DatabaseLookupMeta@b536e6 - Looking at connection: conn2 INFO 30-07 09:21:58,315 - conn2 - New database connection defined INFO 30-07 09:21:58,318 - conn2 - Connected to database. INFO 30-07 09:21:58,367 - java.lang.NullPointerException java.lang.NullPointerException at org.pentaho.di.core.database.Database.getViews(Database.java:3971) at org.pentaho.di.core.database.Database.getViews(Database.java:3956) at org.pentaho.di.core.database.Database.getViews(Database.java:3952) at org.pentaho.di.ui.core.database.dialog.XulDatabaseExplorerController.createDatabaseNodes(XulDatabaseExplorerC ontroller.java:452) at org.pentaho.di.ui.core.database.dialog.XulDatabaseExplorerController.init(XulDatabaseExplorerController.java: 124) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:325) at org.pentaho.ui.xul.impl.AbstractXulDomContainer.initialize(AbstractXulDomContainer.java:153) at org.pentaho.ui.xul.swt.SwtXulRunner$1.run(SwtXulRunner.java:54) at org.eclipse.swt.widgets.Synchronizer.syncExec(Unknown Source) at org.eclipse.swt.widgets.Display.syncExec(Unknown Source) at org.pentaho.ui.xul.swt.SwtXulRunner.initialize(SwtXulRunner.java:51) at org.pentaho.di.ui.core.database.dialog.XulDatabaseExplorerDialog.open(XulDatabaseExplorerDialog.java:87) at org.pentaho.di.ui.trans.steps.databaselookup.DatabaseLookupDialog.getTableName(DatabaseLookupDialog.java:767) at org.pentaho.di.ui.trans.steps.databaselookup.DatabaseLookupDialog.access$800(DatabaseLookupDialog.java:68) at org.pentaho.di.ui.trans.steps.databaselookup.DatabaseLookupDialog$16.widgetSelected(DatabaseLookupDialog.java :532) at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source) at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source) at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source) at org.pentaho.di.ui.trans.steps.databaselookup.DatabaseLookupDialog.open(DatabaseLookupDialog.java:548) at org.pentaho.di.ui.spoon.delegates.SpoonStepsDelegate.editStep(SpoonStepsDelegate.java:126) at org.pentaho.di.ui.spoon.Spoon.editStep(Spoon.java:7389) at org.pentaho.di.ui.spoon.trans.TransGraph.editStep(TransGraph.java:2610) at org.pentaho.di.ui.spoon.trans.TransGraph.mouseDoubleClick(TransGraph.java:691) at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source) at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source) at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source) at org.pentaho.di.ui.spoon.Spoon.readAndDispatch(Spoon.java:1147) at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:6627) at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:544) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.pentaho.commons.launcher.Launcher.main(Launcher.java:110)

    Pentaho BI Platform Tracking | 7 years ago | Golda David
    java.lang.NullPointerException
  2. 0

    1.Create a new transformation. 2.Add a new database connection to your local database. 3.Click the Design tab, and open the Lookup folder, Drag the Database lookup step and double click on it. 4.In the Database Value Lookup dialog, select an existing connection for Connection 5.Click on the Browse button to browse for a Lookup table. 6.Though the Database explorer dialog comes up, in the spoon console you get NPE. DEBUG 30-07 09:21:58,266 - org.pentaho.di.trans.steps.databaselookup.DatabaseLookupMeta@b536e6 - Looking at connection: conn2 INFO 30-07 09:21:58,315 - conn2 - New database connection defined INFO 30-07 09:21:58,318 - conn2 - Connected to database. INFO 30-07 09:21:58,367 - java.lang.NullPointerException java.lang.NullPointerException at org.pentaho.di.core.database.Database.getViews(Database.java:3971) at org.pentaho.di.core.database.Database.getViews(Database.java:3956) at org.pentaho.di.core.database.Database.getViews(Database.java:3952) at org.pentaho.di.ui.core.database.dialog.XulDatabaseExplorerController.createDatabaseNodes(XulDatabaseExplorerC ontroller.java:452) at org.pentaho.di.ui.core.database.dialog.XulDatabaseExplorerController.init(XulDatabaseExplorerController.java: 124) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:325) at org.pentaho.ui.xul.impl.AbstractXulDomContainer.initialize(AbstractXulDomContainer.java:153) at org.pentaho.ui.xul.swt.SwtXulRunner$1.run(SwtXulRunner.java:54) at org.eclipse.swt.widgets.Synchronizer.syncExec(Unknown Source) at org.eclipse.swt.widgets.Display.syncExec(Unknown Source) at org.pentaho.ui.xul.swt.SwtXulRunner.initialize(SwtXulRunner.java:51) at org.pentaho.di.ui.core.database.dialog.XulDatabaseExplorerDialog.open(XulDatabaseExplorerDialog.java:87) at org.pentaho.di.ui.trans.steps.databaselookup.DatabaseLookupDialog.getTableName(DatabaseLookupDialog.java:767) at org.pentaho.di.ui.trans.steps.databaselookup.DatabaseLookupDialog.access$800(DatabaseLookupDialog.java:68) at org.pentaho.di.ui.trans.steps.databaselookup.DatabaseLookupDialog$16.widgetSelected(DatabaseLookupDialog.java :532) at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source) at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source) at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source) at org.pentaho.di.ui.trans.steps.databaselookup.DatabaseLookupDialog.open(DatabaseLookupDialog.java:548) at org.pentaho.di.ui.spoon.delegates.SpoonStepsDelegate.editStep(SpoonStepsDelegate.java:126) at org.pentaho.di.ui.spoon.Spoon.editStep(Spoon.java:7389) at org.pentaho.di.ui.spoon.trans.TransGraph.editStep(TransGraph.java:2610) at org.pentaho.di.ui.spoon.trans.TransGraph.mouseDoubleClick(TransGraph.java:691) at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source) at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source) at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source) at org.pentaho.di.ui.spoon.Spoon.readAndDispatch(Spoon.java:1147) at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:6627) at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:544) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.pentaho.commons.launcher.Launcher.main(Launcher.java:110)

    Pentaho BI Platform Tracking | 7 years ago | Golda David
    java.lang.NullPointerException

    Root Cause Analysis

    1. java.lang.NullPointerException

      No message provided

      at org.pentaho.di.core.database.Database.getViews()
    2. org.pentaho.di
      XulDatabaseExplorerController.init
      1. org.pentaho.di.core.database.Database.getViews(Database.java:3971)
      2. org.pentaho.di.core.database.Database.getViews(Database.java:3956)
      3. org.pentaho.di.core.database.Database.getViews(Database.java:3952)
      4. org.pentaho.di.ui.core.database.dialog.XulDatabaseExplorerController.createDatabaseNodes(XulDatabaseExplorerController.java:452)
      5. org.pentaho.di.ui.core.database.dialog.XulDatabaseExplorerController.init(XulDatabaseExplorerController.java:124)
      5 frames
    3. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
      4. java.lang.reflect.Method.invoke(Unknown Source)
      4 frames
    4. org.pentaho.ui
      SwtXulRunner$1.run
      1. org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:325)
      2. org.pentaho.ui.xul.impl.AbstractXulDomContainer.initialize(AbstractXulDomContainer.java:153)
      3. org.pentaho.ui.xul.swt.SwtXulRunner$1.run(SwtXulRunner.java:54)
      3 frames
    5. RWT
      Display.syncExec
      1. org.eclipse.swt.widgets.Synchronizer.syncExec(Unknown Source)
      2. org.eclipse.swt.widgets.Display.syncExec(Unknown Source)
      2 frames
    6. org.pentaho.ui
      SwtXulRunner.initialize
      1. org.pentaho.ui.xul.swt.SwtXulRunner.initialize(SwtXulRunner.java:51)
      1 frame
    7. org.pentaho.di
      DatabaseLookupDialog$16.widgetSelected
      1. org.pentaho.di.ui.core.database.dialog.XulDatabaseExplorerDialog.open(XulDatabaseExplorerDialog.java:87)
      2. org.pentaho.di.ui.trans.steps.databaselookup.DatabaseLookupDialog.getTableName(DatabaseLookupDialog.java:767)
      3. org.pentaho.di.ui.trans.steps.databaselookup.DatabaseLookupDialog.access$800(DatabaseLookupDialog.java:68)
      4. org.pentaho.di.ui.trans.steps.databaselookup.DatabaseLookupDialog$16.widgetSelected(DatabaseLookupDialog.java:532)
      4 frames
    8. RWT
      Display.readAndDispatch
      1. org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)
      2. org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
      3. org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
      4. org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
      5. org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
      5 frames
    9. org.pentaho.di
      TransGraph.mouseDoubleClick
      1. org.pentaho.di.ui.trans.steps.databaselookup.DatabaseLookupDialog.open(DatabaseLookupDialog.java:548)
      2. org.pentaho.di.ui.spoon.delegates.SpoonStepsDelegate.editStep(SpoonStepsDelegate.java:126)
      3. org.pentaho.di.ui.spoon.Spoon.editStep(Spoon.java:7389)
      4. org.pentaho.di.ui.spoon.trans.TransGraph.editStep(TransGraph.java:2610)
      5. org.pentaho.di.ui.spoon.trans.TransGraph.mouseDoubleClick(TransGraph.java:691)
      5 frames
    10. RWT
      Display.readAndDispatch
      1. org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)
      2. org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
      3. org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
      4. org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
      5. org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
      5 frames
    11. org.pentaho.di
      Spoon.main
      1. org.pentaho.di.ui.spoon.Spoon.readAndDispatch(Spoon.java:1147)
      2. org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:6627)
      3. org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:544)
      3 frames
    12. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
      4. java.lang.reflect.Method.invoke(Unknown Source)
      4 frames
    13. org.pentaho.commons
      Launcher.main
      1. org.pentaho.commons.launcher.Launcher.main(Launcher.java:110)
      1 frame