Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Dimension lookup/update problem

  1. #1
    Join Date
    Sep 2012
    Posts
    1

    Default Dimension lookup/update problem

    Hi all,

    I'm on Oracle 11g and PDI version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy.
    I'm fighting with "Dimension lookup/update" not willing to work and constantly giving me errors such as
    2012/09/04 15:58:59 - Dimension lookup/update.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : Because of an error this step can't continue:
    2012/09/04 15:58:59 - Dimension lookup/update.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : CARD_ID BigNumber(20) : There was a data type error: the data type of java.lang.Long object [15493] does not correspond to value meta [BigNumber(20)]
    I'm getting these errors every time when there are changed rows in dimension.

    Help me make it work please...

    Thank you!

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

    Default

    It's caused by a caching bug that I think was fixed in the upcoming new release.
    The reason is the use of a very long data type on the database side (usually Oracle NUMBER(20) or something silly like that).

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.