SDM: Change Order Table "Effort" field size

Products

• CA Service Management - Service Desk Manager
• CA Service Desk Manager

Issue/Introduction

In earlier editions of Service Desk, the Change Order "effort" field was found to be truncated.  The given field was originally 2000 characters, but in later releases, the field size was reduced to 900 characters.

Environment

Release : 17.1

Component : SERVICE DESK MANAGER

Resolution

The change in the schema, on table Change_Request's "effort" field which reduced the field from 2000 characters to 900 characters, was part of a fix for defect DE52222.  In this defect, a problem was found in which under certain conditions with a given Change Order's effort field, it was not possible to create a given Change Order.  The solution was to reduce the field size that was defined in the schema.

Additional Information

The given defect DE52222 was included in the following SDM releases and maintenance patches and their successor updates:

17.1 RU8 
https://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/business-management/ca-service-management/17-1/Release-Notes/CA-Service-Management-17_1_0_8-Release-Notes/Fixed-Issues---17_1_0_8.html

17.2 RU6 
https://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/business-management/ca-service-management/17-2/Release-Notes/CA-Service-Management-17_2_0_6-Release-Notes/Fixed-Issues---17_2_0_6.html

17.3 
https://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/business-management/ca-service-management/17-3/CA-Service-Management-17_3-Release-Notes/Fixed-Issues---17_3.html