Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Unexpected conversion error

  1. #1
    Join Date
    Jan 2008
    Posts
    17

    Default Unexpected conversion error

    Hello !

    I migrate my 241-M1 repository in 304.

    I get this error message :

    2008/08/22 16:55:01 - Add dealers extracted.0 - ERROR (version 3.0.4, build 54 from 2008/06/27 10:23:40) : Unexpected error :
    2008/08/22 16:55:01 - Add dealers extracted.0 - ERROR (version 3.0.4, build 54 from 2008/06/27 10:23:40) : org.pentaho.di.core.exception.KettleValueException:
    2008/08/22 16:55:01 - Add dealers extracted.0 - ERROR (version 3.0.4, build 54 from 2008/06/27 10:23:40) : Unexpected conversion error while converting value [result String] to an Integer
    2008/08/22 16:55:01 - Add dealers extracted.0 - ERROR (version 3.0.4, build 54 from 2008/06/27 10:23:40) : java.lang.Long
    2008/08/22 16:55:01 - Add dealers extracted.0 - ERROR (version 3.0.4, build 54 from 2008/06/27 10:23:40) :
    2008/08/22 16:55:01 - Add dealers extracted.0 - ERROR (version 3.0.4, build 54 from 2008/06/27 10:23:40) : at org.pentaho.di.core.row.ValueMeta.getInteger(ValueMeta.java:1458)
    2008/08/22 16:55:01 - Add dealers extracted.0 - ERROR (version 3.0.4, build 54 from 2008/06/27 10:23:40) : at org.pentaho.di.core.row.ValueMeta.convertData(ValueMeta.java:2985)
    2008/08/22 16:55:01 - Add dealers extracted.0 - ERROR (version 3.0.4, build 54 from 2008/06/27 10:23:40) : at org.pentaho.di.trans.steps.calculator.Calculator.calcFields(Calculator.java:421)
    2008/08/22 16:55:01 - Add dealers extracted.0 - ERROR (version 3.0.4, build 54 from 2008/06/27 10:23:40) : at org.pentaho.di.trans.steps.calculator.Calculator.processRow(Calculator.java:162)
    2008/08/22 16:55:01 - Add dealers extracted.0 - ERROR (version 3.0.4, build 54 from 2008/06/27 10:23:40) : at org.pentaho.di.trans.steps.calculator.Calculator.run(Calculator.java:453)
    2008/08/22 16:55:01 - Add dealers extracted.0 - ERROR (version 3.0.4, build 54 from 2008/06/27 10:23:40) : Caused by: java.lang.ClassCastException: java.lang.Long
    2008/08/22 16:55:01 - Add dealers extracted.0 - ERROR (version 3.0.4, build 54 from 2008/06/27 10:23:40) : at org.pentaho.di.core.row.ValueMeta.getInteger(ValueMeta.java:1411)
    2008/08/22 16:55:01 - Add dealers extracted.0 - ERROR (version 3.0.4, build 54 from 2008/06/27 10:23:40) : ... 4 more
    2008/08/22 16:55:01 - SICAR ODS - Statement canceled!


    If someone has an idea how to solve this issue, thanks to help me.

    Lfa

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

    Default

    Laurence, the upgrade procedure is to dump your repository to XML and then upload it into a new one.
    That way, you always have a backup in case anything goes wrong.
    Besides that, I think it wasn't very wise to run with a development release for so long before finally upgrading.

    This issue I think is caused by a space before the integer values somewhere.
    Check out the repository table R_STEP_ATTRIBUTE and see if you see any integers with spaces before them over there.

    All the best,
    Matt

  3. #3
    Join Date
    Jan 2008
    Posts
    17

    Default

    Hello Matt,

    Thank you for your reply.
    I am totally agreed with you about the risk to run with a development release for so long before finally upgrading.
    The problem is our ETL was developed by an external company...
    Now, because I know there is a risk not upgraded, I try to do it. I am a functional project manager and not at all an expert in sql java eg.

    So I proceeded as you advised me with a dump and I upgrade the repository.

    The issue was not solved but I checked the transformations and check the data format and find sometimes 2 different format so I add a select value to define the format, eg... I solved a lot of issues and now I continue my tests.

    Best regards

    Laurence

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.