Duplicate user discovery columns are created in Configuration Manager

View products that this article applies to.

Symptoms

After System Center Configuration Manager current branch is updated to version 1810, multiple duplicate columns may be created in the user discovery data table (User_DISC). If this occurs, features that rely on Active Directory User Discovery data, such as collection or query results, or user-targeted software deployments, may return incomplete or incorrect results.

This scenario occurs if the following conditions are true:

You update to version 1810.
Additional attributes are collected by Active Directory User Discovery.
A repeated mismatch exists between the currently specified case of the attribute and a previously entered case for the attribute, as specified in the Configuration Manager console.

For example, this scenario may occur if you manually add the “Description” attribute in the Configuration Manager console, remove it, and then restore it to Active Directory User Discovery in lowercase format.

Because columns are continually added until the problem is corrected, the SMS_Message_Processing_Engine.log file may contain errors that resemble the following.

Note The specific SQL exception text may vary.

Undefined or max length increased discovery property: description~~
Updating discovery schema for architecture User with 1 undefined discovery properties~~
Created column generation xml for global table. <COLUMN NAME="description675" TYPENAME="NVARCHAR" MAX_LENGTH="32" />~~
Created table begin xml for global table. <TABLE NAME="User_DISC">~~
Created table end xml for global table. </TABLE>~~
ERROR: Sql exception when handle schema change. System.Data.SqlClient.SqlException (0x80131904): A .NET Framework error occurred during execution of user-defined routine or aggregate "spModifyGlobalTable": ~~System.Data.SqlClient.SqlException: Request submitted with too many parameters. The maximum number is 2100.~~

If this occurs, disable Active Directory User Discovery, and then contact Microsoft Support to correct the data issues in the environment.

This update prevents the discovery data issue after you update to version 1810. However, corrective action from Microsoft Support is necessary for any affected customers.

To determine whether a site has encountered or is susceptible to this issue, and to avoid it before you update to Configuration Manager version 1810, see 4490434: Duplicate user discovery columns in ConfigMgr- Detection Script.

↑ Back to the top

Update information for System Center Configuration Manager, version 1810

This update is available for installation in the Updates and Servicing node of the Configuration Manager console on version 1810 sites.

If the service connection point is in offline mode, you must reimport the update so that it is listed in the Configuration Manager console.

For more information, see Install Updates for System Center Configuration Manager.

Prerequisites

You must have System Center Configuration Manager, version 1810 installed to apply this update.

Restart information

You do not have to restart the computer after you apply this update.

Update replacement information

This update does not replace any previously released update.

File information

File attributes

The English version of this update has the file attributes (or later file attributes) that are listed in the following table. The dates and times for these files are listed in Coordinated Universal Time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time item in Control Panel.

For System Center Configuration Manager current branch, version 1810