Problem to start a Workflow via batch file | Windows 10

[USCHUKN1ME]

I also have the problem to start a workflowfrom KNIME with a batch
file.

(It is a test for my bigger problem: https://forum.knime.com/t/start-a-workflow-e-g-a-database-query-after-a-certain-time/30287/29

My BAT-file:

Command line
“C:\Program Files\KNIME\knime.exe” -consoleLog -nosplash -reset -application org.knime.product.KNIME_BATCH_APPLICATION -workflowDir=“C:\Users\schuerrle\knime-workspace\Example Workflows\isoloc-US”

The batch file should start this simple test workflow:

Folder of the two Excel files to be linked

CompilerOracle: exclude javax/swing/text/GlyphView.getBreakSpot
Feb 10, 2021 1:52:22 PM org.apache.cxf.bus.osgi.CXFExtensionBundleListener addExtensions
INFORMATION: Adding the extensions from bundle org.apache.cxf.cxf-rt-frontend-jaxrs (255) [org.apache.cxf.jaxrs.JAXRSBindingFactory]
Feb 10, 2021 1:52:22 PM org.apache.cxf.bus.osgi.CXFExtensionBundleListener addExtensions
INFORMATION: Adding the extensions from bundle org.apache.cxf.cxf-rt-transports-http (258) [org.apache.cxf.transport.http.HTTPTransportFactory, org.apache.cxf.transport.http.HTTPWSDLExtensionLoader, org.apache.cxf.transport.http.policy.HTTPClientAssertionBuilder, org.apache.cxf.transport.http.policy.HTTPServerAssertionBuilder, org.apache.cxf.transport.http.policy.NoOpPolicyInterceptorProvider]
Feb 10, 2021 1:52:22 PM org.apache.cxf.bus.osgi.CXFExtensionBundleListener addExtensions
INFORMATION: Adding the extensions from bundle org.apache.cxf.cxf-rt-transports-http-hc (259) [org.apache.cxf.transport.http.HTTPConduitFactory, org.apache.cxf.transport.ConduitInitiator]
Feb 10, 2021 1:52:24 PM com.inteligand.knime.KNIMEIlibInterface printInfo
INFO: Initializing LigandScout KNIME extensions in headless mode on ‘Windows Vista or Higher [amd64]’:

•    Logging turned on (severe errors only)  Max heap memory: 15GB.*
  

•    Application path: C:\Program Files\KNIME\plugins\com.inteligand.knime_1.7.9\ligandscout\bin.*
  

•    Native-lib path: C:\Program Files\KNIME\plugins\com.inteligand.knime_1.7.9\ligandscout\lib\native.*
  

•    Native-bin path: C:\Program Files\KNIME\plugins\com.inteligand.knime_1.7.9\ligandscout\bin\native.*
  

•    Located ilib path: file:///C:/Users/schuerrle/.inteligand-data/.*
  

•    Using default shared path: file:///.*
  

Loading class com.mysql.jdbc.Driver'. This is deprecated. The new driver class is com.mysql.cj.jdbc.Driver’. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.
ERROR main MAEFileUtils Schrodinger Knime plugins: Neither SCHRODINGER environment nor preference is set. You can set SCHRODINGER installation location in the Schrodinger Preferences.
WARN main SchrodFileUtils SCHRODINGER is not set properly.
WARN main PythonService PythonService is not initilized
WARN main PythonService Failed to start python service.
…and more

[dpowyslybbe]

Can you share the workflow (or at least a sanitised version of it if any data is sensitive)? I can get Batch working on my PC, so I can at least confirm whether it’s a problem with the workflow or not.

[USCHUKN1ME]

@dpowyslybbe hello ,
i attached the workflow and the Excel-Files.

Thank you in advance.

greetings

VC-Q1_Umsätze.knwf (11.3 KB)
Q1-Umsatzvergleich 2019-2018 _Gebiet28.xlsx (15.8 KB) Q1-Umsatzvergleich 2020-2019 _Gebiet28.xlsx (14.6 KB)

[dpowyslybbe]

Hi, so I can’t replicate the error you were getting, but I have managed to get it to work.

On my first attempt it looked like the workflow had run correctly (ie. No errors) but it was not exporting the Excel file.

I then renamed the workflow to remove the umlaut and this worked.

FYI my batch script is as follows:

@echo off

echo %DATE% %TIME%

:: =====
:: 1- Run USCHUKN1ME’s workflow
:: =====

“C:\Program Files\KNIME\knime.exe”^
-consoleLog --launcher.suppressErrors -nosave -nosplash^
-application org.knime.product.KNIME_BATCH_APPLICATION^
-workflowDir=“D:/Users/30036941/Data/knime-workspace/_WiP/VC-Q1_Umsatze”

echo Just run USCHUKN1ME’s workflow %DATE% %TIME%

:: =====
:: 2- Play a beep sound to signify it’s complete
:: =====
echo a

pause

If all you do is repoint the script to wherever your KNIME.exe file is, and ensure the path to the VC-Q1_Umsatze is then hopefully this will work for you.

Good luck!

Dom

[USCHUKN1ME]

Hello @dpowyslybbe ,

thank you very much - yes it works .
Small cause big effect!

I have added the BAT file so that Excel starts immediately, as it is set in the EXCEL Writer Node.

Ok! STEP 1 finished!

Next Step .
I will start my bigger workflow >> Worklfow with a database connect

I will start a batch file which call this worklow above via Windows Task Scheduler at three times per day.

Do you think that is possible?

Thx in advance.

greetings

[Daniel_Weikert]

I don’t see issues but maybe the KNIME Team members like to add something important.

[FabianK]

Yes this is possible! I just read a LinkedIn posting about it.

Bob Peers on LinkedIn: 𝙎𝙘𝙝𝙚𝙙𝙪𝙡𝙞𝙣𝙜 𝙒𝙤𝙧𝙠𝙛𝙡𝙤𝙬𝙨 𝙐𝙨𝙞𝙣𝙜 𝙆𝙉𝙄𝙈𝙀 🕚🕒 | 14 comments

[dpowyslybbe]

Yes, completely possible. Just create a basic task in Task Scheduler to run the .bat file at whatever frequency you require.

[USCHUKN1ME]

@FabianK @dpowyslybbe

Thank your for the quick response

Another point is ticked off.

Now it is only necessary to call up and start my workflow with the database connection/database query with a batch file.

But I don’t know if that’s even possible.

It would have to start the DB connector to start the database connection or to start the database query. If the database connection is continuously open, to restart the subsequent database query (DB-Query-Node).

[USCHUKN1ME]

Crashed