Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: postgreSQL Bulk Loader problem

  1. #1
    Join Date
    Apr 2008
    Posts
    29

    Default postgreSQL Bulk Loader problem

    Hello;

    I am using spoon version 3.2 and trying to use PostgreSQL Bulk Loader.
    I believe I have set it up according to the information found on the wiki page dedicated to this step. When I run the transformation I am getting the following error:
    2009/06/25 09:20:20 - PostgreSQL Bulk Loader.0 - Executing command: C:\Sypherlink\DataMover-3_1_1\psql.exe -h ${TARGET_HOST} -p ${TARGET_PORT} -d SLStageDB_DevEnv01_Kansas
    2009/06/25 09:20:20 - PostgreSQL Bulk Loader.0 - Launching command: COPY "harm_stage"."temp_source_masternamealias" ( "masterno", "aliasdlstate", "aliasseqno", "aliasfirstname", "dlclass", "aliasmiddlename", "dlexpires", "aliasdob", "aliasssn", "aliasdlno", "aliassuffix", "aliaslastname", "aliasnametype" ) FROM STDIN WITH CSV DELIMITER AS ';' QUOTE AS '''';
    2009/06/25 09:20:20 - PostgreSQL Bulk Loader.0 - ERROR (version 3.1.1, build 826 from 2009/03/12 13:38:40) : Error in step
    2009/06/25 09:20:20 - PostgreSQL Bulk Loader.0 - ERROR (version 3.1.1, build 826 from 2009/03/12 13:38:40) : org.pentaho.di.core.exception.KettleException:
    2009/06/25 09:20:20 - PostgreSQL Bulk Loader.0 - ERROR (version 3.1.1, build 826 from 2009/03/12 13:38:40) : Error serializing rows of data to the psql command
    2009/06/25 09:20:20 - PostgreSQL Bulk Loader.0 - ERROR (version 3.1.1, build 826 from 2009/03/12 13:38:40) : The pipe is being closed

    What might cause this error?
    I used default delimiter and enclosure parameters.

    Thank you very much for your help.

  2. #2
    Join Date
    May 2006
    Posts
    4,882

    Default

    is psql in your path, properly installed, ...

    Regards,
    Sven

  3. #3
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    This is what I wrote on the subject way back when I wrote the plugin.

    http://wiki.pentaho.com/display/EAI/...QL+Bulk+Loader

    As you can see it's really painful for a third party application to use PostgreSQL.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.