How to determin the field that cause of following error message? " Invalid query detected, please check logs for details [Unknown field table in table sys_user]"

[Ryosuke Sugisaw]

How to determin the field that cause of following error message?

" Invalid query detected, please check logs for details [Unknown field table in table sys_user]"

Thank you.

[Akshata jamdar]

Hello Ryosuke Sugisawa,

Please go throught below links,

https://hi.service-now.com/kb_view.do?sysparm_article=KB0758921

https://community.servicenow.com/community?id=community_question&sys_id=983ff7cadb7dcc504819fb243996...

Hope this will helps.

Kindly mark an answer as correct and helpful if it will resolve your query.

Regards,

Akshata

(ServiceNow Developer)

[Ankur Bawiskar · Accepted solution]

Hi,

it seems you are using some field which is names as table which is not present on sys_user table

please check any business rule on that table which contains that field

https://hi.service-now.com/kb_view.do?sysparm_article=KB0758921

https://community.servicenow.com/community?id=community_question&sys_id=983ff7cadb7dcc504819fb243996...

If my answer solved your issue, please mark my answer as ✅ Correct & 👍Helpful based on the Impact.

Regards
Ankur

[jarretjo]

I have the same issue:

On the incident table I removed the "incident.u_affected_user" field and replaced it with task.u_affected

Checked all scripts and there are no references to "incident.u_affected_user"

But in the log the following appears regularly from different users (including myself):

"Invalid query detected, please check logs for details [Unknown field u_affected_user in table incident]"

Ive done cache.do but the error is still coming up.

Any ideas? 

[Adil ELACHIQI1]

Hello, 

The problem also appear if you use addEncodedQuery But you used a "Classic" Query.

Thanks