AnsweredAssumed Answered

When executing stored procedure in Program Command with 2 parameters do I get error "Parameter #3 has not been set"

Question asked by GregHuxley8361 on Dec 5, 2017
Latest reply on May 18, 2018 by GregHuxley8361

Hi,

 

I have a Program Command shape configured as below:

 

 

When it executes it fails with Boomi message "Parameter #3 has not been set", why is this?  I have checked the procedure definition and it definitely only has two parameters: 

 

 

The strange thing is if I hard code the parameter values or only pass one of the parameters, either by name or position then it runs successfully.  Adding a 3rd parameter makes no difference either I just get the error message "Parameter #4 has not been set".

 

Can anybody throw any light on why this happening or what I'm doing wrong?

 

Thanks,

Greg

Outcomes