Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: kettle trying to varchar to varchar kettle trying to change to number

  1. #1
    Join Date
    Jul 2009
    Posts
    1

    Default kettle trying to varchar to varchar kettle trying to change to number

    Hi,
    I have a varchar field mapping to a varchar field. However I can not get my transformation to run.

    I can't figure out why Kettle wants to try to change my field into a date, when it is character data, not a date field. both the source and target are varchar...

    P.S. there are no date fields in the mapping, I stripped it down to just 2 varchar fields.

    Any help would be greatly appreciated.
    Thanks,

    I get a java exception:

    Unexpected error :
    2009/07/06 12:50:58 - HSSF tblInvoice.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : java.lang.ClassCastException: java.lang.String cannot be cast to java.lang.Number
    2009/07/06 12:50:58 - HSSF tblInvoice.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at com.healthmarketscience.jackcess.Column.writeDateValue(Column.java:692)
    2009/07/06 12:50:58 - HSSF tblInvoice.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at com.healthmarketscience.jackcess.Column.writeFixedLengthField(Column.java:1046)
    2009/07/06 12:50:58 - HSSF tblInvoice.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at com.healthmarketscience.jackcess.Column.write(Column.java:950)

  2. #2
    Join Date
    Apr 2008
    Posts
    4,696

    Default

    With none of:
    1) The source DB
    2) The tranformation file
    3) The destination DB

    We can only really guess.

    I would expect that either the input or the output schema is not declared through jackcess the way you expect it to.

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.