This error is logged on the Microsoft SQL Server for the Symantec Endpoint Protection Manager (SEPM) database. The SEPM does not experience any particular symptoms and appears to be functioning correctly.
[DATE] [TIME] [SPID] Error: 7886, Severity: 20, State: 1.
[DATE] [TIME] [SPID]
A read operation on a large object failed while sending data to the client. A common cause for this is if the application is running in READ UNCOMMITTED isolation level. This connection will be terminated.
The issue is from a getMetadata SQL query which is executed during Liveupdate.
The query that can cause this is:
SELECT NAME, CHECKSUM, DELETED, ID, REF_ID, OWNER, TIME_STAMP, TYPE, USN,
DOMAIN_ID, DESCRIPTION, CONTENT FROM BASIC_METADATA WITH (NOLOCK) WHERE ID =
CONVERT(CHAR(32), @P0 ) AND DELETED > 0
The query is ran with the "NOLOCK" hint, this hint is used to improve performance by not locking the database tables. When one or more objects being retrieved by this query are modified before the statement completes, the query will be aborted and the SQL error will be generated.
This error can occur due to a large variety of environmental factors, some of which cannot be prevented by the current design of the Endpoint Protection Manager. This error will not impact SEPM functionality as the read operation will simply be run again. In order to reduce the number of instances of this error, you can attempt the following workarounds.