Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Can only move data with 495 rows?

  1. #1
    Join Date
    Sep 2007
    Posts
    19

    Default Can only move data with 495 rows?

    I tried to move data from Access to Postgres,
    only 495 rows could be moved.
    Any setting in the codes?

    Thanks.
    Hannah

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

    Default

    no.... exception?... or is it the one in the other thread.
    Sven

  3. #3
    Join Date
    Sep 2007
    Posts
    19

    Default

    The running log is as follows.

    2007/09/26 14:20:56 - Spoon - Transformation opened.
    2007/09/26 14:20:56 - Spoon - Launching transformation [Access2Postgres1]...
    2007/09/26 14:20:56 - Spoon - Started the transformation execution.
    2007/09/26 14:20:56 - Access2Postgres1 - Dispatching started for transformation [Access2Postgres1]
    2007/09/26 14:20:56 - Access2Postgres1 - Nr of arguments detected:10
    2007/09/26 14:20:56 - Access2Postgres1 - This is not a replay transformation
    2007/09/26 14:20:56 - Access2Postgres1 - This transformation can be replayed with replay date: 2007/09/26 14:20:56
    2007/09/26 14:20:56 - Access2Postgres1 - Initialising 2 steps...
    2007/09/26 14:20:56 - Table output.0 - Connected to database [postpres] (commit=100)
    2007/09/26 14:20:56 - Access Input.0 - Starting to run...
    2007/09/26 14:20:56 - Access Input.0 - Opening file: file:///D:/db1.mdb
    2007/09/26 14:20:56 - Table output.0 - Starting to run...
    2007/09/26 14:20:58 - Access Input.0 - ERROR (version 2.5.1, build 2 from 2007/08/24 16:29:34) : Couldn't open file #0 : file:///D:/db1.mdb --> be.ibridge.kettle.core.exception.KettleValueException:
    2007/09/26 14:20:58 - Access Input.0 - ERROR (version 2.5.1, build 2 from 2007/08/24 16:29:34) : Couldn't convert string to number java.text.ParseException: Unparseable number: "Z43107"
    2007/09/26 14:20:58 - Access Input.0 - Finished processing (I=0, O=0, R=0, W=495, U=0, E=1)
    2007/09/26 14:20:58 - Table output.0 - Finished processing (I=0, O=495, R=495, W=0, U=0, E=0)
    2007/09/26 14:20:58 - Spoon - The transformation has finished!!

    Quote Originally Posted by sboden View Post
    no.... exception?... or is it the one in the other thread.
    Sven

  4. #4

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.