Hi Folks,
I have a knime workflow that i have automated to run via windows task scheduler.
I am using Dbeaver Presto connection and had to mover recently to Trino driver for PRESTO. I had the Trino driver set up in KNIME and was able to run the query when displayed on KNIME workflow editor. The same workflow when launched via a batch file fails to run and thus the windows task scheduler. I Think that it is the TRINO driver but everything seems to be setup properly. I don’t understand why it is not working via the Batch file. Any help would be appreciated
Regards
Pio
KNIME log file:
2023-06-09 04:00:28,861 : ERROR : main : : MAEFileUtils : Weekly_Summary_Latest_Deployed : 3 : Schrodinger Knime plugins: Neither SCHRODINGER environment nor preference is set. You can set SCHRODINGER installation location in the Schrodinger Preferences.
2023-06-09 04:00:28,870 : WARN : main : : SchrodFileUtils : Weekly_Summary_Latest_Deployed : 3 : SCHRODINGER is not set properly.
2023-06-09 04:00:28,891 : WARN : main : : PythonService : Weekly_Summary_Latest_Deployed : 3 : PythonService is not initilized
2023-06-09 04:00:28,891 : WARN : main : : PythonService : Weekly_Summary_Latest_Deployed : 3 : Failed to start python service.
2023-06-09 04:00:48,322 : ERROR : main : : RDKitTypesPluginActivator : Weekly_Summary_Latest_Deployed : 3 : Could not load native RDKit library: no GraphMolWrap in java.library.path: C:\Users\480117\knime_4.6.2\knime_4.6.2;C:\WINDOWS\Sun\Java\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\Program Files\Python39\Scripts;C:\Program Files\Python39;c:\tibco\tibrv\8.2\bin;C:\Program Files (x86)\Brooks Automation\ThinClient\Bin;C:\Program Files (x86)\Brooks Automation\Common\Servers;C:\oracle\product\10.2.0\client_1;C:\OracleIC\11.1.0.7.0\iClient32;C:\OracleIC\11.1.0.7.0\iClient64;C:\windows\system32;C:\windows;C:\windows\System32\Wbem;C:\windows\System32\WindowsPowerShell\v1.0;C:\Users\201408\AppData\Local\Microsoft\WindowsApps;C:\Oracle2\product\11.2.0\client_1\bin;C:\Program Files (x86)\Microsoft SQL Server\150\DTS\Binn;C:\Program Files (x86)\Sennheiser\SoftphoneSDK;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0;C:\WINDOWS\System32\OpenSSH;C:\Program Files\PuTTY;C:\Program Files\Microsoft VS Code\bin;C:\Program Files (x86)\Common Files\Oracle\Java\javapath;C:\Program Files (x86)\Web;C:\Users\480117\AppData\Local\Microsoft\WindowsApps;C:\Users\480117\AppData\Roaming\Python\Python39\Scripts;C:\Users\480117\AppData\Local\Programs\Microsoft VS Code\bin;.
java.lang.UnsatisfiedLinkError: no GraphMolWrap in java.library.path: C:\Users\480117\knime_4.6.2\knime_4.6.2;C:\WINDOWS\Sun\Java\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\Program Files\Python39\Scripts;C:\Program Files\Python39;c:\tibco\tibrv\8.2\bin;C:\Program Files (x86)\Brooks Automation\ThinClient\Bin;C:\Program Files (x86)\Brooks Automation\Common\Servers;C:\oracle\product\10.2.0\client_1;C:\OracleIC\11.1.0.7.0\iClient32;C:\OracleIC\11.1.0.7.0\iClient64;C:\windows\system32;C:\windows;C:\windows\System32\Wbem;C:\windows\System32\WindowsPowerShell\v1.0;C:\Users\201408\AppData\Local\Microsoft\WindowsApps;C:\Oracle2\product\11.2.0\client_1\bin;C:\Program Files (x86)\Microsoft SQL Server\150\DTS\Binn;C:\Program Files (x86)\Sennheiser\SoftphoneSDK;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0;C:\WINDOWS\System32\OpenSSH;C:\Program Files\PuTTY;C:\Program Files\Microsoft VS Code\bin;C:\Program Files (x86)\Common Files\Oracle\Java\javapath;C:\Program Files (x86)\Web;C:\Users\480117\AppData\Local\Microsoft\WindowsApps;C:\Users\480117\AppData\Roaming\Python\Python39\Scripts;C:\Users\480117\AppData\Local\Programs\Microsoft VS Code\bin;.
at java.base/java.lang.ClassLoader.loadLibrary(Unknown Source)
at java.base/java.lang.Runtime.loadLibrary0(Unknown Source)
at java.base/java.lang.System.loadLibrary(Unknown Source)
at org.rdkit.knime.RDKitTypesPluginActivator.start(RDKitTypesPluginActivator.java:166)
at org.eclipse.osgi.internal.framework.BundleContextImpl$2.run(BundleContextImpl.java:814)
at org.eclipse.osgi.internal.framework.BundleContextImpl$2.run(BundleContextImpl.java:1)
at java.base/java.security.AccessController.doPrivileged(Unknown Source)
at org.eclipse.osgi.internal.framework.BundleContextImpl.startActivator(BundleContextImpl.java:806)
at org.eclipse.osgi.internal.framework.BundleContextImpl.start(BundleContextImpl.java:763)
at org.eclipse.osgi.internal.framework.EquinoxBundle.startWorker0(EquinoxBundle.java:1012)
at org.eclipse.osgi.internal.framework.EquinoxBundle$EquinoxModule.startWorker(EquinoxBundle.java:366)
at org.eclipse.osgi.container.Module.doStart(Module.java:605)
at org.eclipse.osgi.container.Module.start(Module.java:468)
at org.eclipse.osgi.framework.util.SecureAction.start(SecureAction.java:506)
at org.eclipse.osgi.internal.hooks.EclipseLazyStarter.postFindLocalClass(EclipseLazyStarter.java:117)
at org.eclipse.osgi.internal.loader.classpath.ClasspathManager.findLocalClass(ClasspathManager.java:572)
at org.eclipse.osgi.internal.loader.ModuleClassLoader.findLocalClass(ModuleClassLoader.java:346)
at org.eclipse.osgi.internal.loader.BundleLoader.findLocalClass(BundleLoader.java:401)
at org.eclipse.osgi.internal.loader.sources.SingleSourcePackage.loadClass(SingleSourcePackage.java:41)
at org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:476)
at org.eclipse.osgi.internal.loader.ModuleClassLoader.loadClass(ModuleClassLoader.java:171)
at java.base/java.lang.ClassLoader.loadClass(Unknown Source)
at java.base/java.lang.Class.getDeclaredConstructors0(Native Method)
at java.base/java.lang.Class.privateGetDeclaredConstructors(Unknown Source)
at java.base/java.lang.Class.getConstructor0(Unknown Source)
at java.base/java.lang.Class.getConstructor(Unknown Source)
at org.eclipse.osgi.internal.framework.BundleContextImpl.loadBundleActivator(BundleContextImpl.java:797)
at org.eclipse.osgi.internal.framework.BundleContextImpl.start(BundleContextImpl.java:749)
at org.eclipse.osgi.internal.framework.EquinoxBundle.startWorker0(EquinoxBundle.java:1012)
at org.eclipse.osgi.internal.framework.EquinoxBundle$EquinoxModule.startWorker(EquinoxBundle.java:366)
at org.eclipse.osgi.container.Module.doStart(Module.java:605)
at org.eclipse.osgi.container.Module.start(Module.java:468)
at org.eclipse.osgi.framework.util.SecureAction.start(SecureAction.java:506)
at org.eclipse.osgi.internal.hooks.EclipseLazyStarter.postFindLocalClass(EclipseLazyStarter.java:117)
at org.eclipse.osgi.internal.loader.classpath.ClasspathManager.findLocalClass(ClasspathManager.java:572)
at org.eclipse.osgi.internal.loader.ModuleClassLoader.findLocalClass(ModuleClassLoader.java:346)
at org.eclipse.osgi.internal.loader.BundleLoader.findLocalClass(BundleLoader.java:401)
at org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:480)
at org.eclipse.osgi.internal.loader.ModuleClassLoader.loadClass(ModuleClassLoader.java:171)
at java.base/java.lang.ClassLoader.loadClass(Unknown Source)
at org.eclipse.osgi.internal.framework.EquinoxBundle.loadClass(EquinoxBundle.java:617)
at org.eclipse.core.internal.registry.osgi.RegistryStrategyOSGI.createExecutableExtension(RegistryStrategyOSGI.java:196)
at org.eclipse.core.internal.registry.ExtensionRegistry.createExecutableExtension(ExtensionRegistry.java:920)
at org.eclipse.core.internal.registry.ConfigurationElement.createExecutableExtension(ConfigurationElement.java:246)
at org.eclipse.core.internal.registry.ConfigurationElementHandle.createExecutableExtension(ConfigurationElementHandle.java:63)
at org.knime.core.node.extension.NodeFactoryExtension.createFactory(NodeFactoryExtension.java:184)
at org.knime.core.node.extension.NodeFactoryExtension.getFactory(NodeFactoryExtension.java:169)
at org.knime.core.node.extension.NodeFactoryExtension.isDeprecated(NodeFactoryExtension.java:126)
at java.base/java.util.stream.ReferencePipeline$2$1.accept(Unknown Source)
at java.base/java.util.Iterator.forEachRemaining(Unknown Source)
at java.base/java.util.Spliterators$IteratorSpliterator.forEachRemaining(Unknown Source)
at java.base/java.util.stream.AbstractPipeline.copyInto(Unknown Source)
at java.base/java.util.stream.AbstractPipeline.wrapAndCopyInto(Unknown Source)
at java.base/java.util.stream.ReduceOps$ReduceOp.evaluateSequential(Unknown Source)
at java.base/java.util.stream.ReduceOps$5.evaluateSequential(Unknown Source)
at java.base/java.util.stream.ReduceOps$5.evaluateSequential(Unknown Source)
at java.base/java.util.stream.AbstractPipeline.evaluate(Unknown Source)
at java.base/java.util.stream.ReferencePipeline.count(Unknown Source)
at org.knime.core.node.extension.NodeFactoryExtensionManager.getInstance(NodeFactoryExtensionManager.java:126)
at org.knime.core.node.workflow.FileNativeNodeContainerPersistor.loadNodeFactory(FileNativeNodeContainerPersistor.java:304)
at org.knime.core.node.workflow.FileNativeNodeContainerPersistor.preLoadNodeContainer(FileNativeNodeContainerPersistor.java:179)
at org.knime.core.node.workflow.FileWorkflowPersistor.loadNodeContainer(FileWorkflowPersistor.java:971)
at org.knime.core.node.workflow.WorkflowManager.postLoad(WorkflowManager.java:8773)
at org.knime.core.node.workflow.WorkflowManager.loadContent(WorkflowManager.java:8675)
at org.knime.core.node.workflow.WorkflowManager.load(WorkflowManager.java:8539)
at org.knime.core.node.workflow.WorkflowManager.load(WorkflowManager.java:8460)
at org.knime.core.node.workflow.WorkflowManager.load(WorkflowManager.java:8433)
at org.knime.core.node.workflow.WorkflowManager.loadProject(WorkflowManager.java:8278)
at org.knime.core.node.workflow.BatchExecutor.loadWorkflow(BatchExecutor.java:740)
at org.knime.core.node.workflow.BatchExecutor.runOne(BatchExecutor.java:907)
at org.knime.core.node.workflow.BatchExecutor.runAll(BatchExecutor.java:889)
at org.knime.core.node.workflow.BatchExecutor.mainRun(BatchExecutor.java:671)
at org.knime.product.headless.KNIMEBatchApplication.runBatchExecutor(KNIMEBatchApplication.java:127)
at org.knime.product.headless.KNIMEBatchApplication.start(KNIMEBatchApplication.java:80)
at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:203)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:134)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:104)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:401)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:255)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.base/java.lang.reflect.Method.invoke(Unknown Source)
at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:653)
at org.eclipse.equinox.launcher.Main.basicRun(Main.java:590)
at org.eclipse.equinox.launcher.Main.run(Main.java:1461)
2023-06-09 04:00:48,356 : ERROR : main : : RDKitTypesPluginActivator : Weekly_Summary_Latest_Deployed : 3 : The RDKit Binary Plugin org.rdkit.knime.bin.win32.x86_64 is not properly installed. Please uninstall and reinstall the RDKit Nodes.
2023-06-09 04:01:27,958 : WARN : main : : Node : DB Connector : 3:525:627:659 : Loading model settings failed: Could not find the [TRINO_DRIVER] database driver.
2023-06-09 04:01:27,983 : WARN : main : : Node : DB Connector : 3:525:627:659 : DB Connection no longer available. Go to advanced settings to enable connection restoration.
2023-06-09 04:01:29,113 : WARN : main : : Node : DB Connector : 3:525:625:659 : Loading model settings failed: Could not find the [TRINO_DRIVER] database driver.
2023-06-09 04:01:29,115 : WARN : main : : Node : DB Connector : 3:525:625:659 : DB Connection no longer available. Go to advanced settings to enable connection restoration.
2023-06-09 04:01:30,400 : ERROR : main : : ExplorerMountTable : Calc ■■■ and Native : 3:525:625:792:785 : Unable to restore mount point ‘NodePit’ (from com.nodepit.knime.explorer): Internal error: The content provider with the specified id (com.nodepit.knime.explorer) is not available.
java.io.IOException: Internal error: The content provider with the specified id (com.nodepit.knime.explorer) is not available.
at org.knime.workbench.explorer.ExplorerMountTable.mountOrRestore(ExplorerMountTable.java:292)
at org.knime.workbench.explorer.ExplorerMountTable.init(ExplorerMountTable.java:708)
at org.knime.workbench.explorer.ExplorerMountTable.(ExplorerMountTable.java:616)
at org.knime.workbench.explorer.ExplorerMountPointFileSystemAccess.getMountedIDs(ExplorerMountPointFileSystemAccess.java:83)
at org.knime.filehandling.core.util.MountPointFileSystemAccessService.getAllMountedIDs(MountPointFileSystemAccessService.java:142)
at org.knime.filehandling.core.defaultnodesettings.filesystemchooser.config.MountpointSpecificConfig.lambda$0(MountpointSpecificConfig.java:116)
at org.knime.filehandling.core.defaultnodesettings.filesystemchooser.config.MountpointSpecificConfig.getDefaultMountpoint(MountpointSpecificConfig.java:208)
at org.knime.filehandling.core.defaultnodesettings.filesystemchooser.config.MountpointSpecificConfig.(MountpointSpecificConfig.java:128)
at org.knime.filehandling.core.defaultnodesettings.filesystemchooser.config.MountpointSpecificConfig.(MountpointSpecificConfig.java:116)
at org.knime.filehandling.core.defaultnodesettings.filesystemchooser.FileSystemChooserUtils.createConvenienceConfig(FileSystemChooserUtils.java:127)
at org.knime.filehandling.core.defaultnodesettings.filesystemchooser.FileSystemChooserUtils.lambda$0(FileSystemChooserUtils.java:114)
at java.base/java.util.stream.ReferencePipeline$3$1.accept(Unknown Source)
at java.base/java.util.Iterator.forEachRemaining(Unknown Source)
at java.base/java.util.Spliterators$IteratorSpliterator.forEachRemaining(Unknown Source)
at java.base/java.util.stream.AbstractPipeline.copyInto(Unknown Source)
at java.base/java.util.stream.AbstractPipeline.wrapAndCopyInto(Unknown Source)
at java.base/java.util.stream.StreamSpliterators$WrappingSpliterator.forEachRemaining(Unknown Source)
at java.base/java.util.stream.Streams$ConcatSpliterator.forEachRemaining(Unknown Source)
at java.base/java.util.stream.AbstractPipeline.copyInto(Unknown Source)
at java.base/java.util.stream.AbstractPipeline.wrapAndCopyInto(Unknown Source)
at java.base/java.util.stream.AbstractPipeline.evaluate(Unknown Source)
at java.base/java.util.stream.AbstractPipeline.evaluateToArrayNode(Unknown Source)
at java.base/java.util.stream.ReferencePipeline.toArray(Unknown Source)
at org.knime.filehandling.core.defaultnodesettings.filesystemchooser.FileSystemChooserUtils.createSpecificConfigs(FileSystemChooserUtils.java:117)
at org.knime.filehandling.core.defaultnodesettings.filesystemchooser.FileSystemChooserUtils.createConfig(FileSystemChooserUtils.java:104)
at org.knime.filehandling.core.defaultnodesettings.filechooser.AbstractSettingsModelFileChooser.(AbstractSettingsModelFileChooser.java:149)
at org.knime.filehandling.core.defaultnodesettings.filechooser.writer.SettingsModelWriterFileChooser.(SettingsModelWriterFileChooser.java:125)
at org.knime.filehandling.core.defaultnodesettings.filechooser.writer.SettingsModelWriterFileChooser.(SettingsModelWriterFileChooser.java:148)
at org.knime.ext.poi3.node.io.filehandling.excel.writer.ExcelTableWriterConfig.(ExcelTableWriterConfig.java:155)
at org.knime.ext.poi3.node.io.filehandling.excel.writer.ExcelTableWriterNodeModel.(ExcelTableWriterNodeModel.java:131)
at org.knime.ext.poi3.node.io.filehandling.excel.writer.ExcelTableWriterNodeFactory.createNodeModel(ExcelTableWriterNodeFactory.java:85)
at org.knime.ext.poi3.node.io.filehandling.excel.writer.ExcelTableWriterNodeFactory.createNodeModel(ExcelTableWriterNodeFactory.java:1)
at org.knime.core.node.NodeFactory.callCreateNodeModel(NodeFactory.java:524)
at org.knime.core.node.Node.(Node.java:307)
at org.knime.core.node.workflow.FileNativeNodeContainerPersistor.preLoadNodeContainer(FileNativeNodeContainerPersistor.java:197)
at org.knime.core.node.workflow.FileWorkflowPersistor.loadNodeContainer(FileWorkflowPersistor.java:971)
at org.knime.core.node.workflow.WorkflowManager.postLoad(WorkflowManager.java:8773)
at org.knime.core.node.workflow.WorkflowManager.loadContent(WorkflowManager.java:8675)
at org.knime.core.node.workflow.WorkflowManager.postLoad(WorkflowManager.java:8789)
at org.knime.core.node.workflow.WorkflowManager.loadContent(WorkflowManager.java:8675)
at org.knime.core.node.workflow.WorkflowManager.postLoad(WorkflowManager.java:8789)
at org.knime.core.node.workflow.WorkflowManager.loadContent(WorkflowManager.java:8675)
at org.knime.core.node.workflow.WorkflowManager.postLoad(WorkflowManager.java:8789)
at org.knime.core.node.workflow.WorkflowManager.loadContent(WorkflowManager.java:8675)
at org.knime.core.node.workflow.WorkflowManager.postLoad(WorkflowManager.java:8789)
at org.knime.core.node.workflow.WorkflowManager.loadContent(WorkflowManager.java:8675)
at org.knime.core.node.workflow.WorkflowManager.load(WorkflowManager.java:8539)
at org.knime.core.node.workflow.WorkflowManager.load(WorkflowManager.java:8460)
at org.knime.core.node.workflow.WorkflowManager.load(WorkflowManager.java:8433)
at org.knime.core.node.workflow.WorkflowManager.loadProject(WorkflowManager.java:8278)
at org.knime.core.node.workflow.BatchExecutor.loadWorkflow(BatchExecutor.java:740)
at org.knime.core.node.workflow.BatchExecutor.runOne(BatchExecutor.java:907)
at org.knime.core.node.workflow.BatchExecutor.runAll(BatchExecutor.java:889)
at org.knime.core.node.workflow.BatchExecutor.mainRun(BatchExecutor.java:671)
at org.knime.product.headless.KNIMEBatchApplication.runBatchExecutor(KNIMEBatchApplication.java:127)
at org.knime.product.headless.KNIMEBatchApplication.start(KNIMEBatchApplication.java:80)
at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:203)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:134)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:104)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:401)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:255)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.base/java.lang.reflect.Method.invoke(Unknown Source)
at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:653)
at org.eclipse.equinox.launcher.Main.basicRun(Main.java:590)
at org.eclipse.equinox.launcher.Main.run(Main.java:1461)
2023-06-09 04:01:31,144 : ERROR : main : : Node : DB Connector : 3:524:659 : Loading model settings failed: Could not find the [TRINO_DRIVER] database driver.
org.knime.core.node.InvalidSettingsException: Could not find the [TRINO_DRIVER] database driver.
at org.knime.database.node.connector.DBSessionSettings.validatePrimaryIds(DBSessionSettings.java:105)
at org.knime.database.node.connector.DBSessionSettings.validateSettings(DBSessionSettings.java:253)
at org.knime.database.node.connector.generic.DBConnectorSettings.validateSettings(DBConnectorSettings.java:124)
at org.knime.database.node.connector.AbstractDBConnectorNodeModel.validateSettingsInternal(AbstractDBConnectorNodeModel.java:283)
at org.knime.database.node.DBNodeModel.validateSettings(DBNodeModel.java:184)
at org.knime.core.node.Node.validateModelSettings(Node.java:692)
at org.knime.core.node.workflow.FileNativeNodeContainerPersistor.loadNCAndWashModelSettings(FileNativeNodeContainerPersistor.java:211)
at org.knime.core.node.workflow.FileSingleNodeContainerPersistor.loadNodeContainer(FileSingleNodeContainerPersistor.java:268)
at org.knime.core.node.workflow.WorkflowManager.postLoad(WorkflowManager.java:8773)
at org.knime.core.node.workflow.WorkflowManager.loadContent(WorkflowManager.java:8675)
at org.knime.core.node.workflow.WorkflowManager.postLoad(WorkflowManager.java:8789)
at org.knime.core.node.workflow.WorkflowManager.loadContent(WorkflowManager.java:8675)
at org.knime.core.node.workflow.WorkflowManager.postLoad(WorkflowManager.java:8789)
at org.knime.core.node.workflow.WorkflowManager.loadContent(WorkflowManager.java:8675)
at org.knime.core.node.workflow.WorkflowManager.load(WorkflowManager.java:8539)
at org.knime.core.node.workflow.WorkflowManager.load(WorkflowManager.java:8460)
at org.knime.core.node.workflow.WorkflowManager.load(WorkflowManager.java:8433)
at org.knime.core.node.workflow.WorkflowManager.loadProject(WorkflowManager.java:8278)
at org.knime.core.node.workflow.BatchExecutor.loadWorkflow(BatchExecutor.java:740)
at org.knime.core.node.workflow.BatchExecutor.runOne(BatchExecutor.java:907)
at org.knime.core.node.workflow.BatchExecutor.runAll(BatchExecutor.java:889)
at org.knime.core.node.workflow.BatchExecutor.mainRun(BatchExecutor.java:671)
at org.knime.product.headless.KNIMEBatchApplication.runBatchExecutor(KNIMEBatchApplication.java:127)
at org.knime.product.headless.KNIMEBatchApplication.start(KNIMEBatchApplication.java:80)
at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:203)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:134)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:104)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:401)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:255)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.base/java.lang.reflect.Method.invoke(Unknown Source)
at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:653)
at org.eclipse.equinox.launcher.Main.basicRun(Main.java:590)
at org.eclipse.equinox.launcher.Main.run(Main.java:1461)
2023-06-09 04:01:31,150 : WARN : main : : Node : DB Connector : 3:524:659 : Please select a database type.
2023-06-09 04:01:31,274 : WARN : main : : Node : DB Connector : 3:525:627:659 : Please select a database type.
2023-06-09 04:01:32,524 : WARN : main : : Node : String Manipulation : 3:525:625:777:769 : No such column: ■■■ Sorts (at line 1)
2023-06-09 04:01:32,567 : WARN : KNIME-Worker-1-Credentials Input 3:525:627:1118 : : Node : DB Connector : 3:525:627:659 : Please select a database type.
2023-06-09 04:01:33,008 : WARN : KNIME-Worker-2-Excel Reader (XLS) (deprecated) 3:525:625:698 : : Node : Excel Reader (XLS) (deprecated) : 3:525:625:698 : DataSpec generated by configure does not match spec after execution.
2023-06-09 04:01:37,298 : ERROR : KNIME-Worker-4-Oracle Connector 3:525:627:8 : : Node : Oracle Connector : 3:525:627:8 : Execute failed: ORA-01017: invalid username/password; logon denied
java.sql.SQLException: ORA-01017: invalid username/password; logon denied
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:389)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:382)
at oracle.jdbc.driver.T4CTTIfun.processError(T4CTTIfun.java:573)
at oracle.jdbc.driver.T4CTTIoauthenticate.processError(T4CTTIoauthenticate.java:431)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)
at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:366)
at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:752)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:366)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:536)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:228)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:521)
at org.knime.database.connection.UrlDBConnectionController$ControlledDriver.connect(UrlDBConnectionController.java:103)
at org.knime.database.connection.UrlDBConnectionController.connect(UrlDBConnectionController.java:368)
at org.knime.database.connection.UserDBConnectionController.connect(UserDBConnectionController.java:294)
at org.knime.database.connection.UrlDBConnectionController.createConnection(UrlDBConnectionController.java:348)
at org.knime.database.connection.AbstractConnectionProvider.createConnection(AbstractConnectionProvider.java:103)
at org.knime.database.connection.impl.DBConnectionManager.lambda$2(DBConnectionManager.java:501)
at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.base/java.lang.Thread.run(Unknown Source)
2023-06-09 04:01:38,570 : WARN : KNIME-Worker-1-Missing Value 3:525:625:697 : : Node : Missing Value : 3:525:625:697 : Column “Native Sorts” still contains missing values.
2023-06-09 04:01:38,934 : WARN : KNIME-Worker-3-String Manipulation 3:525:625:778:769 : : ColumnCalculator : String Manipulation : 3:525:625:778:769 : Row “Row0” contains missing value in column “Native Sorts” - returning missing (omitting further warnings)
2023-06-09 04:01:38,943 : WARN : KNIME-Worker-2-String Manipulation 3:525:625:778:770 : : ColumnCalculator : String Manipulation : 3:525:625:778:770 : Row “Row0” contains missing value in column “Native Sorts” - returning missing (omitting further warnings)
2023-06-09 04:01:38,949 : WARN : KNIME-Worker-4-String Manipulation 3:525:625:778:771 : : ColumnCalculator : String Manipulation : 3:525:625:778:771 : Row “Row0” contains missing value in column “Native Sorts” - returning missing (omitting further warnings)
2023-06-09 04:01:38,956 : WARN : KNIME-Worker-1-String Manipulation 3:525:625:778:772 : : ColumnCalculator : String Manipulation : 3:525:625:778:772 : Row “Row0” contains missing value in column “Native Sorts” - returning missing (omitting further warnings)
2023-06-09 04:01:38,963 : WARN : KNIME-Worker-3-String Manipulation 3:525:625:778:773 : : ColumnCalculator : String Manipulation : 3:525:625:778:773 : Row “Row0” contains missing value in column “Native Sorts” - returning missing (omitting further warnings)
2023-06-09 04:01:38,970 : WARN : KNIME-Worker-2-String Manipulation 3:525:625:778:774 : : ColumnCalculator : String Manipulation : 3:525:625:778:774 : Row “Row0” contains missing value in column “Native Sorts” - returning missing (omitting further warnings)
2023-06-09 04:01:38,977 : WARN : KNIME-Worker-4-String Manipulation 3:525:625:778:775 : : ColumnCalculator : String Manipulation : 3:525:625:778:775 : Row “Row0” contains missing value in column “Native Sorts” - returning missing (omitting further warnings)
2023-06-09 04:01:38,984 : WARN : KNIME-Worker-1-String Manipulation 3:525:625:778:776 : : ColumnCalculator : String Manipulation : 3:525:625:778:776 : Row “Row0” contains missing value in column “Native Sorts” - returning missing (omitting further warnings)
2023-06-09 04:01:48,125 : WARN : main : : WorkflowManager : : : Workflow contains nodes with duplicate parameter name (will be made unique by appending node IDs): “TRINO-account”
2023-06-09 04:01:48,131 : WARN : main : : WorkflowManager : : : Workflow contains nodes with duplicate parameter name (will be made unique by appending node IDs): “TRINO-account”