Advance Query error

Advance Query error

  

Hi,

I have an advance query that returns values when tested with input parameters, but when I try to run it in  a process it returns the following error: "Error in Advanced Query.....Incorrect syntax near ')'". The query has 17 joins (not sure if there is a limitation on this?)
Any suggestion is appreciated.

Thanks

Regards

Chiara
You are probably getting one of the arguments in an incorrect format, since you said using test query works.

Try to debug it and stop in the query you mention and check the variables being passed to see if you catch any suspicious value.

Best regards,
PC