I need to use a AS400 Driver on/with KNIME Server/Executor in a Workflow, but I get the following message, when I try to open the WF as new Job on the Server:
ERROR CreateAndOpenJobWorkflowAction Error occurred while loading workflow into memory: An error occurred during the creation of a job for ‘FOLDER_OF_WF_AND_WF’: Could not load workflow ‘SERVER_ADR’ for 196f4400-b241-4ffc-87d1-582d7d5ded56: Errors loading workflow ‘WF_NAME’: Status: Error: WF 0 loaded with errors
Status: Error: WF load 0
Status: Error: DB Connector 0:1
Status: Error: Loading model settings failed: Could not find the [AS400] database driver.
I tried to reset the WF and uploaded it again.
But then the following happens:
The Server opens the WF, but the DB Connector Nodes shows, that I need to define the DB Type and it is not possible to load the driver.
I copied the .jar-File of the driver in several folders and then made the config this way:
- KNIME → Pref
- Database → New
- Filed out the from (Type DB2)
- Apply and close
- Export *.epf to config-folder in repository
- restart services
Server: 4.13.12 Executor: 4.4.2
On my AP 4.4.2 everything works fine.
Maybe someone know what to do.