Do the query with executeQuery() in a trigger and check if there is a message in the "__ERROR__" system variable that indicates what is the problem. You need to turn on Debug Mode when running a case to see it. Also, if you want a detailed error message you need to set in your env.ini file:

amosbatto wrote: ↑Fri Aug 10, 2018 12:05 am
Do the query with executeQuery() in a trigger and check if there is a message in the "__ERROR__" system variable that indicates what is the problem. You need to turn on Debug Mode when running a case to see it. Also, if you want a detailed error message you need to set in your env.ini file: