AnsweredAssumed Answered

Weird issue with MonetDB latest release and PDI 8

Question asked by Gilles Simler on Mar 30, 2018
Latest reply on Mar 30, 2018 by Gilles Simler

I have a simple table input (Oracle 12G) moving data to a MonetDB table for some analytics work. The transformation is OK for 2M+ rows and then I get an EOS error. I identified the row causing the problem but there is absolutely nothing wrong with it in the source and should go straight through. I even isolated the row and tried to load it on its own and the same error occur. Any idea what could be causing the issue?

 

I am using MonetDB Jul 2017 SP4 release and Pentaho 8.

 

Thanks!

 

Here is the specific error message from the log:

 

2018/03/30 12:01:37 - monetdb.0 - ERROR (version 8.0.0.0-28, build 8.0.0.0-28 from 2017-11-05 07.27.50 by buildguy) : Error in step, asking everyone to stop because of:

2018/03/30 12:01:37 - monetdb.0 - ERROR (version 8.0.0.0-28, build 8.0.0.0-28 from 2017-11-05 07.27.50 by buildguy) : org.pentaho.di.core.exception.KettleException:

2018/03/30 12:01:37 - monetdb.0 - An error occurred writing data to the MonetDB API (MAPI) process

2018/03/30 12:01:37 - monetdb.0 -

2018/03/30 12:01:37 - monetdb.0 - Error loading data: 22000!Failed to import table 'FRC', record too long (EOS found)

25005!current transaction is aborted (please ROLLBACK)

2018/03/30 12:01:37 - monetdb.0 -

2018/03/30 12:01:37 - monetdb.0 -

2018/03/30 12:01:37 - monetdb.0 -     at org.pentaho.di.trans.steps.monetdbbulkloader.MonetDBBulkLoader.writeBufferToMonetDB(MonetDBBulkLoader.java:531)

2018/03/30 12:01:37 - monetdb.0 -     at org.pentaho.di.trans.steps.monetdbbulkloader.MonetDBBulkLoader.processRow(MonetDBBulkLoader.java:182)

2018/03/30 12:01:37 - monetdb.0 -     at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)

2018/03/30 12:01:37 - monetdb.0 -     at java.lang.Thread.run(Thread.java:748)

2018/03/30 12:01:37 - monetdb.0 - Caused by: org.pentaho.di.core.exception.KettleException:

2018/03/30 12:01:37 - monetdb.0 - Error loading data: 22000!Failed to import table 'FRC', record too long (EOS found)

25005!current transaction is aborted (please ROLLBACK)

2018/03/30 12:01:37 - monetdb.0 -

2018/03/30 12:01:37 - monetdb.0 -     at org.pentaho.di.trans.steps.monetdbbulkloader.MonetDBBulkLoader.writeBufferToMonetDB(MonetDBBulkLoader.java:509)

Outcomes