Is it possible to change the column size that is already optimized?
Is it possible to change the column size that is already optimized?
If yes, please let me know how to do that.
***Edited by Moderator Marissa to update platform capability tags***
Pegasystems Inc.
IN
Hi,
Yes you can do that.
Refer the below link for the approach
https://collaborate.pega.com/discussion/alter-db-column-size-while-optimizing-properties
https://collaborate.pega.com/question/increasing-size-column-pega
Thank You
EY Advisory & Consulting Co., Ltd.
JP
Thank you for your support.
I checked "Modify Schema" but the subjected property was disabled so I was not able to change the column size.
How can I change it?
Best Regards,
Pegasystems Inc.
IN
I might need to check this but if you looking for quick solution and if you have access to DB, change this from backend itself and restart to apply changes.
Bits In Glass
GB
Hi
Here we have two options
- If your server is on cloud, then ask pega team to increase column size in database. For this you need to raise a Pega SR.
- If you have Database access then you can change the column size using alter table statement
Thanks
EY Advisory & Consulting Co., Ltd.
JP
Thank you for your support.
＞If your server is on cloud, then ask pega team to increase column size in database. For this you need to raise a Pega SR.
I will try it.
Pegasystems Inc.
US
When you open the SR, please reference this post and let us know the SR Id here for tracking.
Thank you!