Hitachi Vantara Pentaho Community Forums
Results 1 to 6 of 6

Thread: Unable to commit connection after having inserted rows

  1. #1
    Join Date
    Sep 2005
    Posts
    1,403

    Default Unable to commit connection after having inserted rows

    I am running spoon 2.2 on windows XP.

    1) I have created a repositiry on MYSQL which I use when loggin in to Kettle
    2) I have made two Database Connections one for a MYSQL database that I will move data to, and I use a SQL Server customer database where I am getting data from.
    3) I am able to save the transformation
    4) I create a table input getting data from the SQL Server db by defining an sql statement, and reviewing to verify the data set, then I click OK.

    Now this is my question:
    When trying to save my work I get the error:

    Unable to commit connection after having inserted
    rows.
    [MySQL][ODBC 3.51 Driver][mysqld-5.0.20a-nt]Out of
    range value adjusted for column 'NR' at row 1 (see the full message in attached txt file).

    Have I made a configuration error or what is wrong?

    /Eric

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

    Default RE: Unable to commit connection after having inserted rows

    Hi Eric,

    That's a really strange error. Can you attach the full error message?
    I'm sure it doesn't matter all that much. Most repository problems were fixed in 2.3.0.
    But, let's make sure.

    Thanks in advance!

    Matt

  3. #3
    Join Date
    Sep 2005
    Posts
    1,403

    Default RE: Unable to commit connection after having inserted rows

    Hi,

    This is the full error message:

    Error saving transformation to repository!

    Unable to commit connection after having inserted rows.
    [MySQL][ODBC 3.51 Driver][mysqld-5.0.20a-nt]Out of range value adjusted for column 'ID_TRANSFORMATION' at row 1



    java.lang.reflect.InvocationTargetException: Error saving transformation: be.ibridge.kettle.core.exception.KettleException:
    Error saving transformation to repository!

    Unable to commit connection after having inserted rows.
    [MySQL][ODBC 3.51 Driver][mysqld-5.0.20a-nt]Out of range value adjusted for column 'ID_TRANSFORMATION' at row 1


    at be.ibridge.kettle.trans.dialog.TransSaveProgressDialog$1.run(TransSaveProgressDialog.java:61)
    at org.eclipse.jface.operation.ModalContext.runInCurrentThread(ModalContext.java:346)
    at org.eclipse.jface.operation.ModalContext.run(ModalContext.java:291)
    at org.eclipse.jface.dialogs.ProgressMonitorDialog.run(ProgressMonitorDialog.java:447)
    at be.ibridge.kettle.trans.dialog.TransSaveProgressDialog.open(TransSaveProgressDialog.java:69)
    at be.ibridge.kettle.spoon.Spoon.saveRepository(Spoon.java:2541)
    at be.ibridge.kettle.spoon.Spoon.saveRepository(Spoon.java:2494)
    at be.ibridge.kettle.spoon.Spoon.saveFile(Spoon.java:2468)
    at be.ibridge.kettle.spoon.Spoon$41.widgetSelected(Spoon.java:869)
    at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:90)
    at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66)
    at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:843)
    at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3080)
    at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2713)
    at be.ibridge.kettle.spoon.Spoon.readAndDispatch(Spoon.java:472)
    at be.ibridge.kettle.spoon.Spoon.main(Spoon.java:4486)
    Caused by: be.ibridge.kettle.core.exception.KettleException:
    Error saving transformation to repository!

    Unable to commit connection after having inserted rows.
    [MySQL][ODBC 3.51 Driver][mysqld-5.0.20a-nt]Out of range value adjusted for column 'ID_TRANSFORMATION' at row 1


    at be.ibridge.kettle.trans.TransMeta.saveRep(TransMeta.java:1611)
    at be.ibridge.kettle.trans.dialog.TransSaveProgressDialog$1.run(TransSaveProgressDialog.java:57)
    ... 15 more
    Caused by: be.ibridge.kettle.core.exception.KettleDatabaseException:
    Unable to commit connection after having inserted rows.
    [MySQL][ODBC 3.51 Driver][mysqld-5.0.20a-nt]Out of range value adjusted for column 'ID_TRANSFORMATION' at row 1

    at be.ibridge.kettle.core.database.Database.insertFinished(Database.java:1416)
    at be.ibridge.kettle.repository.Repository.closeStepAttributeInsertPreparedStatement(Repository.java:2511)
    at be.ibridge.kettle.trans.TransMeta.saveRep(TransMeta.java:1574)
    ... 16 more
    Caused by: sun.jdbc.odbc.JdbcOdbcBatchUpdateException: [MySQL][ODBC 3.51 Driver][mysqld-5.0.20a-nt]Out of range value adjusted for column 'ID_TRANSFORMATION' at row 1
    at sun.jdbc.odbc.JdbcOdbcPreparedStatement.emulateExecuteBatch(Unknown Source)
    at sun.jdbc.odbc.JdbcOdbcPreparedStatement.executeBatchUpdate(Unknown Source)
    at sun.jdbc.odbc.JdbcOdbcStatement.executeBatch(Unknown Source)
    at be.ibridge.kettle.core.database.Database.insertFinished(Database.java:1402)
    ... 18 more

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

    Default RE: Unable to commit connection after having inserted rows

    Mmmm, that's just a simple insert. It's probably an ODBC driver problem.
    I think I'm going to disable repository support for ODBC connections.
    It's just not very reliable.

    Matt

  5. #5
    Join Date
    Sep 2005
    Posts
    1,403

    Default RE: Unable to commit connection after having inserted rows

    Matt, you where right, switched to jdbc instead and it works now.

    Thanks for your response.

    /Eric

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

    Default RE: Unable to commit connection after having inserted rows

    The worst thing about it is that I don't know why it's doing that.

    I will put a warning in the repository creation. That way people can decide for themselves if it works or not.

    Cheers,

    Matt

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.