String Too Long Issue

General
1

Hello everyone,

I am constantly facing an issue in pega v24.1.4 m I have a property named ref1 and its length is 20 (at DB and in pega property length as well).. now I have modified it to 35 (in DB and Pega prop level). I have saved the tables of the associated classes.. even tried restart… But when I am entering any value of length > 20 it is showing me an error ‘string too long’. Trird revalidate and save, restart, clearing rule cache, conclusion cashe but still not working… Any help would be appreciated!!

2

I believe you’ll need to update it at the database level because the column has already been created with the current length. Overriding the length in the UI does not automatically update the corresponding column size in the database.

Alternatively, you can create a new property with the desired length and use that instead.

3

As I have already mentioned, that I have altered the DB column length to 35.

4

Can you please resave the database table instance in Pega and check again?

5

Not working .. I have resaved the DB table instance.

6

Hi @Himalaya_Sudan ,

Mostly having the configuration issue or Cache issue

  1. Save the Class and DB tables of respective property and table

  2. Revalidate DB table, Property and Class

  3. Try Execute Perform reassemble action this property

  4. Restart your Pega server

I hope this will help you

Thanks,

Ashok

7

This issue is usually caused by metadata caching or another rule still enforcing the old length, rather than the database column itself. Since you’ve already updated both the database column and the Pega property, restarted the server, and cleared caches, validate the following:

  1. Check whether another property rule is being resolved(most common)

Use Actions > View XML or Tracer to confirm which property rule is actually being resolved. There may be another property with the same name in a higher ruleset version or different class still defining the length as 20.

  1. Verify the property rule actually has Length = 35

Open the property rule and confirm:

Max Length = 35
Save and check in the highest available ruleset version.
Ensure there isn’t a checked-in older version being picked up by rule resolution.

Although you’ve altered the column, confirm the actual column length using the database:

DESC <table_name>;

or query the data dictionary to ensure the column is indeed VARCHAR(35) or equivalent.