Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: ERROR: INSERT has more expressions than target columns

  1. #1

    Default ERROR: INSERT has more expressions than target columns

    I am receiving this error from a transform chain:

    TableInput --> JS --> SelectValues --> TableOutput

    In select values I've only mapped 21 of the 31 available fields because there is no corresponding data in the input for the other 10 fields. This data will be added later. But when I run this transform it always errors:
    ERROR: INSERT has more expressions than target columns

    and when you check the fields against the values there are more values than fields.

    TableOutput appears to be trying to add more values than available INSERT fields?

    UPDATE:
    It also looks like the fields and values are not in a proper alignment. The values are aligning with the input table and the fields are aligning with the output of SelectValues.

    Gerry
    Last edited by greno; 10-15-2007 at 09:34 PM.

  2. #2

    Default

    I cleared all DB caches and restarted Spoon and the error is gone now, hopefully never to return!

    Gerry

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.