MID error: Field(s) present in the query do not have permission to be read com.glide.processors.soap.SOAPProcessingException: Field(s) present in the query do not have permission to be read


Description

MID server fails to connect to the instance with following error:


12/14/20 10:44:28 (806) StartupSequencer DEBUG: HTTPClient.registerOtherProtocols() starting on Thread Thread[StartupSequencer,5,main].
12/14/20 10:44:28 (897) StartupSequencer WARNING *** WARNING *** Method failed: (https://<instance-name>.service-now.com/ecc_agent_property.do?SOAP&displayvalue=all&redirectSupported=true)HTTP/1.1 500 Internal Server Error with code: 500
12/14/20 10:44:28 (900) StartupSequencer SEVERE *** ERROR *** getRecords failed (com.glide.processors.soap.SOAPProcessingException: Field(s) present in the query do not have permission to be read com.glide.processors.soap.SOAPProcessingException: Field(s) present in the query do not have permission to be read)
12/14/20 10:44:28 (900) StartupSequencer SEVERE *** ERROR *** Failed to execute remote query: Method failed: (https://<instance-name>.service-now.com/ecc_agent_property.do?SOAP&displayvalue=all&redirectSupported=true)HTTP/1.1 500 Internal Server Error with code: 500
12/14/20 10:44:28 (900) StartupSequencer SEVERE *** ERROR *** Failed to load remote properties: null
12/14/20 10:44:28 (901) StartupSequencer WARNING *** WARNING *** Encountered error: [Unable to load remote properties from the Config] while starting up the service. Retry...

Release or Environment

All

Cause

MID server user needs to be able to access the sys_public table, there maybe a custom ACL that is blocking that from happening

Resolution

Either remove the blocking ACL or add mid_server role to that ACL so that MID server user can access and read sys_public table.