Uploaded image for project: 'Apache Hop (Retired)'
  1. Apache Hop (Retired)
  2. HOP-4599

Postgres Bulk Loader - NPE when pressing SQL button.

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 2.2.0
    • Migrated to GHI
    • Transforms
    • None
    • Ubuntu 22.04 - Openjdk 11

    Description

      I was trying to go from a table input to the Postgres Bulk loader.  The table did not exist, but the schema and database do.  When I hit the "SQL" button to get a suggestion for how to create the destination table, I got an NPE saying "Unable to open dialog for this transformation"

       

      2022/11/16 15:38:02 - Preview pipeline for Table input - Execution finished on a local pipeline engine with run configuration 'local'
      java.lang.NullPointerException
              at org.apache.hop.pipeline.transforms.pgbulkloader.PGBulkLoaderDialog.getInfo(PGBulkLoaderDialog.java:691)
              at org.apache.hop.pipeline.transforms.pgbulkloader.PGBulkLoaderDialog.create(PGBulkLoaderDialog.java:817)
              at org.apache.hop.pipeline.transforms.pgbulkloader.PGBulkLoaderDialog.lambda$open$5(PGBulkLoaderDialog.java:429)
              at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:89)
              at org.eclipse.swt.widgets.Display.sendEvent(Display.java:5796)
              at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1529)
              at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:5025)
              at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:4477)
              at org.apache.hop.ui.core.dialog.BaseDialog.defaultShellHandling(BaseDialog.java:500)
              at org.apache.hop.pipeline.transforms.pgbulkloader.PGBulkLoaderDialog.open(PGBulkLoaderDialog.java:444)
              at org.apache.hop.ui.hopgui.file.pipeline.delegates.HopGuiPipelineTransformDelegate.editTransform(HopGuiPipelineTransformDelegate.java:174)
              at org.apache.hop.ui.hopgui.file.pipeline.HopGuiPipelineGraph.editTransform(HopGuiPipelineGraph.java:3341)
              at org.apache.hop.ui.hopgui.file.pipeline.HopGuiPipelineGraph.mouseDoubleClick(HopGuiPipelineGraph.java:596)
              at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:200)
              at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:89)
              at org.eclipse.swt.widgets.Display.sendEvent(Display.java:5796)
              at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1529)
              at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:5025)
              at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:4477)
              at org.apache.hop.ui.core.dialog.BaseDialog.defaultShellHandling(BaseDialog.java:500)
              at org.apache.hop.pipeline.transforms.tableinput.TableInputDialog.open(TableInputDialog.java:341)
              at org.apache.hop.ui.hopgui.file.pipeline.delegates.HopGuiPipelineTransformDelegate.editTransform(HopGuiPipelineTransformDelegate.java:174)
              at org.apache.hop.ui.hopgui.file.pipeline.HopGuiPipelineGraph.editTransform(HopGuiPipelineGraph.java:3341)
              at org.apache.hop.ui.hopgui.file.pipeline.HopGuiPipelineGraph.editTransform(HopGuiPipelineGraph.java:2162)
              at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
              at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
              at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
              at java.base/java.lang.reflect.Method.invoke(Method.java:566)
              at org.apache.hop.core.gui.plugin.action.GuiActionLambdaBuilder.lambda$createLambda$0(GuiActionLambdaBuilder.java:96)
              at org.apache.hop.ui.hopgui.context.GuiContextUtil.lambda$handleActionSelection$0(GuiContextUtil.java:183)
              at org.eclipse.swt.widgets.RunnableLock.run(RunnableLock.java:40)
              at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchronizer.java:132)
              at org.eclipse.swt.widgets.Display.runAsyncMessages(Display.java:5000)
              at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:4480)
              at org.apache.hop.ui.hopgui.HopGui.open(HopGui.java:464)
              at org.apache.hop.ui.hopgui.HopGui.main(HopGui.java:351)

      Attachments

        1. image-2022-11-16-15-45-32-814.png
          111 kB
          Brandon Jackson

        Activity

          People

            Unassigned Unassigned
            usbrandon Brandon Jackson
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: