Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Return auto generated key error "'IMPLICIT_TRANSACTIONS' is not a recognized option."

  1. #1
    Join Date
    Sep 2011
    Posts
    7

    Default Return auto generated key error "'IMPLICIT_TRANSACTIONS' is not a recognized option."

    Hi,

    I have a Sybase table that looks like

    create table ABC(ID BIGINT IDENTITY,......)

    I am trying to insert values into that table using "Table Output" step with Return auto generated key on and the key field as ID. But the insertion fails with the following error

    2011/09/27 14:20:41 - Table output.0 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : Because of an error, this step can't continue:
    2011/09/27 14:20:41 - Table output.0 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : org.pentaho.di.core.exception.KettleException:
    2011/09/27 14:20:41 - Table output.0 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : Error inserting row into table [ABC] with values: [ABC], [1111-11-11], [C:\Documents and Settings\ABC.xml]
    2011/09/27 14:20:41 - Table output.0 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) :
    2011/09/27 14:20:41 - Table output.0 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : Unable to set database transaction savepoint
    2011/09/27 14:20:41 - Table output.0 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : 'IMPLICIT_TRANSACTIONS' is not a recognized option.

    2011/09/27 14:20:41 - Table output.0 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) :
    2011/09/27 14:20:41 - Table output.0 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : org.pentaho.di.trans.steps.tableoutput.TableOutput.writeToTable(TableOutput.java:434)
    2011/09/27 14:20:41 - Table output.0 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : org.pentaho.di.trans.steps.tableoutput.TableOutput.processRow(TableOutput.java:117)
    2011/09/27 14:20:41 - Table output.0 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : org.pentaho.di.trans.step.RunThread.run(RunThread.java:40)
    2011/09/27 14:20:41 - Table output.0 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : java.lang.Thread.run(Thread.java:619)


    However the insertion works fine with Return autogenerated key feature off. But I want the autogenerated key though. Please do let me know what the problem might be and how to solve it.

    Thanks.

  2. #2
    Join Date
    Sep 2011
    Posts
    7

    Default

    knock knock.. anybody there ? ..
    Friends, please help.. Thanks.

  3. #3
    Join Date
    Sep 2011
    Posts
    7

    Default

    Please friends.. help me out.. Thanks..

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

    Default

    It's a known problem with safepoints in certain drivers, fixed in 4.2.0 or 4.1.4.

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.