Uploaded image for project: 'Pentaho Data Integration - Kettle'
  1. Pentaho Data Integration - Kettle
  2. PDI-11894

Facing error while using TABLE OUTPUT and INSERT/UPDATE step

    Details

    • Type: Bug
    • Status: Closed
    • Severity: High
    • Resolution: Incomplete
    • Affects Version/s: 5.0.4 GA
    • Fix Version/s: None
    • Component/s: Database, Step, Transformation
    • Labels:
      None
    • PDI Sub-component:
    • Notice:
      When an issue is open, the "Fix Version/s" field conveys a target, not necessarily a commitment. When an issue is closed, the "Fix Version/s" field conveys the version that the issue was fixed in.
    • Operating System/s:
      Windows 7

      Description

      Hi Team, I am a new user of pentaho kettle. I am trying to use TABLE OUTPUT and INSERT/UPDATE step in my transformation. The data base is Oracle. I am not able to insert or update record to database. Please help with possible reasons and solutions for such issues. I am getting below error: 2014/03/31 13:18:36 - General - Logging plugin type found with ID: CheckpointLogTable 2014/03/31 13:18:43 - General - Starting agile-bi 2014/03/31 13:18:43 - Spoon - Asking for repository 2014/03/31 13:18:47 - class org.pentaho.agilebi.platform.JettyServer - WebServer.Log.CreateListener localhost:10000 2014/03/31 13:22:40 - Spoon - Transformation opened. 2014/03/31 13:22:40 - Spoon - Launching transformation [insert update]... 2014/03/31 13:22:40 - Spoon - Started the transformation execution. 2014/03/31 13:22:41 - insert update - Dispatching started for transformation [insert update] 2014/03/31 13:22:48 - Table input.0 - Finished reading query, closing connection. 2014/03/31 13:22:48 - Insert / Update.0 - ERROR (version 5.0.4, build 1 from 2014-02-17_08-03-10 by buildguy) : Unexpected error 2014/03/31 13:22:48 - Insert / Update.0 - ERROR (version 5.0.4, build 1 from 2014-02-17_08-03-10 by buildguy) : org.pentaho.di.core.exception.KettleStepException: 2014/03/31 13:22:48 - Insert / Update.0 - Error in step, asking everyone to stop because of: 2014/03/31 13:22:48 - Insert / Update.0 - 2014/03/31 13:22:48 - Insert / Update.0 - Error looking up row in database 2014/03/31 13:22:48 - Insert / Update.0 - General error 2014/03/31 13:22:48 - Insert / Update.0 - 2014/03/31 13:22:48 - Insert / Update.0 - 2014/03/31 13:22:48 - Insert / Update.0 - at org.pentaho.di.trans.steps.insertupdate.InsertUpdate.processRow(InsertUpdate.java:318) 2014/03/31 13:22:48 - Insert / Update.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:60) 2014/03/31 13:22:48 - Insert / Update.0 - at java.lang.Thread.run(Unknown Source) 2014/03/31 13:22:48 - Insert / Update.0 - Caused by: org.pentaho.di.core.exception.KettleDatabaseException: 2014/03/31 13:22:48 - Insert / Update.0 - Error looking up row in database 2014/03/31 13:22:48 - Insert / Update.0 - General error 2014/03/31 13:22:48 - Insert / Update.0 - 2014/03/31 13:22:48 - Insert / Update.0 - at org.pentaho.di.core.database.Database.getLookup(Database.java:2657) 2014/03/31 13:22:48 - Insert / Update.0 - at org.pentaho.di.core.database.Database.getLookup(Database.java:2632) 2014/03/31 13:22:48 - Insert / Update.0 - at org.pentaho.di.trans.steps.insertupdate.InsertUpdate.lookupValues(InsertUpdate.java:91) 2014/03/31 13:22:48 - Insert / Update.0 - at org.pentaho.di.trans.steps.insertupdate.InsertUpdate.processRow(InsertUpdate.java:301) 2014/03/31 13:22:48 - Insert / Update.0 - ... 2 more 2014/03/31 13:22:48 - Insert / Update.0 - Caused by: java.sql.SQLException: General error 2014/03/31 13:22:48 - Insert / Update.0 - at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source) 2014/03/31 13:22:48 - Insert / Update.0 - at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source) 2014/03/31 13:22:48 - Insert / Update.0 - at sun.jdbc.odbc.JdbcOdbc.SQLExecute(Unknown Source) 2014/03/31 13:22:48 - Insert / Update.0 - at sun.jdbc.odbc.JdbcOdbcPreparedStatement.execute(Unknown Source) 2014/03/31 13:22:48 - Insert / Update.0 - at sun.jdbc.odbc.JdbcOdbcPreparedStatement.executeQuery(Unknown Source) 2014/03/31 13:22:48 - Insert / Update.0 - at org.pentaho.di.core.database.Database.getLookup(Database.java:2639) 2014/03/31 13:22:48 - Insert / Update.0 - ... 5 more 2014/03/31 13:22:48 - Table input.0 - Finished processing (I=10, O=0, R=0, W=10, U=0, E=0) 2014/03/31 13:22:49 - Insert / Update.0 - Finished processing (I=0, O=0, R=1, W=0, U=0, E=1) 2014/03/31 13:22:49 - insert update - ERROR (version 5.0.4, build 1 from 2014-02-17_08-03-10 by buildguy) : Errors detected! 2014/03/31 13:22:49 - Spoon - The transformation has finished!! 2014/03/31 13:22:49 - insert update - ERROR (version 5.0.4, build 1 from 2014-02-17_08-03-10 by buildguy) : Errors detected! 2014/03/31 13:22:49 - insert update - ERROR (version 5.0.4, build 1 from 2014-02-17_08-03-10 by buildguy) : Errors detected! 2014/03/31 13:22:49 - insert update - insert update 2014/03/31 13:22:49 - insert update - insert update

        Attachments

          Activity

            People

            • Assignee:
              project admin Triage
              Reporter:
              yashsri Yash Sri Gupta
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: