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

[Reddy]

@KritiSrivastava, I'm also experiencing the same issue. I modified the read ACL on the live_message table, which resolved the issue. However, ServiceNow should fix the problem instead of changing the ACL.

I submitted a support ticket, and they recommended upgrading the instance to the latest patch 3 hotfix 1, but the issue still persists.

[Thomas G]

Here the live_message.* read ACL has live_feed_admin as role and Security Attribute: 'UserIsAuthenticated'. Condition is: LoggedIn=true^ORAllowUnauthRolelessAcl=true

Did you simply remove the live_feed_admin role, or how did you modify it?

[Reddy]

@Thomas G I added the ITIL role to the live_message.* read ACL.

[Thomas G]

Same issue here both on Vancouver Patch 9 and Washingtondc Patch 3, hotfix 1.
It seems that it only happens here for non-admin users (an ITIL user for instance) when a ticket number is entered in global search and the user then clicks on the ticket number on the search result list. It does not happen if  the same user is going directly to an incident from incident.list for instance. I can not see any ACL changes on the live_message table lately though. 

Best regards
Thomas