Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Dimension Insert/Update Write Failure

  1. #1
    Join Date
    Jun 2007
    Posts
    26

    Default Dimension Insert/Update Write Failure

    Lookups work fine.
    Compares work fine.
    Inserts work fine.
    Updates work fine, but…
    …the Dimension Insert/Update fails when attempting to write the row to the stream after the update. At least I believe that is what’s happening because the step reads 1709 rows from the previous step, inputs 1709 rows from the dimension table, but writes only 1708 rows. Can anyone see what I might be doing wrong? The log is attached. Thanks.
    Attached Files Attached Files

  2. #2
    Join Date
    Jun 2007
    Posts
    26

    Default Problem went away by unchecking 'lazy conversion'.

    I guess the transformation changed the size of the row when it tried to lazy convert a string. In one case it was a string to string(10). In another it was a string to string(1). Jim Snyder

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

    Default

    There is little point in enabling lazy conversion (on the contrary) if you are using databases.

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.