Service Catalog Form Scripts Size Limit

Products

• CA Service Management - Service Desk Manager
• CA Service Desk Manager
• ServiceDesk
• CA Service Catalog

Issue/Introduction

There is a problem at the moment of saving script changes on Service Catalog forms. If the size of the script is bigger than 1200 lines, an error message is returned.

Error message translation:  An error has occurred: Please contact your system administrator.

However, a shorter script can be saved without any problem.

When trying to insert the code into database in the table "usm_form_component_attrib_ext" this error message was returned:

Msg 7139, Level 16, State 1, Line 1 Length of LOB data (94896) to be replicated exceeds configured maximum 65536. 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.

Environment

Release : 17.x

Resolution

Right click on the Server name and select "Server Properties", then go to the "Advanced" tab.  Modify the max text replication size, setting it to a higher value.