Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Ms Access Output

  1. #1

    Default Ms Access Output

    Hi all,

    I've tried to use the Ms Access Output step starting from a SAP input Table (ProSAPCONN add-in).
    I've tried to create a new MDB and a new TABLE from Kettle but I've had some problems (see following log 1). It seems that Kettle create a new MDB and a new table but it remains empty (only the columns names).
    What's the problem ?
    Many thanks
    Giovanni


    1) log
    2007/04/30 13:57:14 - Access Output.0 - ERROR (version 2.4.0, build 742 from 2007/01/27 12:29:00) : Unexpected error : java.lang.ArithmeticException: Rounding necessary
    2007/04/30 13:57:14 - Access Output.0 - ERROR (version 2.4.0, build 742 from 2007/01/27 12:29:00) : java.lang.ArithmeticException: Rounding necessary
    2007/04/30 13:57:14 - Access Output.0 - ERROR (version 2.4.0, build 742 from 2007/01/27 12:29:00) : at java.math.BigDecimal.divide(Unknown Source)
    2007/04/30 13:57:14 - Access Output.0 - ERROR (version 2.4.0, build 742 from 2007/01/27 12:29:00) : at java.math.BigDecimal.setScale(Unknown Source)
    2007/04/30 13:57:14 - Access Output.0 - ERROR (version 2.4.0, build 742 from 2007/01/27 12:29:00) : at java.math.BigDecimal.setScale(Unknown Source)
    2007/04/30 13:57:14 - Access Output.0 - ERROR (version 2.4.0, build 742 from 2007/01/27 12:29:00) : at com.healthmarketscience.jackcess.Column.writeNumericValue(Column.java:460)
    2007/04/30 13:57:14 - Access Output.0 - ERROR (version 2.4.0, build 742 from 2007/01/27 12:29:00) : at com.healthmarketscience.jackcess.Column.write(Column.java:679)
    2007/04/30 13:57:14 - Access Output.0 - ERROR (version 2.4.0, build 742 from 2007/01/27 12:29:00) : at com.healthmarketscience.jackcess.Column.write(Column.java:624)
    2007/04/30 13:57:14 - Access Output.0 - ERROR (version 2.4.0, build 742 from 2007/01/27 12:29:00) : at com.healthmarketscience.jackcess.Table.createRow(Table.java:547)
    2007/04/30 13:57:14 - Access Output.0 - ERROR (version 2.4.0, build 742 from 2007/01/27 12:29:00) : at com.healthmarketscience.jackcess.Table.addRows(Table.java:435)
    2007/04/30 13:57:14 - Access Output.0 - ERROR (version 2.4.0, build 742 from 2007/01/27 12:29:00) : at be.ibridge.kettle.trans.step.accessoutput.AccessOutput.writeToTable(AccessOutput.java:147)
    2007/04/30 13:57:14 - Access Output.0 - ERROR (version 2.4.0, build 742 from 2007/01/27 12:29:00) : at be.ibridge.kettle.trans.step.accessoutput.AccessOutput.processRow(AccessOutput.java:71)
    2007/04/30 13:57:14 - Access Output.0 - ERROR (version 2.4.0, build 742 from 2007/01/27 12:29:00) : at be.ibridge.kettle.trans.step.accessoutput.AccessOutput.run(AccessOutput.java:244)
    2007/04/30 13:57:14 - be.ibridge.kettle.trans.Trans - ERROR (version 2.4.0, build 742 from 2007/01/27 12:29:00) : Errors detected!
    2007/04/30 13:57:14 - be.ibridge.kettle.trans.Trans - Looking at step: S012
    2007/04/30 13:57:14 - S012.0 - Finished, processing 851 rows
    2007/04/30 13:57:14 - be.ibridge.kettle.trans.Trans - Looking at step: Access Output
    2007/04/30 13:57:14 - Spoon - The transformation has finished!!

  2. #2
    Join Date
    Nov 1999
    Posts
    459

    Default

    Hi Giovanni,

    you get the error "Rounding necessary" - so it seems the Access Output can not handle the big decimal (BigNumber) in a correct way.

    Try to convert the BigNumber to Number by Calculator or JavaScript step.

    Cheers,
    Jens

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.