AnsweredAssumed Answered

What does this error mean Parameter index out of range?

Question asked by gouthamr388096 on Oct 19, 2016
Latest reply on Mar 10, 2017 by saibheemesh.mekkineni05917673

I am creating a process that gets data from a database and writes it to another database table.

In my map step I have a SQLLookup where I am writing a select query like so

SELECT a.NNO, A.ID, CONCATINATE(a.FIRSTNAME,a.MIDDLENAME,a.LASTNAME), a.RNO from jjobs a

where a.RNO = RNOID

The RNOID you see above is the input variable to SQLConnection and for output variables I gave same names you see in the query.

 

When I run the query I get this error

 

Embedded message: [Function: Sql Lookup]: DB access error!; Caused by: Parameter index out of range (1 > number of parameters, which is 0).

Outcomes