How to extend the max length for a field in ecc_queue table? - Support and Troubleshooting

How to extend the max length for a field in ecc_queue table?  Description When using ecc_queue table to handle payload from outside, the predefined max_length for any field in this table may not suit the data in the payload and truncate the data. It needs to be extended.

Procedure 1. Increase the max_length value from table dictionary as usual

Like all other tables, user can firstly change the max_length for any field (String based) in a table following below steps.

Here let us take "Name" field as an example.

a. Go to menu [System Definition] > [Tables] and search to open ecc_queue table

b. In the [Columns] list search for [Column name] = name

c. Double click on the [Max length] field to change the max_length value for this field, for example, change from 120 to 140

d. Click on Update to save this change

After above change if users need to double check the max_length value for a field from the database end then you need to contact technical support. Here is a screenshot showing the changed max_length from the database background.

2. Increase the max_length value in associated shard tables

Ecc_queue is a special table to store heavy data traffic in any production environment. As table rotation is enabled on this table so after above change users may still find the new max_length does not apply to the name field. User needs to follow below steps to manually change the max_length value in all shard tables for ecc_queue table.

a. Go to menu [System Definition] > [Table Rotations] and search to open ecc_queue record if any existing record is there

b. In the related list [Table Rotation Schedule], check how many shard tables are being used for ecc_queue table. Normally all the shard table names are in format like ecc_queue000x

c. Follow step 1 to change max_length value to the same for the name field for all the shard tables in table dictionary

Applicable Versions All instance releases