Live Message related errors

[KritiSrivastava]

Few of our users are seeing errors when working on instance. It is related to live_message. I also checked ACLs, not sure what has to be modified to resolve this. Or if there is some system property. 

The error message is "Part of the query on live_message has been ignored because of read security rules on live_message.chat_message & Part of the query on live_message has been ignored because of read security rules on live_message.state".

Please help..

[Kelly Logan]

Same issue seen here, on Washington DC Patch 4, so upgrading to the latest seems to have *caused* the issue. Any other solutions yet? 

 

 

[hvolkart]

The message appears when using the global search.

I tried to deactivate search source
/sys_search_source_list.do?sysparm_first_row=1&sysparm_query=source_tableSTARTSWITHlive&sysparm_view=
which didn't help.

So I deleted the search source "Live Feed - Live Feed Messages" on table live_message.

Now the annoying error messages are gone.
(ok - I backed up the xml file before...)

SN's proposal as described and mentioned in the discussion below
Error: Part of the query on live_message has been ignored because of read security rules on live_mes...

doesn't seem very helpful:
1. adding itil role didn't help
2. giving live_feed_admin role to hundreds of active users helps. But: come on!?

3. preventing ACL error messages in general: not the way I like

[Thomas G]

I agree with you, that preventing ACL error messages in general is not a particular elegant way to "fix" it. I hope that ServiceNow is looking in to the error in a future patch so that I can set glide.db.encoded_query.field_acl_error_msg to true again without getting the error.

Best regards
Thomas

[Dlam]

Can I just mark the search source "Live Feed - Live Feed Messages" on table live_message inactive?

[ChetanT38862099]

Yes! It seems to be working for me. 🙂