search cancel

Is there any limitation for the number of custom columns that can be added to the CHG table?

book

Article ID: 53161

calendar_today

Updated On:

Products

CA Service Desk Manager CA Service Management - Service Desk Manager

Issue/Introduction

The CA Service Desk (SDM) change order table can accommodate significant number of new columns.

However, there is a limit to the number of columns that can be added to the CHG table.

This limitation is caused by the SPEL code within SDM.

In order to avoid performance degradation and runaway threads, there is a hardcoded number cycle for the spel_srvr in regards to the number of columns for the CHG and CR MDB tables.  

If the columns increase beyond the threshold, there will be negative impact on SDM.

For example, change order templates cannot be copied and the following error message is displayed in the STDLOG:

spelsrvr               45120 ERROR        pcexec.c              6509 Spell interp failed at chg.spl:3707:chg::make_from_template: ilimit exceeded


spelsrvr               45120 ERROR        chg.spl               4792 chg::copy_chg error in make_from_template


web:local              11824 ERROR        freeaccess.spl       19637 copy_chg () failed: error in make_from_template

In the example above, the CHG table has more than 300 new custom columns.

Environment

CA Service Desk Manager 14.1 and 17.x

All Supported Operating Systems

Cause

In order to avoid performance degradation and runaway threads, there is a hardcoded number cycle for the spel_srvr in regards to the number of columns for the CHG and CR MDB tables.  

Resolution

Currently there are no plans to enhance SDM to support a large number of customer fields within the CHG and CR tables.

The suggested solution is to create a new table with the additional columns.

The CHG table should be modified using web screen painter to reference the fields in the new table.

https://techdocs.broadcom.com/us/en/ca-enterprise-software/business-management/ca-service-management/17-3/building/building-ca-service-desk-manager/web-interface-modifications/how-to-modify-schema-using-web-screen-painter.html