We were able to resolve the problem by changing the IN syntax to user ||

Hello, we are having the same error message with a similar query.   Were you able to resolve this issue?
If so, what was the resolution?