Error Saving Transformation to Repository

[kettle_bijugv]

Attachment: test.ktr (http://forums.pentaho.org/archived_att/kettle/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 />

[MattCasters]

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

[kettle_anonymous]

Thanks Matt,

VALUE_STR VARCHAR2(4000) did the trick.

Regards
Biju