Postgresql bulk loader never stops if input rows are empty (v 9.4)

Adam Marhefka

unread,

Mar 19, 2023, 12:48:39 PM3/19/23

to Pentaho Community

Hello,

I upgraded from PDI v6 to PDI v9.4 and in my transformation where i take data from one database using the step "Table input" and load them into another database using the step "PostgreSQL Bulk Loader" I encounter an error if the select in "Table input" returns 0 rows. If that happens, the transformation never finishes. I also tried to run this transformation using the kettle API in my Java program and the same thing happens. The program (transformation) never finishes and an NullPointerException is thrown in PGBulkLoader class.

If anybody encountered this error, how could i fix this please? Thank you in advance!

Adam

Adam Marhefka

unread,

Mar 19, 2023, 12:49:50 PM3/19/23

to Pentaho Community

Oh and just to clarify, i never had this problem on older version (v6) and i tried and the v9.3 works as well. I downloaded the PDI from the official Hitachi Vantara sites.

Adam

Dátum: nedeľa 19. marca 2023, čas: 17:48:39 UTC+1, odosielateľ: Adam Marhefka

Adam Marhefka

unread,

Apr 3, 2023, 6:10:03 AM4/3/23

to Pentaho Community

The solution is to get these updated classes from: https://github.com/pentaho/pentaho-kettle/pull/8791

You can recompile it yourself or the kind man there posted the new .jar file which you can replace in your /plugin folder.

Dátum: nedeľa 19. marca 2023, čas: 17:49:50 UTC+1, odosielateľ: Adam Marhefka

Reply all

Reply to author

Forward