Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Data Type error

  1. #1
    Join Date
    Oct 2011
    Posts
    2

    Default Data Type error

    Hi,

    I am getting the following error;
    "There was a data type error: the data type of java.lang.String object [80fc641ab50501415947641f66f3fab5adeb9bc5068959fea70a3fa8388582ae] does not correspond to value meta [Integer(9)]"

    I have searched the forum and found that this can be due to lazy conversion but mine is set to N in the file. I am running kettle version 4.2 against an MS Sql Server database. I have attached the exception and the relevant ktr file. Does anyone know what I can do to further debug the issue?

    Any help is appreciated.
    -Eric
    Attached Files Attached Files

  2. #2
    Join Date
    Sep 2009
    Posts
    810

    Default

    Hey eweise,

    judging from the log I would guess that field 4 (SOURCEADDRESS) may not be consistent on all selects. I would first try to check if the fourth field of T_COMPLETEMESSAGE_TMP is consistent with the other queries.

    Second idea is to CAST(NULL as SOME_STRING_TYPE_YOUR_DB_SUPPORTS) on the queries that give a NULL constant. The DB Server has no clue what type to return the NULL as otherwise. It may choose INTEGER by default whereas the other queries return CHARS for that field.

    In other words: check the output fields of each table input and make sure they return equal field types It's easiest to select "Show output fields" from the context menu of a step. If you're lazy you can just select the step and press space

    Cheers
    Slawo
    Last edited by slawomir.chodnicki; 10-11-2011 at 04:46 PM.

  3. #3
    Join Date
    Oct 2011
    Posts
    2

    Default

    Thanks for the response Slawo. Both are good leads to go on. This problem is intermittent so maybe the null is the issue if somehow Kettle can't figure out the correct data type.

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.