Trigger workflow by change in a database

Is there any way with Knime desktop to trigger a workflow?

For example can you have a row within a database that changes and this triggers a specific workflow, or are there any other ways to trigger a workflow within Knime desktop.

I think this can be done in the enterprise server version, which is quite expensive?

 

 

Have a look at this:

http://tech.knime.org/faq#q12

You can create a command line command to run a workflow (e.g. in a flow variable with Java Edit variable node) and then use the bash node (NGS community contribution) or external tool nodes (KNIME Misc or KNIME Labs)

Steve

I have created a sample workflow and am trying to execute it via a batch command.

I get an ERROR main BatchExecutor IO error while loading the workflow and also get a JAVA alert

Java was started but returned exit code=3
-XX:MaxPermSize=256m
-server
-Dsun.java2d.d3d=false
-Dosgi.classloader.lock=classname
-XX:+UnlockDiagnosticVMOptions
-XX:+UnsyncloadClass
-Dknime.enable.fastload=true
-XstartOnFirstThread
-Xdock:icon=../Resources/knime.icns
-Dorg.eclipse.swt.internal.carbon.smallFonts
-Xmx1024m
-Djava.class.path=/Applications/knime/Knime.app/Contents/MacOS//../../../plugins/org.eclipse.equinox.launcher_1.2.0.v20110502.jar
-os macosx
-ws cocoa
-arch x86_64
-launcher /Applications/knime/Knime.app/Contents/MacOS/Knime
-name Knime
--launcher.library /Applications/knime/Knime.app/Contents/MacOS//../../../plugins/org.eclipse.equinox.launcher.cocoa.macosx.x86_64_1.1.101.v20120109-1504/eclipse_1408.so
-startup /Applications/knime/Knime.app/Contents/MacOS//../../../plugins/org.eclipse.equinox.launcher_1.2.0.v20110502.jar
--launcher.overrideVmargs
-application org.knime.product.KNIME_BATCH_APPLICATION
-workflowFile=/Applications/knime/workspace/Knime_batch/workflow.knime
-vm /System/Library/Frameworks/JavaVM.framework
-vmargs
-XX:MaxPermSize=256m
-server
-Dsun.java2d.d3d=false
-Dosgi.classloader.lock=classname
-XX:+UnlockDiagnosticVMOptions
-XX:+UnsyncloadClass
-Dknime.enable.fastload=true
-XstartOnFirstThread
-Xdock:icon=../Resources/knime.icns
-Dorg.eclipse.swt.internal.carbon.smallFonts
-Xmx1024m
-Djava.class.path=/Applications/knime/Knime.app/Contents/MacOS//../../../plugins/org.eclipse.equinox.launcher_1.2.0.v20110502.jar 

 

Any ideas?

Thanks for any help

The Java error is a result of the BatchExecutor error (in fact this always appears when the process finishes with a non-zero exit code). Can you post the latter?

The batchexecutor error just says IO error while loading the workflow.  Is this what your are referring to or is there somewhere else I need to look for this error?

 

Thanks.

It should say a bit more than just "I/O error". You can also have a look into the log file in <workspace>/.metadata/knime/knime.log

/Applications/knime/knime.app/Contents/MacOS/knime -nosplash -application org.knime.product.KNIME_BATCH_APPLICATION -workflowFile=/Applications/knime/workspace/Knime_batch/workflow.knime

INFO      main BatchExecutor     ===== Executing workflow /Applications/knime/workspace/Knime_batch/workflow.knime =====

ERROR     main BatchExecutor     IO error while loading the workflow

INFO      main BatchExecutor     ========= Workflow did not execute sucessfully ============

Davids-MacBook-Pro:Knime_batch DA$ 

 

!SESSION 2014-02-05 19:33:53.596 -----------------------------------------------
eclipse.buildId=unknown
java.version=1.6.0_65
java.vendor=Apple Inc.
BootLoader constants: OS=macosx, ARCH=x86_64, WS=cocoa, NL=en_US
Framework arguments:  -keyring /Users/DA/.eclipse_keyring -showlocation
Command-line arguments:  -os macosx -ws cocoa -arch x86_64 -keyring /Users/DA/.eclipse_keyring -showlocation

!ENTRY org.eclipse.core.net 1 0 2014-02-05 19:34:05.729
!MESSAGE System property http.nonProxyHosts has been set to local|*.local|169.254/16|*.169.254/16 by an external source. This value will be overwritten using the values from the preferences
!SESSION 2014-02-05 19:39:14.775 -----------------------------------------------
eclipse.buildId=unknown
java.version=1.6.0_65
java.vendor=Apple Inc.
BootLoader constants: OS=macosx, ARCH=x86_64, WS=cocoa, NL=en_US
Framework arguments:  -keyring /Users/DA/.eclipse_keyring -showlocation
Command-line arguments:  -os macosx -ws cocoa -arch x86_64 -keyring /Users/DA/.eclipse_keyring -showlocation

!ENTRY org.eclipse.core.net 1 0 2014-02-05 19:39:17.760
!MESSAGE System property http.nonProxyHosts has been set to local|*.local|169.254/16|*.169.254/16 by an external source. This value will be overwritten using the values from the preferences
!SESSION 2014-02-07 07:22:14.777 -----------------------------------------------
eclipse.buildId=unknown
java.version=1.6.0_65
java.vendor=Apple Inc.
BootLoader constants: OS=macosx, ARCH=x86_64, WS=cocoa, NL=en_US
Framework arguments:  -keyring /Users/DA/.eclipse_keyring -showlocation
Command-line arguments:  -os macosx -ws cocoa -arch x86_64 -keyring /Users/DA/.eclipse_keyring -showlocation

!ENTRY org.eclipse.core.net 1 0 2014-02-07 07:22:16.168
!MESSAGE System property http.nonProxyHosts has been set to local|*.local|169.254/16|*.169.254/16 by an external source. This value will be overwritten using the values from the preferences

Davids-MacBook-Pro:Knime_batch DA$ /Applications/knime/knime.app/Contents/MacOS/knime -nosplash -application org.knime.product.KNIME_BATCH_APPLICATION -workflowFile=/Applications/knime/workspace/Knime_batch/workflow.knime

INFO      main BatchExecutor     ===== Executing workflow /Applications/knime/workspace/Knime_batch/workflow.knime =====

ERROR     main BatchExecutor     IO error while loading the workflow

INFO      main BatchExecutor     ========= Workflow did not execute sucessfully ============

The -workflowFile argument is for reading zipped workflows. If you have the workflow in a directory use -workflowDir.

Thor - that was it!!!!!  Sorry I missed that to begin with and thanks for your help!

 

David

i met the same problem,copy!

Andy,

Solved by the steps below, isn't it?

Cheers
E