How to change the column size of a property in production?As in production that column is getting truncated so how to fix this?
Which property type size you want to change, hopefully not the pyLabel or any px,pypz property. Just check if the size is defined on the property and if yes, remove it. work with DBA to alter the table and change the size. hopefully you will do this in lower environments and move the table definitions so all the environments should be in sync.
Done change any OOTB properties, for your own property if you see the value gets truncated, it may be because of you are trying to store more value than defined in the DB. Say property A1 is defined as character varying (32) in DB but you are trying to store a string with 40 character length may lead to this issue. In such case, you may need to find the max value that your business can store and then set the appropriate DB size for that property.
Refer the below link:
Do the steps in lower environment. Manually re-save the Data-Admin-DB-Table instance once the change is done. Then move that instance to production.