Invalid parameter index 1 error

Document created by Nikita_nandakumar on Jan 22, 2014
Version 1Show Document
  • View in full screen mode
This error usually occurs at the database connector whose operation defines a SQL statement.

Please double check the following :

1)Check  if the SELECT statement is defined as per the syntax.You can run the script outside Boomi using SQUIRRELSQL client.

2) Check if the fields return values.The Boomi process will be expecting values to be returned from the table based on the DB profile defined.When there is no value returned from the table,the process fails with the above error.We would recommend to use a program command shape instead if you don't require to return values from the table.

For reference :