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..

[Marc Roy]

I found that disabling text indexing on the live_message record on the sys_dictionary table seems to prevent the error pop-up. I disabled the option from the list view. 

This is similar to the information reported by Erik Nelson a few weeks ago. 

[iamasifk]

Added 'live_feed_admin' role to 'itil' role and it got fixed.

[ND__Co]

Setting property "glide.db.encoded_query.field_acl_error_msg" to true it's a global mute.

You could always deactivate or add 'live_feed_admin' role on record "Live Feed - Live Feed Messages" in Search Status table - 'sys_search_source' that is related to Live Messages.

This search source does not have any roles associated with it, so it tries to run the query for any user that uses this Search Source.

[DChandlerKy]

I have added the live_feed_admin and itil roles to the search group. I have unchecked "Active" & "Searched" from both the search group and the Text Search Table and this is still happening. I do not wish to suppress error messages from the platform as that's just an invitation for disaster and issues. I do not wish to give 500+ itil users the live_feed_admin role because per SN Documentation, "the live_feed_admin role can configure live feed security and provide access to live feed from content management pages. Administrators can also set up live feed table notifications." Too much access for no reason. That's not a fix - it's a band-aid, at best. 

I don't expect much, but I did create a case with SN. 

[iamasifk]

Do let us know what response you get.