Support-Tip: (SYNC): Unexpected Error – 0x8023044d (SQL operation fails because of data overflow.)

 

NOTE A Support-Tip is the Problem / Cause / Resolution of a specific issue.

 

ENVIRONMENT

  • Microsoft Identity Manager 2016 (4.3.1935.0)
    • Extensible Management Agent v2.0

 

PROBLEM SCENARIO DESCRIPTION

  • In the execution of a Full Synchronization on a ECMA v2 connector, several objects return an “unexpected error” in the Synchronization Errors section of the Synchronization Service Manager Console.

 

INVESTIGATION

  • An “unexpected-error” in the Synchronization Service Manager Console does not provide adequate information to lead to resolution. The best place to start with an “unexpected-error” is the Application Event Log, because that means that a stack trace was provided from another part of the Synchronization Service Engine. We can find more information on the “unexpected-error” on Microsoft TechNet (https://technet.microsoft.com/en-us/library/jj590332(v=ws.10).aspx)

 

unexpected-error This error occurs when the synchronization engine tries to apply a change to the metaverse (including provisioning and export attribute flow). This error can only occur during runs which apply changes to the metaverse. Check the event log for more information.

 

  • If you would like to get information about the Synchronization Errors dumped out, you can save that specific Operations Record that through the error to a XML file. There you will be able to grab the information about the object that is throwing the error message.

 

 

APPLICATION EVENT LOG – EVENT ID 6301

Log Name:      Application

Source:        FIMSynchronizationService

Event ID:      6301

Task Category: Server

Level:         Error

Description:

The server encountered an unexpected error in the synchronization engine:

 

“BAIL: MMS(16188): ..\sql.cpp(3288): 0x8023044d (SQL operation fails because of data overflow.)

BAIL: MMS(16188): ..\sql.cpp(3180): 0x8023044d (SQL operation fails because of data overflow.)

BAIL: MMS(16188): ..\mvobj.cpp(901): 0x8023044d (SQL operation fails because of data overflow.)

BAIL: MMS(16188): ..\synccoreimp.cpp(2666): 0x8023044d (SQL operation fails because of data overflow.)

BAIL: MMS(16188): ..\synccoreimp.cpp(4744): 0x8023044d (SQL operation fails because of data overflow.)

BAIL: MMS(16188): ..\synccoreimp.cpp(10417): 0x8023044d (SQL operation fails because of data overflow.)

BAIL: MMS(16188): ..\synccoreimp.cpp(4166): 0x8023044d (SQL operation fails because of data overflow.)

BAIL: MMS(16188): ..\synccoreimp.cpp(3953): 0x8023044d (SQL operation fails because of data overflow.)

Forefront Identity Manager 4.3.1935.0”

 

CAUSE

  • In this particular case, we found that the issue was pertaining to the data-type of the Metaverse attribute. The Metaverse Attribute was an Indexed String Attribute, which limits the amount of data that you can put into the attribute.

RESOLUTION

  • The resolution to this issue, is to utilize a non-indexed string attribute to flow your data.

 

ADDITIONAL INFORMATION ON UNEXPECTED-ERROR

Troubleshooting FIM: Synchronization Error: Unexpected-Error on a single object: https://social.technet.microsoft.com/wiki/contents/articles/16555.troubleshooting-fim-synchronization-error-unexpected-error-on-a-single-object.aspx

ADDITIONAL INFORMATION

Troubleshooting Generic FIM Synchronization Errors: https://social.technet.microsoft.com/wiki/contents/articles/2047.troubleshooting-generic-fim-synchronization-errors.aspx

PRODUCT DOCUMENTATION ON UNEXEPCTED-ERROR

Management Agent Run Error Codes: https://technet.microsoft.com/en-us/library/jj590332(v=ws.10).aspx