Unable to apply or update SEE Device Control 8.2.x User Based Policy on client machine.
Errors found in the Logs : -
2012-08-16 08:37:01.655675] [Error] [PolicyWebServiceLogic] [IIS APPPOOL\SymantecEndpointEncryptionDeviceControlAppPoolWS] - Failed to handle User policy request by client
computer1.contoso.local (Domain\UserWithSmartCard) (RetryLater):
Safend.Utils.Exceptions.DB.DBException - String or binary data would be truncated.
The statement has been terminated.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at Safend.Backend.Server.DB.MsSql.MsSqlDBProvider._ExecuteNonQuery(IDbCommand comman
# SQL Profiler Logs
ent id="13" name="SQL:BatchStarting">
Total character count of Active Directory Groups that SEE Device Control user belongs to exceeds 1,000 character limit of SEE DC SQL database. This value is recorded in the SEE DC database whenever a user requests a new or updated policy from the server and if this character limit is exceeded then the user based policy will fail to apply or update. The character limit is calculated by adding the user's current AD groups numerically via CSV format (without spaces) and is normally not an issue as for example a Win 2008 Server has approximately 30-40 AD groups by default depending on the roles enabled. Any new groups added beyond the default will be assigned a higher numerical value so in rare cases when a customer has an AD environment where the users belong to a large number of custom made groups then the 1,000 character limit may be exceeded. The approximate number of groups needed to exceed this limit varies depending on whether the AD groups have a single, double or triple digit numerical value so the exact number will be between 250-278.
This issue was resolved in SEE Device Control 8.2.8 and later versions as the SQL database character limit was raised from 1,000 to 4,096 in DC 8.2.8. Upgrading the affected client machines to DC 8.2.8 or later should allow them to start receiving user based policies normally. Please see the attached Release Notes for Symantec Endpoint Encryption Device Control 8.2.8 for details.