Is there any limitation for the number of custom columns that can be added to the CHG table?
Article ID: 53161
Updated On:
Products
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.
Feedback
