Hitachi Vantara Pentaho Community Forums
Results 1 to 1 of 1

Thread: Kettle, sql server and deadlock

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Join Date
    May 2006
    Posts
    167

    Default Kettle, sql server and deadlock

    Hi,
    after a migration from postgres to sqlserver 2005, some very complex transformations and job made with PDI/kettle (5.0.1) receive a
    SQLServerException: Transaction aborted due to Deadlock.
    That exception, so far, happens in a very precise point of my transformation.

    Maybe some users, more experienced than me, may help. I would appreciate.

    My questions are:
    - some of you had this kind of exception?
    - is that solvable from PDI side or from sql server side?
    - some posts on the net talk about a TRANSACTION ISOLATION LEVEL parameter to use in transact sql, but I really can't figure out where it should be use inside spoon (maybe you know)
    - is there a way to control the transaction status inside a job/transf and force to commit after finishing the job/transf?

    Thank you in advance.
    Best regards,
    Nico
    Last edited by nico.ben; 05-17-2014 at 01:32 PM.

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.