Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Invalid column index during database lookup

  1. #1
    Join Date
    Oct 2008
    Posts
    17

    Default Invalid column index during database lookup

    Hello,
    I have this error and I don't understand.
    I my transformation, I used the same statement (I change the key to read the table), in the previous steps and I don't have errors.

    2014/11/24 12:28:17 - Lookup ERR003.0 - ERROR (version 4.1.0, build 1 from 2012-11-06 13.20.53) : Because of an error, this step can't continue:
    2014/11/24 12:28:17 - Lookup ERR003.0 - ERROR (version 4.1.0, build 1 from 2012-11-06 13.20.53) : offending row : [W_COD_ERR003 String(6)], [ String]
    2014/11/24 12:28:17 - Lookup ERR003.0 - ERROR (version 4.1.0, build 1 from 2012-11-06 13.20.53) :
    2014/11/24 12:28:17 - Lookup ERR003.0 - ERROR (version 4.1.0, build 1 from 2012-11-06 13.20.53) : Error setting value #2 [ String] on prepared statement (String)
    2014/11/24 12:28:17 - Lookup ERR003.0 - ERROR (version 4.1.0, build 1 from 2012-11-06 13.20.53) : java.sql.SQLException: Index de colonne non valide
    2014/11/24 12:28:17 - Lookup ERR003.0 - ERROR (version 4.1.0, build 1 from 2012-11-06 13.20.53) : Index de colonne non valide


    W_COD_ERR003 is a constant that I use for the LookUp (in the other cases I have w_cod_err001, 2, ...)
    Index de colonne non valide in french means: Column index not valid

    I don't understand, if I execute the step in another job and delete all steps, it runs correctly.
    In the image the Database Lookup object in the detail.

    Name:  Err index.jpg
Views: 137
Size:  23.6 KB

  2. #2
    Join Date
    Oct 2008
    Posts
    17

    Default

    I resolved my problem. I change the table and delete the lookup

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.