Unable to create Software Update Policies for more than 3 Bulletins
Last Updated January 28, 2016
Able to download as all of the Software Bulletins in the Patch Remediation Center, but when running the Software Update Policy Wizard, it fails if more than 3 Microsoft Bulletins are included. Confirmed the process is able to finish for all other vendors without failure.
'Unable to execute stored procedure tmInserInputParameterValue'
Length of LOB data (164388) to be replicated exceeds configured maximum 65536. Use the stored procedure 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.
Configurations in the SQL Database set the LOB length limit and the single insert or update statement data size for any of the replicated text column processes violates this limit.
Work through the following resolution:
Open the SQL Server Management Studio.
Execute the attached SQL Script against the Symantec_CMDB (default database name for SMP Server) Database.
Advisory: Always ensure there is always a backup of the database before executing any scripts against the Symantec_CMDB database
Subscribing will provide email updates when this Article is updated. Login is required to Subscribe