Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Deadlock when trying to follow Combination Lookup/Update by an Insert/Update?

  1. #1

    Question Deadlock when trying to follow Combination Lookup/Update by an Insert/Update?

    I need to use one step to find/create an item's unique identifier, then use the Insert/Update to set some other values that are not part of the unique key.

    This results in a deadlock, probably because all steps run in parallel.

    What's the correct way to do this? The main problem is that the Combination Lookup/Update requires to specify only "key fields" but the values I want to update are not all keys.

    Thanks

  2. #2
    Join Date
    Nov 2008
    Posts
    777

    Default

    It seems to me you should be using the Dimension Lookup/Update step instead. That one has many options for updating the non-key fields.
    pdi-ce-4.4.0-stable
    Java 1.7 (64 bit)
    MySQL 5.6 (64 bit)
    Windows 7 (64 bit)

Tags for this Thread

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.