Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Use of SQL query and dimension lookup/update together

  1. #1
    Join Date
    May 2008
    Posts
    232

    Default Use of SQL query and dimension lookup/update together

    hi all....

    In my transformation i want to use both sql query and dimension lookup / update.. sql query for updating the rows and dimension lookup/update for the insert due to the requirements. But this combination is creating problem and giving error after running for long time, like" Lock wait timeout exceeded; try restarting transaction"
    What exactely this error means.??
    Is this combination is not applicable in kettle , due to some technical issues???
    Please help....

    Thanks in advance

  2. #2

    Default

    Hi meenaiyer,

    I did work that similar to your case. in my case,
    DMBS is Oracle and PDI's version is 3.1 RC1.

    I try it using Combination lookup/update and Update step.
    first time, I got a wired error. I think its a transaction problem. so, I enabled 'unique connection' on transformation' configuration.
    after that, it works as I would expected.

    please see wiki doc, http://wiki.pentaho.com/display/EAI/...+lookup-update

    Regards,
    yw kim.

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.