Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Insert / Update - Invalid Column Index

  1. #1
    Join Date
    May 2012

    Default Insert / Update - Invalid Column Index


    We have recently started to see this error when pushing data from a source Oracle DB to a target Oracle DB. The table schema is exactly the same on both yet when we have a transformation with just a simple table input and insert / update we get this Error setting value #23 [BigNumber] on prepared statement Invalid Column index.

    There are only 22 columns yet in the offending row error line it has duplicated the first column and suffixed with _1

    Pentaho logs attached but you can see a duplicate line. Note the problem also occurs on the update step as per the logs

    2016/11/15 10:59:05 - Update.0 - Field [DE_ROREVIEWID] has nr. 0
    2016/11/15 10:59:05 - Update.0 - Field [DE_ROREVIEWID] has nr. 0

    DE_ROREVIEW Bug.txt

  2. #2
    Join Date
    Mar 2016


    Hello Menphis,
    I have similar issue. Have you found the root cause?

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.