Error in batch mode

KNIME Analytics Platform
, ,
1

Hi team!

I am currently running Knime in batch mode. I have some code trying to automatize some flows. Almost all my flows are working properly in this way.

This is the batch code:
knime “-reset”, “–launcher.suppressErrors”,“-nosplash”, “-nosave”, “-application”, “org.knime.product.KNIME_BATCH_APPLICATION”, “-workflowFile=” + flow_file

I have some flows that generate error with the excecution in batch mode but when I try to replicate it in the same computer with the UI knime, the flows don’t fail.

An usual error is related to a “DB Writer” that shows “the table doesn’t exist” but the db writer has marked the “Remove existing table” so I’m sure that anything else has the fault about this issue :(.

Why can be happening this? Any ideas?

2

Hi @sahernandezg,

is there a chance that the authentication isn’t working properly? Usually, when executing in batch mode, you reset the entire workflow. That’s also why there is the -reset flag set.

You might want to try to read the user and pw to authenticate in a more dynamic fashion.

PS: Thanks to the great article from @mlauber71 I noticed that you’ve got to pass the credentials

-credential =id:login:password: Allows specifying credentials for database connections or other nodes requiring authentication. The id corresponds to the credential variable used in the workflow.

Best
Mike

1 Like