tools.saveRecord Error

Products

• CA Business Service Insight

Issue/Introduction

Running tools.saveRecord in a Business Logic script to write a value to t_slalom_outputs returns an error:

"SaveRecord: You used a value which is too long. The value should not exceed 50 characters."

 

Environment

CA Business Service Insight 8.3.x and 9.x

Cause

Defined limit for fields in T_SLALOM_OUTPUT

Resolution

Update the t_system_configurations by performing the following:

1.  Run the following query against the BSI database

update t_system_configurations set sys_config_value='100' where sys_config_name like 'sizeofvaluefield' 

2.  Run the following command to commit the change

Commit;

3.  Restart the BSI service and run iisreset on the BSI Web server