Content downloads fail. Length of LOB data (654136) to be replicated exceeds configured maximum

Version 2

    Verified Product Versions

    Endpoint Manager 9.6Endpoint Manager 2016.xEndpoint Manager 2017.x

    Issue

    When attempting to download the latest content, vulnerabilities fail to download. An error is displayed with the following error in your vaminer.details.log

     

    04/24/2018 11:07:54 INFO  138068:Main Thread : Failed to download MS18-04-IE-4092946_INTL.
    04/24/2018 11:07:55 INFO  138068:VulnerabilityTOC.SaveToDBThread.2 : Vulnerability.UpdateVulnerabilityLeanXML failed: Length of LOB data (654136) to be replicated exceeds configured maximum 500000.
    Use the stored procedure sp_configure to increase the configured maximum value for max text repl size option, which defaults to 65536. A configured value of -1 indicates no limit, other that the limit imposed by the data type.
    The statement has been terminated.
    

     

    Cause

    This issue is caused by your databases LOB data unable to be replicated past a specific size. When the text replication doesn't have the allowed size it will fail to download the vulnerability. In some cases it will delete any vulnerability that already exist in the database. i.e vulnerabilities that are being updated by the Ivanti EPM servers.

     

    Solution

    The simplest solution to this issue is to either increase or make unlimited the size of the replication text size. There are several ways to do this but the simplest way is through Microsoft SQL Server Management Studio.

     

    1. In Object Explorer, right-click a server and select Properties.
    2. Click the Advanced node.
    3. Under Miscellaneous, change the Max Text Replication Size option to the desired value. You may use -1 to indicate an unlimited amount

    For additional methods and more information please visit: Configure the max text repl size Server Configuration Option | Microsoft Docs