Hitachi Vantara Pentaho Community Forums
Results 1 to 10 of 10

Thread: Unable to release database transaction savepoint in 4.2.1

  1. #1
    Join Date
    Mar 2012
    Posts
    15

    Default Unable to release database transaction savepoint in 4.2.1

    I've seen a number of earlier reports on this issue, but they all seem to indicate that this issue was fixed in 4.2. However, I am seeing this same problem in 4.2.0 and 4.2.1. Is this something that might not have actually gotten fixed?

    In particular, I have a transform with an Insert/Update that fails when there is error handling, but works fine without error handling set. This is connecting to SQL Server 2008 using the Native JDBC driver (4.0) under Windows 64 bit.

    Thanks for any suggestions.

    The error is:

    2012/03/23 22:03:32 - Synchronize.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : Because of an error, this step can't continue:
    2012/03/23 22:03:32 - Synchronize.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : org.pentaho.di.core.exception.KettleDatabaseException:
    2012/03/23 22:03:32 - Synchronize.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : Unable to release database transaction savepoint
    2012/03/23 22:03:32 - Synchronize.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : This operation is not supported.
    2012/03/23 22:03:32 - Synchronize.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) :
    2012/03/23 22:03:32 - Synchronize.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : at org.pentaho.di.core.database.Database.releaseSavepoint(Database.java:4831)
    2012/03/23 22:03:32 - Synchronize.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : at org.pentaho.di.trans.steps.synchronizeaftermerge.SynchronizeAfterMerge.lookupValues(SynchronizeAfterMerge.java:463)
    2012/03/23 22:03:32 - Synchronize.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : at org.pentaho.di.trans.steps.synchronizeaftermerge.SynchronizeAfterMerge.processRow(SynchronizeAfterMerge.java:870)
    2012/03/23 22:03:32 - Synchronize.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : at org.pentaho.di.trans.step.RunThread.run(RunThread.java:40)
    2012/03/23 22:03:32 - Synchronize.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : at java.lang.Thread.run(Thread.java:662)
    2012/03/23 22:03:32 - Synchronize.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: This operation is not supported.

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

    Default

    Can you use the jTDS driver instead?

  3. #3
    Join Date
    Mar 2012
    Posts
    15

    Default

    We will try that now. We probably would have even started with that a while ago, but with the MS driver being a type 4, we figured that would be the best one to use.

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

    Default

    Please let us know what happens with jTDS. I've seen one particular case where that solved this issue and a couple of others too.

  5. #5
    Join Date
    Mar 2012
    Posts
    15

    Default

    So, I tried again with the jTDS driver and it still gets the error. Some additional information is that this only occurs with the synchronize, not with an individual output or update. So, we swapped out the synchronize and put in a filter to an output or insert. Note that the error and fix were the same with either the MS jdbc driver or jTDS.

    Here it is with the error:

    Name:  sync.jpg
Views: 118
Size:  13.1 KB

    And here is the updated version:

    Name:  output and update.jpg
Views: 121
Size:  17.2 KB

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

    Default

    The original bug was fixed for sure. Is this transformation running transactional or not?

  7. #7
    Join Date
    Mar 2012
    Posts
    15

    Default

    Quick follow up - this transform is not running transactional, but will still give this error using a sychronize if it has error handling. If there is no error handling, then it works without a problem. Also, we are now running under 4.3.0

  8. #8
    Join Date
    Mar 2012
    Posts
    15

    Default

    Still gives an error on a sync with error an error handling link in 4.4

  9. #9
    Join Date
    May 2007
    Posts
    3

    Default

    Quote Originally Posted by patyoung View Post
    Still gives an error on a sync with error an error handling link in 4.4
    I'm also running into on the Synchronize after Merge step. Remove the error path and it works OK. I also notice when I have "Use Batch Update" checked I get a "Batch mode is disabled!" message in the log. Still investigating why it is being disabled.

    INFO 12-03 13:31:16,827 - RepositoriesMeta - Reading repositories XML file: /home/pentaho/.kettle/repositories.xml
    INFO 12-03 13:31:18,193 - D_MBR - Dispatching started for transformation [D_MBR]
    INFO 12-03 13:31:18,224 - D_MBR - Batch mode is disabled!

    I'm going to try to make a simpler repeatable example.

  10. #10
    Join Date
    Jun 2014
    Posts
    18

    Default

    I'm seeing similar behaviour ni version 5.01 using MySQL 5.1. The Synchronize after Merge step sometimes throws a "Unable to release database transaction savepoint" error.

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.