CODEWITHSUNDEEP
postgresqlpentahokettle
andrepcg
andrepcg

Reputation: 1331

Pentaho Kettle PostgreSQL bulk loader error - Can not find target table

I'm trying to setup PostgreSQL Bulk Loader in Kettle but I'm getting the following error:

Caused by: org.pentaho.di.core.exception.KettleException: 
We can not find target table 

    at org.pentaho.di.trans.steps.pgbulkloader.PGBulkLoaderMeta.getRequiredFields(PGBulkLoaderMeta.java:618)

I can browse the database in the GUI, and the table I'm trying to insert to is there. How can I solve this?

Upvotes: 0

Views: 917

Answers (1)

Wolph
Wolph

Reputation: 80011

I had the same issue and after looking at the Postgres logs the problem is rather obvious.

Apparently the "PostgreSQL bulk loader" doesn't properly use the defined connection and uses a hardcoded postgres user when connecting.

So to make it work, make sure you connect using the postgres user and not any random other user.

This is most certainly a bug in Pentaho Kettle (perhaps even Spoon) but I've not been able to quickly identify the issue in the source so I'm simply working around the issue for the time being.

Upvotes: 1

Related Questions