KNIME 2.11: Database looping nodes fails with input empty table

KNIME Analytics Platform
1

After updat to knime 2.11 database looping nodes fails with error

Execute failed: ("ArrayIndexOutOfBoundsException"): 1

on empty input tables. This used to work in Knime 2.10 without issue.

 

 

2

Thanks for reporting this bug. Will be fixed in 2.11.1. 

3

I just tested 2.11.1 and the issue is still there albeit the error now is different:

ERROR     Database Looping                   Execute failed: Could not determine table spec from database query: No settings available to create database connection.

 

The change log also says:

Bug 5868: Database Looping throws NullPointerException if no DB-Connection is provided

However the issue is an empty table as input not a missing connection.

 

4

Hi,

I just tried to reproduce the problem but couldn't. Please see the attached workflow with a Database Looping node that has an empty data table as input but does not fail. Could you give us some more information or maybe an example flow that shows the error.

Thanks

Tobias

5

The databse is oracle. I just created the most basic example and issue is the same there:

1 Database Connector

1 Table Creator with 1 column and 0 rows

1 Database looping node

ERROR     Database Looping                   Execute failed: Could not determine table spec from database query: No settings available to create database connection.

 

 

 

6

Hi,

I will have a look at the problem and see if I can reproduce it with our Oracle db and get back to you as soon as possible.

Tobias

7

Hi,

I could reproduce the problem now. If the node has been executed once with some input rows it also works with empty input tables since the output table specification is cached. However if the node is executed with an empty table it fails. We will have a look if we can fix that with the next release.

We are sorry for any inconveniences this problem causes you.

Bye,

Tobias

8

Thanks for your support and effort. Lookign forward to new release.

9

Hi,

we have just released KNIME 2.11.2 which should fix the problem. To update KNIME go to File->Update KNIME...

You might need to restard KNIME once since eclipse caches the update sites.

Please let me know if the problem is fixed.

Thanks for your patience,

Tobias

10

Works fine know.

Thank you.

11