I’m a new user to KNIME but understand it should be able to read files well over 1million rows.
I’ve connected to an MS Access DB but the database reader fails with the following error:Execute failed: UCAExc:::4.0.4 java.lang.OutOfMemoryError: GC overhead limit exceeded
The table has 1,511,169 rows and 13 columns
I’ve been searching the forum for help on this but can’t find a solution. Please help!
Hi there!
I have read more than 30 million of rows so 1 million shouldn’t be a problem. Although it was from Oracle and PostgreSQL databases. More on this error if you have found it: https://stackoverflow.com/questions/1393486/error-java-lang-outofmemoryerror-gc-overhead-limit-exceeded
What is your environment like? I mean KNIME version, OS, what database integration are you using (from KNIME labs or not), database node upon which you get error, workflow design, is your database on same computer…
Br,
Ivan
Hello @AbiG -
Have you tried increasing the amount of memory available to KNIME via the knime.ini file? More info here: https://www.knime.com/faq#q4_2