Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: error

  1. #1

    Default error

    Hi,

    Can any one help me in this issue. Thanks in advance

    These are error lines I am getting continuesly.What may be the reason?

    I have mapped the input column INSENTIVE_AMMT -->INCENTIVE output column, Both the datatype length is Integer 4.

    With this i have attached my sample job and input.Please guide me


    2008/11/24 14:56:43 - Table output.0 - Starting to run...
    2008/11/24 14:56:43 - Text file input.0 - Starting to run...
    2008/11/24 14:56:43 - Text file input.0 - Opening file: D:\FIT\DSFiles\Input\CST_INCENTIVE.txt
    2008/11/24 14:56:43 - Text file input.0 - Finished processing (I=4, O=0, R=0, W=3, U=0, E=0)
    2008/11/24 14:56:43 - Select values.0 - Finished processing (I=0, O=0, R=3, W=3, U=0, E=0)
    2008/11/24 14:56:43 - Table output.0 - ERROR (version 3.0.4, build 53 from 2008/06/25 00:44:00) : Unexpected batch update error committing the database connection.
    2008/11/24 14:56:43 - Table output.0 - ERROR (version 3.0.4, build 53 from 2008/06/25 00:44:00) : org.pentaho.di.core.exception.KettleDatabaseBatchException:
    2008/11/24 14:56:43 - Table output.0 - ERROR (version 3.0.4, build 53 from 2008/06/25 00:44:00) : Error updating batch
    2008/11/24 14:56:43 - Table output.0 - ERROR (version 3.0.4, build 53 from 2008/06/25 00:44:00) : ORA-00904: "INCENTIVE": invalid identifier

    2008/11/24 14:56:43 - Table output.0 - ERROR (version 3.0.4, build 53 from 2008/06/25 00:44:00) :
    2008/11/24 14:56:43 - Table output.0 - ERROR (version 3.0.4, build 53 from 2008/06/25 00:44:00) : at org.pentaho.di.core.database.Database.insertFinished(Database.java:1407)
    2008/11/24 14:56:43 - Table output.0 - ERROR (version 3.0.4, build 53 from 2008/06/25 00:44:00) : at org.pentaho.di.trans.steps.tableoutput.TableOutput.dispose(TableOutput.java:455)
    2008/11/24 14:56:43 - Table output.0 - ERROR (version 3.0.4, build 53 from 2008/06/25 00:44:00) : at org.pentaho.di.trans.steps.tableoutput.TableOutput.run(TableOutput.java:536)
    2008/11/24 14:56:43 - Table output.0 - ERROR (version 3.0.4, build 53 from 2008/06/25 00:44:00) : Caused by: java.sql.BatchUpdateException: ORA-00904: "INCENTIVE": invalid identifier

    2008/11/24 14:56:43 - Table output.0 - ERROR (version 3.0.4, build 53 from 2008/06/25 00:44:00) : at oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:343)
    2008/11/24 14:56:43 - Table output.0 - ERROR (version 3.0.4, build 53 from 2008/06/25 00:44:00) : at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10698)
    2008/11/24 14:56:43 - Table output.0 - ERROR (version 3.0.4, build 53 from 2008/06/25 00:44:00) : at org.pentaho.di.core.database.Database.insertFinished(Database.java:1391)
    2008/11/24 14:56:43 - Table output.0 - ERROR (version 3.0.4, build 53 from 2008/06/25 00:44:00) : ... 2 more
    2008/11/24 14:56:43 - Table output.0 - Finished processing (I=0, O=0, R=3, W=0, U=0, E=1)
    2008/11/24 14:56:43 - Spoon - The transformation has finished!!


    Regards
    Naren
    Attached Files Attached Files

  2. #2
    Join Date
    May 2006
    Posts
    4,882

    Default

    The name of the column in the database needs to be the same as the name of the column in the row in PDI. You can rename the name of the row fields with "Select values" step e.g.

    I'm working on http://jira.pentaho.com/browse/PDI-16 right now

    Regards,
    Sven

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.