Hitachi Vantara Pentaho Community Forums
Results 1 to 6 of 6

Thread: Can't call commit when autocommit=true

  1. #1

    Default Can't call commit when autocommit=true

    I have a transform with 2 execute SQL steps with simple queries in them. One to delete data in the table and the next one to insert. the transform works fine but it gives this error every time it runs. but the data inserts fine. Any thoughts on what this error actually means?? ERROR 25-03 12:13:24,114 - Doms_Earnings_Fact_Acctg_Summary_Load - There was an unexpected error while handling the database transactions or the closing of it at the end of a transformation. The impacted database connection is called 'doms_data'.
    ERROR 25-03 12:13:24,114 - Doms_Earnings_Fact_Acctg_Summary_Load - org.pentaho.di.core.exception.KettleDatabaseException:
    Error committing connection : doms_data
    Error comitting connection
    Can't call commit when autocommit=true

    at org.pentaho.di.trans.Trans.closeUniqueDatabaseConnections(Trans.java:2059)
    at org.pentaho.di.trans.Trans.access$600(Trans.java:117)
    at org.pentaho.di.trans.Trans$1.stepFinished(Trans.java:857)
    at org.pentaho.di.trans.step.BaseStep.markStop(BaseStep.java:2314)
    at org.pentaho.di.trans.step.RunThread.run(RunThread.java:88)
    at java.lang.Thread.run(Unknown Source)
    Caused by: org.pentaho.di.core.exception.KettleDatabaseException:
    Error comitting connection

  2. #2
    Join Date
    Apr 2008
    Posts
    4,696

    Default

    Do you have a commit statement in either of your SQL steps?

  3. #3

    Default

    Quote Originally Posted by gutlez View Post
    Do you have a commit statement in either of your SQL steps?
    There is no commit statement.

  4. #4
    Join Date
    Apr 2008
    Posts
    4,696

    Default

    And what version of PDI?
    Which DB?

    You've left us guessing on a lot of things...

  5. #5

    Default

    Quote Originally Posted by gutlez View Post
    And what version of PDI?
    Which DB?

    You've left us guessing on a lot of things...
    Database is MySQL and we are on Pentaho version 4.2.1

  6. #6
    Join Date
    Apr 2008
    Posts
    4,696

    Default

    About the only suggestion I have for you is to try a newer version.

    I would expect that a delete statement would expect to have a commit in it.

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.