Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: ERROR (version 5.2.0.0, build 1 from 2014-09-30_19-48-28 by buildguy) : Unexpected er

  1. #1
    Join Date
    Nov 2014
    Posts
    1

    Default ERROR (version 5.2.0.0, build 1 from 2014-09-30_19-48-28 by buildguy) : Unexpected er

    Hi ,

    I am very new to Pentaho ,could anyone please help on below errors.

    2014/11/13 16:52:05 - Table input.0 - ERROR (version 5.2.0.0, build 1 from 2014-09-30_19-48-28 by buildguy) : Unexpected error
    2014/11/13 16:52:05 - Table input.0 - ERROR (version 5.2.0.0, build 1 from 2014-09-30_19-48-28 by buildguy) : org.pentaho.di.core.exception.KettleDatabaseException:
    2014/11/13 16:52:05 - Table input.0 - Couldn't get row from result set
    2014/11/13 16:52:05 - Table input.0 -
    2014/11/13 16:52:05 - Table input.0 - Unable to get value 'String(100)<binary-string>' from database resultset, index 12
    2014/11/13 16:52:05 - Table input.0 - [Microsoft][ODBC Driver Manager] Invalid string or buffer length
    2014/11/13 16:52:05 - Table input.0 -
    2014/11/13 16:52:05 - Table input.0 -
    2014/11/13 16:52:05 - Table input.0 - at org.pentaho.di.core.database.Database.getRow(Database.java:2410)
    2014/11/13 16:52:05 - Table input.0 - at org.pentaho.di.core.database.Database.getRow(Database.java:2380)
    2014/11/13 16:52:05 - Table input.0 - at org.pentaho.di.trans.steps.tableinput.TableInput.processRow(TableInput.java:145)
    2014/11/13 16:52:05 - Table input.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)
    2014/11/13 16:52:05 - Table input.0 - at java.lang.Thread.run(Unknown Source)
    2014/11/13 16:52:05 - Table input.0 - Caused by: org.pentaho.di.core.exception.KettleDatabaseException:
    2014/11/13 16:52:05 - Table input.0 - Unable to get value 'String(100)<binary-string>' from database resultset, index 12
    2014/11/13 16:52:05 - Table input.0 - [Microsoft][ODBC Driver Manager] Invalid string or buffer length
    2014/11/13 16:52:05 - Table input.0 -
    2014/11/13 16:52:05 - Table input.0 - at org.pentaho.di.core.row.value.ValueMetaBase.getValueFromResultSet(ValueMetaBase.java:4743)
    2014/11/13 16:52:05 - Table input.0 - at org.pentaho.di.core.database.BaseDatabaseMeta.getValueFromResultSet(BaseDatabaseMeta.java:2086)
    2014/11/13 16:52:05 - Table input.0 - at org.pentaho.di.core.database.DatabaseMeta.getValueFromResultSet(DatabaseMeta.java:2852)
    2014/11/13 16:52:05 - Table input.0 - at org.pentaho.di.core.database.Database.getRow(Database.java:2402)
    2014/11/13 16:52:05 - Table input.0 - ... 4 more
    2014/11/13 16:52:05 - Table input.0 - Caused by: java.sql.SQLException: [Microsoft][ODBC Driver Manager] Invalid string or buffer length
    2014/11/13 16:52:05 - Table input.0 - at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
    2014/11/13 16:52:05 - Table input.0 - at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
    2014/11/13 16:52:05 - Table input.0 - at sun.jdbc.odbc.JdbcOdbc.SQLGetDataBinary(Unknown Source)
    2014/11/13 16:52:05 - Table input.0 - at sun.jdbc.odbc.JdbcOdbc.SQLGetDataBinary(Unknown Source)
    2014/11/13 16:52:05 - Table input.0 - at sun.jdbc.odbc.JdbcOdbcResultSet.getBytes(Unknown Source)
    2014/11/13 16:52:05 - Table input.0 - at org.pentaho.di.core.row.value.ValueMetaBase.getValueFromResultSet(ValueMetaBase.java:4705)
    2014/11/13 16:52:05 - Table input.0 - ... 7 more
    2014/11/13 16:52:05 - Table input.0 - Finished reading query, closing connection.
    2014/11/13 16:52:05 - Table output.0 - ERROR (version 5.2.0.0, build 1 from 2014-09-30_19-48-28 by buildguy) : Unexpected batch update error committing the database connection.
    2014/11/13 16:52:05 - Table output.0 - ERROR (version 5.2.0.0, build 1 from 2014-09-30_19-48-28 by buildguy) : org.pentaho.di.core.exception.KettleDatabaseBatchException:
    2014/11/13 16:52:05 - Table output.0 - Error updating batch
    2014/11/13 16:52:05 - Table output.0 - Batch entry 0 INSERT INTO "public".sw_purchase (forwarder, landing, "type", date_of_reception, week, "month", "year", origin, invoice_date, item_code, brand, description, party_name, bill_of_entry_no, qty, bill_no, invoice_fob, deacathlon_rate, invoice_value, be_exchange_rate, invoice_amount, trans_total, trans_by_item, insurance, landing_charges, av, bcd, cvd, cess_on_cvd, cess_on_bcd, sad_duties, anti_dumping, total_duties, freight_charges_total, freight_by_item, dpp_commision_total, dpp_commision_by_item, total_purchase, unit_price, vat_external, net_amt, volume, shipment_type) VALUES ( NULL, 14.0, 'PURCHASE@14%', '2012-01-01 00:00:00.000000 +05:30:00', 201252.0, 1, 2012, 'DIRECT PURCHASEBG', '2012-01-01 00:00:00.000000 +05:30:00', 9000181.0, 'HEALTH AND DISCOVERY', 'BREAKFAST AWESOME APPLE', 'Kaseb Health Care PVT LTD', NULL, 96, 'Kaseb-1', 9473.28, NULL, 9473.28, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 9473.0, 98.68, 1326.26, 10799.54, 0.14, NULL) was aborted. Call getNextException to see the cause.
    2014/11/13 16:52:05 - Table output.0 -
    2014/11/13 16:52:05 - Table output.0 - at org.pentaho.di.core.database.Database.createKettleDatabaseBatchException(Database.java:1377)
    2014/11/13 16:52:05 - Table output.0 - at org.pentaho.di.core.database.Database.emptyAndCommit(Database.java:1366)
    2014/11/13 16:52:05 - Table output.0 - at org.pentaho.di.trans.steps.tableoutput.TableOutput.dispose(TableOutput.java:571)
    2014/11/13 16:52:05 - Table output.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:96)
    2014/11/13 16:52:05 - Table output.0 - at java.lang.Thread.run(Unknown Source)
    2014/11/13 16:52:05 - Table output.0 - Caused by: java.sql.BatchUpdateException: Batch entry 0 INSERT INTO "public".sw_purchase (forwarder, landing, "type", date_of_reception, week, "month", "year", origin, invoice_date, item_code, brand, description, party_name, bill_of_entry_no, qty, bill_no, invoice_fob, deacathlon_rate, invoice_value, be_exchange_rate, invoice_amount, trans_total, trans_by_item, insurance, landing_charges, av, bcd, cvd, cess_on_cvd, cess_on_bcd, sad_duties, anti_dumping, total_duties, freight_charges_total, freight_by_item, dpp_commision_total, dpp_commision_by_item, total_purchase, unit_price, vat_external, net_amt, volume, shipment_type) VALUES ( NULL, 14.0, 'PURCHASE@14%', '2012-01-01 00:00:00.000000 +05:30:00', 201252.0, 1, 2012, 'DIRECT PURCHASEBG', '2012-01-01 00:00:00.000000 +05:30:00', 9000181.0, 'HEALTH AND DISCOVERY', 'BREAKFAST AWESOME APPLE', 'Kaseb Health Care PVT LTD', NULL, 96, 'Kaseb-1', 9473.28, NULL, 9473.28, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 9473.0, 98.68, 1326.26, 10799.54, 0.14, NULL) was aborted. Call getNextException to see the cause.
    2014/11/13 16:52:05 - Table output.0 - at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2743)
    2014/11/13 16:52:05 - Table output.0 - at org.postgresql.core.v3.QueryExecutorImpl$1.handleError(QueryExecutorImpl.java:461)
    2014/11/13 16:52:05 - Table output.0 - at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1928)
    2014/11/13 16:52:05 - Table output.0 - at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:405)
    2014/11/13 16:52:05 - Table output.0 - at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2892)
    2014/11/13 16:52:05 - Table output.0 - at org.pentaho.di.core.database.Database.emptyAndCommit(Database.java:1353)
    2014/11/13 16:52:05 - Table output.0 - ... 3 more
    2014/11/13 16:52:05 - Table output.0 - Finished processing (I=0, O=0, R=179, W=0, U=0, E=1)
    2014/11/13 16:52:05 - MSaccess2postgres - Transformation detected one or more steps with errors.
    2014/11/13 16:52:05 - MSaccess2postgres - Transformation is killing the other steps!
    2014/11/13 16:52:05 - Table input.0 - Finished processing (I=180, O=0, R=0, W=179, U=0, E=1)
    2014/11/13 16:52:05 - MSaccess2postgres - ERROR (version 5.2.0.0, build 1 from 2014-09-30_19-48-28 by buildguy) : Errors detected!
    2014/11/13 16:52:05 - Spoon - The transformation has finished!!
    2014/11/13 16:52:05 - MSaccess2postgres - ERROR (version 5.2.0.0, build 1 from 2014-09-30_19-48-28 by buildguy) : Errors detected!
    2014/11/13 16:52:05 - MSaccess2postgres - ERROR (version 5.2.0.0, build 1 from 2014-09-30_19-48-28 by buildguy) : Errors detected!
    2014/11/13 16:52:05 - MSaccess2postgres - Transformation detected one or more steps with errors.
    2014/11/13 16:52:05 - MSaccess2postgres - Transformation is killing the other steps!


    Thank you

  2. #2
    Join Date
    Apr 2008
    Posts
    4,696

    Default

    First thing I would suggest is using the MS Access input rather than Table Input over ODBC.

  3. #3

    Default

    I got the same error. Error was because of when reading flatfiles, the 'CSV File Input' detects the last column as a column without a header field. Solution: delete this column from the field list.

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.