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

Error initializing step [Table output]

    XMLWordPrintable

    Details

    • Story Points:
      75
    • 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.
    • Browser:
      Google Chrome 48.x
    • Operating System/s:
      Windows 10
    • Steps to Reproduce:
      Hide

      We failed to initialize at least one step. Execution can not begin!
      2020/10/08 15:02:53 - Spoon - Running transformation using the Kettle execution engine
      2020/10/08 15:02:53 - Spoon - Transformation opened.
      2020/10/08 15:02:53 - Spoon - Launching transformation [Odoo]...
      2020/10/08 15:02:53 - Spoon - Started the transformation execution.
      2020/10/08 15:02:55 - Spoon - ERROR (version 9.0.0.0-423, build 9.0.0.0-423 from 2020-01-31 04.53.04 by buildguy) : Odoo: preparing transformation execution failed
      2020/10/08 15:02:55 - Spoon - ERROR (version 9.0.0.0-423, build 9.0.0.0-423 from 2020-01-31 04.53.04 by buildguy) : org.pentaho.di.core.exception.KettleException:
      2020/10/08 15:02:55 - Spoon - We failed to initialize at least one step. Execution can not begin!
      2020/10/08 15:02:55 - Spoon -
      2020/10/08 15:02:55 - Spoon -
      2020/10/08 15:02:55 - Spoon - at org.pentaho.di.trans.Trans.prepareExecution(Trans.java:1286)
      2020/10/08 15:02:55 - Spoon - at org.pentaho.di.ui.spoon.trans.TransGraph$30.run(TransGraph.java:4281)
      2020/10/08 15:02:55 - Spoon - at java.lang.Thread.run(Unknown Source)
      2020/10/08 15:03:15 - Odoo- Dispatching started for transformation [Odoo]
      2020/10/08 15:03:15 - Table output.0 - ERROR (version 9.0.0.0-423, build 9.0.0.0-423 from 2020-01-31 04.53.04 by buildguy) : Error initializing step [Table output]
      2020/10/08 15:03:15 - Table output.0 - ERROR (version 9.0.0.0-423, build 9.0.0.0-423 from 2020-01-31 04.53.04 by buildguy) : java.lang.NumberFormatException: null
      2020/10/08 15:03:15 - Table output.0 - at java.lang.Integer.parseInt(Unknown Source)
      2020/10/08 15:03:15 - Table output.0 - at java.lang.Integer.parseInt(Unknown Source)
      2020/10/08 15:03:15 - Table output.0 - at org.pentaho.di.trans.steps.tableoutput.TableOutput.init(TableOutput.java:476)
      2020/10/08 15:03:15 - Table output.0 - at org.pentaho.di.trans.step.StepInitThread.run(StepInitThread.java:69)
      2020/10/08 15:03:15 - Table output.0 - at java.lang.Thread.run(Unknown Source)
      2020/10/08 15:03:18 - Odoo - ERROR (version 9.0.0.0-423, build 9.0.0.0-423 from 2020-01-31 04.53.04 by buildguy) : Step [Table output.0] failed to initialize!
      2020/10/08 15:03:18 - Table input_return_reason.0 - Finished reading query, closing connection.

      Show
      We failed to initialize at least one step. Execution can not begin! 2020/10/08 15:02:53 - Spoon - Running transformation using the Kettle execution engine 2020/10/08 15:02:53 - Spoon - Transformation opened. 2020/10/08 15:02:53 - Spoon - Launching transformation [Odoo] ... 2020/10/08 15:02:53 - Spoon - Started the transformation execution. 2020/10/08 15:02:55 - Spoon - ERROR (version 9.0.0.0-423, build 9.0.0.0-423 from 2020-01-31 04.53.04 by buildguy) : Odoo: preparing transformation execution failed 2020/10/08 15:02:55 - Spoon - ERROR (version 9.0.0.0-423, build 9.0.0.0-423 from 2020-01-31 04.53.04 by buildguy) : org.pentaho.di.core.exception.KettleException: 2020/10/08 15:02:55 - Spoon - We failed to initialize at least one step. Execution can not begin! 2020/10/08 15:02:55 - Spoon - 2020/10/08 15:02:55 - Spoon - 2020/10/08 15:02:55 - Spoon - at org.pentaho.di.trans.Trans.prepareExecution(Trans.java:1286) 2020/10/08 15:02:55 - Spoon - at org.pentaho.di.ui.spoon.trans.TransGraph$30.run(TransGraph.java:4281) 2020/10/08 15:02:55 - Spoon - at java.lang.Thread.run(Unknown Source) 2020/10/08 15:03:15 - Odoo- Dispatching started for transformation [Odoo] 2020/10/08 15:03:15 - Table output.0 - ERROR (version 9.0.0.0-423, build 9.0.0.0-423 from 2020-01-31 04.53.04 by buildguy) : Error initializing step [Table output] 2020/10/08 15:03:15 - Table output.0 - ERROR (version 9.0.0.0-423, build 9.0.0.0-423 from 2020-01-31 04.53.04 by buildguy) : java.lang.NumberFormatException: null 2020/10/08 15:03:15 - Table output.0 - at java.lang.Integer.parseInt(Unknown Source) 2020/10/08 15:03:15 - Table output.0 - at java.lang.Integer.parseInt(Unknown Source) 2020/10/08 15:03:15 - Table output.0 - at org.pentaho.di.trans.steps.tableoutput.TableOutput.init(TableOutput.java:476) 2020/10/08 15:03:15 - Table output.0 - at org.pentaho.di.trans.step.StepInitThread.run(StepInitThread.java:69) 2020/10/08 15:03:15 - Table output.0 - at java.lang.Thread.run(Unknown Source) 2020/10/08 15:03:18 - Odoo - ERROR (version 9.0.0.0-423, build 9.0.0.0-423 from 2020-01-31 04.53.04 by buildguy) : Step [Table output.0] failed to initialize! 2020/10/08 15:03:18 - Table input_return_reason.0 - Finished reading query, closing connection.

      Description

      I am pulling Data from AWS Aurora PostgreSQL to Redshift. Using both Table input and Table output. I get the above error. When I test the connections for both are successful. The red highlight is on the [Table output].
      NO CONNECTION POOLING.
      When I export the csv.file It comes out okay.

        Attachments

          Activity

            People

            Assignee:
            Bunde Amos Bunde
            Reporter:
            Bunde Amos Bunde
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

              Created:
              Updated: