Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Unable to get value 'Integer(15)'/'String(100)' from database resultset, index 0

  1. #1
    Join Date
    Jan 2018
    Posts
    1

    Default Unable to get value 'Integer(15)'/'String(100)' from database resultset, index 0

    Hi,

    I am using kettle and trying to get data from SQL Server to Mysql.
    My table input keeps failing on the above error message : unable to get value 'String(100)' from database resultset, index 6
    everytime I try to convert a field to VARCHAR it fails on a different field.

    These are all scripts that were used and working before - I am not sure why this is suddenly happening.
    Any help would be greatly appreciated.

    Thanks!!

    Error Example 1:
    2018/01/22 20:07:26 - Table input.0 - ERROR (version 7.0.0.0-25, build 1 from 2016-11-05 15.35.36 by buildguy) : Unexpected error
    2018/01/22 20:07:26 - Table input.0 - ERROR (version 7.0.0.0-25, build 1 from 2016-11-05 15.35.36 by buildguy) : org.pentaho.di.core.exception.KettleDatabaseException:
    2018/01/22 20:07:26 - Table input.0 - Couldn't get row from result set
    2018/01/22 20:07:26 - Table input.0 -
    2018/01/22 20:07:26 - Table input.0 - Unable to get value 'Integer(15)' from database resultset, index 0
    2018/01/22 20:07:26 - Table input.0 - Connection reset
    2018/01/22 20:07:26 - Table input.0 -
    2018/01/22 20:07:26 - Table input.0 -
    2018/01/22 20:07:26 - Table input.0 - at org.pentaho.di.core.database.Database.getRow(Database.java:2540)
    2018/01/22 20:07:26 - Table input.0 - at org.pentaho.di.core.database.Database.getRow(Database.java:2510)
    2018/01/22 20:07:26 - Table input.0 - at org.pentaho.di.trans.steps.tableinput.TableInput.processRow(TableInput.java:148)
    2018/01/22 20:07:26 - Table input.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)
    2018/01/22 20:07:26 - Table input.0 - at java.lang.Thread.run(Unknown Source)
    2018/01/22 20:07:26 - Table input.0 - Caused by: org.pentaho.di.core.exception.KettleDatabaseException:
    2018/01/22 20:07:26 - Table input.0 - Unable to get value 'Integer(15)' from database resultset, index 0
    2018/01/22 20:07:26 - Table input.0 - Connection reset
    2018/01/22 20:07:26 - Table input.0 -

    Error Example 2:
    2018/01/22 20:24:36 - Populate MYSQL Query_Data Table.0 - linenr 350000
    2018/01/22 20:24:40 - Get Raw data from MIG DB.0 - ERROR (version 7.0.0.0-25, build 1 from 2016-11-05 15.35.36 by buildguy) : Unexpected error
    2018/01/22 20:24:40 - Get Raw data from MIG DB.0 - ERROR (version 7.0.0.0-25, build 1 from 2016-11-05 15.35.36 by buildguy) : org.pentaho.di.core.exception.KettleDatabaseException:
    2018/01/22 20:24:40 - Get Raw data from MIG DB.0 - Couldn't get row from result set
    2018/01/22 20:24:40 - Get Raw data from MIG DB.0 -
    2018/01/22 20:24:40 - Get Raw data from MIG DB.0 - Unable to get value 'String(50)' from database resultset, index 18
    2018/01/22 20:24:40 - Get Raw data from MIG DB.0 - Connection reset
    2018/01/22 20:24:40 - Get Raw data from MIG DB.0 -
    2018/01/22 20:24:40 - Get Raw data from MIG DB.0 -
    2018/01/22 20:24:40 - Get Raw data from MIG DB.0 - at org.pentaho.di.core.database.Database.getRow(Database.java:2540)
    2018/01/22 20:24:40 - Get Raw data from MIG DB.0 - at org.pentaho.di.core.database.Database.getRow(Database.java:2510)
    2018/01/22 20:24:40 - Get Raw data from MIG DB.0 - at org.pentaho.di.trans.steps.tableinput.TableInput.processRow(TableInput.java:148)
    2018/01/22 20:24:40 - Get Raw data from MIG DB.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)
    2018/01/22 20:24:40 - Get Raw data from MIG DB.0 - at java.lang.Thread.run(Unknown Source)
    2018/01/22 20:24:40 - Get Raw data from MIG DB.0 - Caused by: org.pentaho.di.core.exception.KettleDatabaseException:
    2018/01/22 20:24:40 - Get Raw data from MIG DB.0 - Unable to get value 'String(50)' from database resultset, index 18
    2018/01/22 20:24:40 - Get Raw data from MIG DB.0 - Connection reset
    2018/01/22 20:24:40 - Get Raw data from MIG DB.0 -
    Last edited by alot; 01-22-2018 at 10:40 PM.

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

    Default

    Connection reset suggests that you're having network issues.

Tags for this Thread

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.