Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Unexpected conversion error on Excel Writer

  1. #1
    Join Date
    Feb 2011
    Posts
    840

    Default Unexpected conversion error on Excel Writer

    I'm guessing Slawo will be the best to solve this one =p

    Whole transformation runs normal, without any problems at all... it ends on a sort rows, followed by Excel Writer. If I disable this final hop and try to preview on Sort Rows, I get an error without any messages. If I just run, final hop still disabled, no errors. If I enable the final hop and try to run, Excel Writer gives me this error:
    Code:
    Microsoft Excel Writer 2 4.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : Error writing field (14,10734) : org.pentaho.di.core.exception.KettleValueException: 
    Microsoft Excel Writer 2 4.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : Unexpected conversion error while converting value [MARGEM_CONTRIBUICAO Number(15)] to a Number
    Microsoft Excel Writer 2 4.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : java.math.BigDecimal cannot be cast to java.lang.Double
    Microsoft Excel Writer 2 4.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : org.pentaho.di.core.exception.KettleValueException: 
    Microsoft Excel Writer 2 4.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : Unexpected conversion error while converting value [MARGEM_CONTRIBUICAO Number(15)] to a Number
    Microsoft Excel Writer 2 4.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : java.math.BigDecimal cannot be cast to java.lang.Double
    Microsoft Excel Writer 2 4.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : 
    Microsoft Excel Writer 2 4.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : 	at org.pentaho.di.core.row.ValueMeta.getNumber(ValueMeta.java:1451)
    Microsoft Excel Writer 2 4.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : 	at org.pentaho.di.trans.steps.excelwriter.ExcelWriterStep.writeField(ExcelWriterStep.java:510)
    Microsoft Excel Writer 2 4.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : 	at org.pentaho.di.trans.steps.excelwriter.ExcelWriterStep.writeNextLine(ExcelWriterStep.java:292)
    Microsoft Excel Writer 2 4.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : 	at org.pentaho.di.trans.steps.excelwriter.ExcelWriterStep.processRow(ExcelWriterStep.java:153)
    Microsoft Excel Writer 2 4.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : 	at org.pentaho.di.trans.step.RunThread.run(RunThread.java:50)
    Microsoft Excel Writer 2 4.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : 	at java.lang.Thread.run(Unknown Source)
    Microsoft Excel Writer 2 4.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : Caused by: java.lang.ClassCastException: java.math.BigDecimal cannot be cast to java.lang.Double
    Microsoft Excel Writer 2 4.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : 	at org.pentaho.di.core.row.ValueMeta.getNumber(ValueMeta.java:1396)
    Microsoft Excel Writer 2 4.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : 	... 5 more
    Join us on IRC! =)

    Twitter / Google+ / Timezone: BRT-BRST
    BI Server & PDI 5.4 / MS SQL 2012 / Learning CDE & CTools
    Windows 8 64-bit / Java 7 (jdk1.8.0_75)

    Quote Originally Posted by gutlez
    PLEASE NOTE: No forum member is going to do your work for you. We will help you sort out how to do a specific part of the work, as best we can, in the timelines that our work will allow us.

    I'm no expert.Take my comments at your own risk.

  2. #2
    Join Date
    Feb 2011
    Posts
    840

    Default

    well, I circumvented the problem by using Select Values on a couple parts of the transformation to make sure everything was the way I wanted... weird still.
    Join us on IRC! =)

    Twitter / Google+ / Timezone: BRT-BRST
    BI Server & PDI 5.4 / MS SQL 2012 / Learning CDE & CTools
    Windows 8 64-bit / Java 7 (jdk1.8.0_75)

    Quote Originally Posted by gutlez
    PLEASE NOTE: No forum member is going to do your work for you. We will help you sort out how to do a specific part of the work, as best we can, in the timelines that our work will allow us.

    I'm no expert.Take my comments at your own risk.

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.