Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Error Saving Transformation to Repository

  1. #1

    Default Error Saving Transformation to Repository

    Attachment: test.ktr Hi


    I've worked on a a transformation and when i try to save it into the repository, I get an ERROR!



    using Spoon version 2.2.2



    please help. Following is the error message :

    <hr />
    Error saving transformation to repository!


    Unable to commit connection after having inserted rows.
    ORA-01401: inserted value too large for column












    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.
    ORA-01401: inserted value too large for column









    at be.ibridge.kettle.trans.dialog.TransSaveProgressDialog$1.run(Unknown Source)
    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(Unknown Source)
    at be.ibridge.kettle.spoon.Spoon.saveRepository(Unknown Source)
    at be.ibridge.kettle.spoon.Spoon.saveRepository(Unknown Source)
    at be.ibridge.kettle.spoon.Spoon.saveFile(Unknown Source)
    at be.ibridge.kettle.spoon.Spoon$41.widgetSelected(Unknown Source)
    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(Unknown Source)
    at be.ibridge.kettle.spoon.Spoon.main(Unknown Source)
    Caused by: be.ibridge.kettle.core.exception.KettleException:
    Error saving transformation to repository!



    Unable to commit connection after having inserted rows.
    ORA-01401: inserted value too large for column









    at be.ibridge.kettle.trans.TransMeta.saveRep(Unknown Source)
    ... 16 more
    Caused by: be.ibridge.kettle.core.exception.KettleDatabaseException:
    Unable to commit connection after having inserted rows.
    ORA-01401: inserted value too large for column






    at be.ibridge.kettle.core.database.Database.insertFinished(Unknown Source)
    at be.ibridge.kettle.repository.Repository.closeStepAttributeInsertPreparedStatement(Unknown Source)
    ... 17 more
    Caused by: java.sql.BatchUpdateException: ORA-01401: inserted value too large for column



    at oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:367)
    at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:8739)
    ... 19 more

    <hr />

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

    Default RE: Error Saving Transformation to Repository

    It says you want to save a value into the database repository that is too large ;-)
    It&#39;s hard to say from where I&#39;m sitting what that value might be, but perhaps you can tell?

    In any case, you can change the VALUE_STR field in R_STEP_ATTRIBUTE in the repository to something larger.
    ALTER TABLE R_STEP_ATTRIBUTE MODIFY(VALUE_STR VARCHAR2(4000); or something would do the trick unless you want to store really large scripts and the like in the repository.

    In the development version we made this a CLOB field (for Oracle), effectively removing any possible limit.

    Same story for R_JOBENTRY_ATTRIBUTE in case you wonder.

    Hope this helps,

    Matt

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

    Default RE: Error Saving Transformation to Repository

    Thanks Matt,

    VALUE_STR VARCHAR2(4000) did the trick.

    Regards
    Biju

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.