mattcasters opened a new issue, #9136: URL: https://github.com/apache/hop/issues/9136
### Apache Hop version? 2.20.0 ### Java version? OpenJDK 21 ### Operating system Docker ### What happened? When there's no result to a query because of an error there's an unhandled exception: ``` 2026/10/28 22:13:47 - GUI - ERROR: Execute SQL on CRM 2026/10/28 22:13:47 - GUI - org.apache.hop.core.exception.HopDatabaseException: 2026/10/28 22:13:47 - GUI - An error occurred executing SQL: 2026/10/28 22:13:47 - GUI - SELECT o.order_id, e.message_id 2026/10/28 22:13:47 - GUI - FROM order_header o 2026/10/28 22:13:47 - GUI - INNER JOIN order_shipment_tracking e ON o.order_id = e.order_id limit 1000 2026/10/28 22:13:47 - GUI - ERROR: relation "order_shipment_tracking" does not exist 2026/10/28 22:13:47 - GUI - Position: 64 2026/10/28 22:13:47 - GUI - 2026/10/28 22:13:47 - GUI - at org.apache.hop.core.database.Database.openQuery(Database.java:1815) 2026/10/28 22:13:47 - GUI - at org.apache.hop.core.database.Database.getRows(Database.java:4016) 2026/10/28 22:13:47 - GUI - at org.apache.hop.core.database.Database.getRows(Database.java:3980) 2026/10/28 22:13:47 - GUI - at org.apache.hop.core.database.Database.getRows(Database.java:3964) 2026/10/28 22:13:47 - GUI - at org.apache.hop.ui.hopgui.perspective.database.DatabaseSqlEditorTab.lambda$9(DatabaseSqlEditorTab.java:469) 2026/10/28 22:13:47 - GUI - at org.apache.hop.ui.hopgui.perspective.database.DatabaseWorkbench.lambda$25(DatabaseWorkbench.java:1625) 2026/10/28 22:13:47 - GUI - at org.eclipse.rap.rwt.internal.lifecycle.ContextUtil.runNonUIThreadWithFakeContext(ContextUtil.java:67) 2026/10/28 22:13:47 - GUI - at org.eclipse.rap.rwt.internal.service.UISessionImpl.exec(UISessionImpl.java:269) 2026/10/28 22:13:47 - GUI - at org.apache.hop.ui.hopgui.BackgroundThreadFacadeImpl.lambda$0(BackgroundThreadFacadeImpl.java:48) 2026/10/28 22:13:47 - GUI - at java.base/java.lang.Thread.run(Thread.java:1583) 2026/10/28 22:13:47 - GUI - Caused by: org.postgresql.util.PSQLException: ERROR: relation "order_shipment_tracking" does not exist 2026/10/28 22:13:47 - GUI - Position: 64 2026/10/28 22:13:47 - GUI - at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2993) 2026/10/28 22:13:47 - GUI - at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2656) 2026/10/28 22:13:47 - GUI - at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:446) 2026/10/28 22:13:47 - GUI - at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:533) 2026/10/28 22:13:47 - GUI - at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:449) 2026/10/28 22:13:47 - GUI - at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:371) 2026/10/28 22:13:47 - GUI - at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:356) 2026/10/28 22:13:47 - GUI - at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:332) 2026/10/28 22:13:47 - GUI - at org.postgresql.jdbc.PgStatement.executeQuery(PgStatement.java:282) 2026/10/28 22:13:47 - GUI - at org.apache.hop.core.database.Database.openQuery(Database.java:1802) 2026/10/28 22:13:47 - GUI - ... 9 more 2026/10/28 22:13:52 - GUI - ERROR: Execute SQL on CRM 2026/10/28 22:13:52 - GUI - org.apache.hop.core.exception.HopDatabaseException: 2026/10/28 22:13:52 - GUI - An error occurred executing SQL: 2026/10/28 22:13:52 - GUI - SELECT o.order_id, e.message_id 2026/10/28 22:13:52 - GUI - FROM order_header o 2026/10/28 22:13:52 - GUI - INNER JOIN order_shipment_tracking e ON o.order_id = e.order_id limit 1000 2026/10/28 22:13:52 - GUI - ERROR: relation "order_shipment_tracking" does not exist 2026/10/28 22:13:52 - GUI - Position: 64 2026/10/28 22:13:52 - GUI - 2026/10/28 22:13:52 - GUI - at org.apache.hop.core.database.Database.openQuery(Database.java:1815) 2026/10/28 22:13:52 - GUI - at org.apache.hop.core.database.Database.getRows(Database.java:4016) 2026/10/28 22:13:52 - GUI - at org.apache.hop.core.database.Database.getRows(Database.java:3980) 2026/10/28 22:13:52 - GUI - at org.apache.hop.core.database.Database.getRows(Database.java:3964) 2026/10/28 22:13:52 - GUI - at org.apache.hop.ui.hopgui.perspective.database.DatabaseSqlEditorTab.lambda$9(DatabaseSqlEditorTab.java:469) 2026/10/28 22:13:52 - GUI - at org.apache.hop.ui.hopgui.perspective.database.DatabaseWorkbench.lambda$25(DatabaseWorkbench.java:1625) 2026/10/28 22:13:52 - GUI - at org.eclipse.rap.rwt.internal.lifecycle.ContextUtil.runNonUIThreadWithFakeContext(ContextUtil.java:67) 2026/10/28 22:13:52 - GUI - at org.eclipse.rap.rwt.internal.service.UISessionImpl.exec(UISessionImpl.java:269) 2026/10/28 22:13:52 - GUI - at org.apache.hop.ui.hopgui.BackgroundThreadFacadeImpl.lambda$0(BackgroundThreadFacadeImpl.java:48) 2026/10/28 22:13:52 - GUI - at java.base/java.lang.Thread.run(Thread.java:1583) 2026/10/28 22:13:52 - GUI - Caused by: org.postgresql.util.PSQLException: ERROR: relation "order_shipment_tracking" does not exist 2026/10/28 22:13:52 - GUI - Position: 64 2026/10/28 22:13:52 - GUI - at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2993) 2026/10/28 22:13:52 - GUI - at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2656) 2026/10/28 22:13:52 - GUI - at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:446) 2026/10/28 22:13:52 - GUI - at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:533) 2026/10/28 22:13:52 - GUI - at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:449) 2026/10/28 22:13:52 - GUI - at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:371) 2026/10/28 22:13:52 - GUI - at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:356) 2026/10/28 22:13:52 - GUI - at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:332) 2026/10/28 22:13:52 - GUI - at org.postgresql.jdbc.PgStatement.executeQuery(PgStatement.java:282) 2026/10/28 22:13:52 - GUI - at org.apache.hop.core.database.Database.openQuery(Database.java:1802) 2026/10/28 22:13:52 - GUI - ... 9 more 2026/10/28 22:13:55 - GUI - ERROR: Unable to restore Database SQL editor tabs 2026/10/28 22:13:55 - GUI - org.apache.hop.core.exception.HopRuntimeException: Already disposed 2026/10/28 22:13:55 - GUI - at org.apache.hop.core.SwtUniversalImage.checkDisposed(SwtUniversalImage.java:68) 2026/10/28 22:13:55 - GUI - at org.apache.hop.core.SwtUniversalImage.cached(SwtUniversalImage.java:104) 2026/10/28 22:13:55 - GUI - at org.apache.hop.core.SwtUniversalImage.getAsBitmapForSize(SwtUniversalImage.java:90) 2026/10/28 22:13:55 - GUI - at org.apache.hop.ui.core.gui.GuiResource.getZoomedImaged(GuiResource.java:1240) 2026/10/28 22:13:55 - GUI - at org.apache.hop.ui.core.gui.GuiResource.getImageFile(GuiResource.java:1370) 2026/10/28 22:13:55 - GUI - at org.apache.hop.ui.hopgui.perspective.database.DatabaseSqlEditorTab.refreshTabPresentation(DatabaseSqlEditorTab.java:560) 2026/10/28 22:13:55 - GUI - at org.apache.hop.ui.hopgui.perspective.database.DatabaseSqlEditorTab.setTabItem(DatabaseSqlEditorTab.java:151) 2026/10/28 22:13:55 - GUI - at org.apache.hop.ui.hopgui.perspective.database.DatabaseWorkbench.openSqlTab(DatabaseWorkbench.java:1251) 2026/10/28 22:13:55 - GUI - at org.apache.hop.ui.hopgui.perspective.database.DatabaseWorkbench.restoreSqlTab(DatabaseWorkbench.java:1498) 2026/10/28 22:13:55 - GUI - at org.apache.hop.ui.hopgui.perspective.database.DatabaseSqlTabMemory.restore(DatabaseSqlTabMemory.java:95) 2026/10/28 22:13:55 - GUI - at org.apache.hop.ui.hopgui.perspective.database.DatabaseSqlTabMemory.restoreIntoRemaining(DatabaseSqlTabMemory.java:265) 2026/10/28 22:13:55 - GUI - at org.apache.hop.ui.hopgui.perspective.database.DatabaseWorkbench.lambda$15(DatabaseWorkbench.java:281) 2026/10/28 22:13:55 - GUI - at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:173) 2026/10/28 22:13:55 - GUI - at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:111) 2026/10/28 22:13:55 - GUI - at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:824) 2026/10/28 22:13:55 - GUI - at org.eclipse.swt.widgets.Widget.notifyListeners(Widget.java:599) 2026/10/28 22:13:55 - GUI - at org.eclipse.swt.widgets.Widget.dispose(Widget.java:978) 2026/10/28 22:13:55 - GUI - at org.eclipse.swt.widgets.Composite.releaseChildren(Composite.java:873) 2026/10/28 22:13:55 - GUI - at org.eclipse.swt.widgets.Shell.releaseChildren(Shell.java:994) 2026/10/28 22:13:55 - GUI - at org.eclipse.swt.widgets.Widget.dispose(Widget.java:981) 2026/10/28 22:13:55 - GUI - at org.eclipse.swt.widgets.Display.disposeShells(Display.java:763) 2026/10/28 22:13:55 - GUI - at org.eclipse.swt.widgets.Display.release(Display.java:739) 2026/10/28 22:13:55 - GUI - at org.eclipse.swt.graphics.Device.dispose(Device.java:279) 2026/10/28 22:13:55 - GUI - at org.eclipse.rap.rwt.internal.lifecycle.UIThread.processShutdown(UIThread.java:179) 2026/10/28 22:13:55 - GUI - at org.eclipse.rap.rwt.internal.lifecycle.RWTLifeCycle$UIThreadController.run(RWTLifeCycle.java:309) 2026/10/28 22:13:55 - GUI - at java.base/java.lang.Thread.run(Thread.java:1583) 2026/10/28 22:13:55 - GUI - at org.eclipse.rap.rwt.internal.lifecycle.UIThread.run(UIThread.java:107) ``` ### Issue Priority Priority: 1 ### Issue Component Component: Hop Web, Component: Hop Gui, Component: Database -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
