Database Table Reader: Maximum number of columns?

Hey there,

I want to read a table from an Oracle database using the Database Connection Table Reader which gives me a NullPointerException. Since it’s a very large table with lots of columns, I tried to reduce the number of columns and found the reader being able to read about 192 columns in total, but not more. Is there a limitation? Or can anyone help with the exception?

Thanks in advance

Problem solved


Could you please share what was the cause of problem?

I use the Dknime.database.fetchsize parameter in my Knime.ini for faster reading Data from Database.

The fetch size of 1000000 was too high. It worked for many rows and a few columns. I reduced the size on 100000 and the problem was solved.

Thank you for sharing.