Question
Cognizant Technology Solutions
IN
Last activity: 13 Oct 2016 0:43 EDT
Unable to increase maximum length of a property
The property is already exposed in DB with max length in advanced tab of the property as 200. Now i need to increase the maximum length field to 225 in Pega 7.
As property is eposed in DB.unable to increase max length.
Error message:property is exposed in a database column, 225 has been changed to 200 to conform to base property definition.
Withdrawn the rules in current RSV and save the rule to higher RSV.this also doesn't help to resolve the issue.
Kindly help me to resolve this issue.Thanks in advance.
-
Like (0)
-
Share this page Facebook Twitter LinkedIn Email Copying... Copied!
Areteans Technologies
AU
Drop the column in DB and add with desired length. Take a backup of table before dropping
Cognizant Technology Solutions
IN
Hi Dharanitharan,
We have increased the size of the column in DB also to 225. still the error occurs.
Cognizant Technology Solutions
IN
Hi Dharani,
i am able to save the property but still the validation being performed for the old value. Could you please suggest me any way to overcome this.
Pegasystems Inc.
IN
I have tried the same scenerio on my instance . I got the same error as you get when I change the Max length and on save BUT when I tried to save again(Clicked save button with the error on screen) I was able to save the property. I have verified that DB table column max length also changed.[Note: always test/try anything related to DB tables on some test data types or for existing data types have a backup]
Cognizant Technology Solutions
IN
Thanks Kodup,Able to save the property. still the error appears if i give value for the fields with character more than 200 and less than 225.
Navy Federal Credit Union
US
What you tried is perfectly correct, I use to do the same. but instead of saving the rule higher RSV, create the property in higher RSV with same name.. save as will not work.
Cognizant Technology Solutions
IN
Hi Sai,
withdrawn the rule in current RSV and create a property with same name in higher RSV.I am able to save the property rule without error now.
when i populate the field with more than 225 char, the error is displayed in the screen( which is expected behaviour)
when i populate the screen with more than 200 char and less than 225 -->Error is not shown in portal and Step page is populated with error message((HN-FW-RMCFW-Data-IDCard-TagTxtOvrd)StringTooLong "When we need to select from a large list of dynamically populated values then we give the control as When we need to select from a large list of dynamically populated values then we give the we give..." 200) due to which it is not saved in DB.
please suggest to overcome this error.
Thanks,
Sindhuja Sambu
ANZ
AU
Hi,
Please find the below link which states the issue you are facing.
https://pdn.pega.com/community/pega-product-support/question/increasing-maximum-length-property
Cognizant Technology Solutions
IN
We have increased the size of the column in DB also to 225. still the error occurs.
Pegasystems Inc.
AU
Have you re-saved the Data-Admin-DB-Table instance (or pressed 'Test connection') to ensure the schema is refreshed?
Pegasystems Inc.
GB
Can you try the following after increasing the column in the schema
1. Open the class rule form
2. Do a test connection
3. Save the class rule form
4. Open Data-Admin-DB-Table instance of the class
5. Do a test connection
6. Save the Data-Admin-DB-Table instance
Areteans Technologies
AU
Please find the attachment as discussed @ sindhuja