Problem with DB transaction in inactive branch

[tttpham]

Hi all,

I’am using Knime analytics 4.2.3 and having a problem with DB transaction :

I use a DB transaction in a branch of a Case switch. When this branch is inactive, the workflow can not continue after that with :

InactiveBranchPortObjectSpec is invalid port type, DBSessionPortObjectSpec is required.

This Called workflow can demonstrate my problem.

Can someone tell me how to make it works correctly ?

Thanks in advanced,

Thanh Thanh

[tobias.koetter]

Hello,
thanks for reporting this problem. We will look into it.
Bye
Tobias

[mlauber71]

You could try to use a Try Catch configuration. This has the advantage that it would ‘tolerate’ an error. This example is for Hive database but should also work for other settings:

Hive - how to handle missing tables in Hive? – mlauber71

In this example first there is a check if a column is there and then one brach gets activated:

Skip DB table if a column is not there – mlauber71

Also a ‘simple’ if condition could work

Check if column is present and use if-switch accordingly – mlauber71

[ajc]

Hi @tobias.koetter any update for this one?

The issue is still present in 4.3.2.

[tobias.koetter]

Hi ajc,
the problem is fixed with KNIME Analytics Platform 4.4.0 which is available for download.
Bye
Tobias