Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Discussion

 SATHYA MANOHARAN G (SathyaG_Incessant)
INCESSANT TECHNOLOGIES

INCESSANT TECHNOLOGIES
IN
SathyaG_Incessant Member since 2014 3 posts
INCESSANT TECHNOLOGIES
Posted: Jun 14, 2016
Last activity: Jun 14, 2016
Posted: 14 Jun 2016 4:16 EDT
Last activity: 14 Jun 2016 7:01 EDT
Closed

Alter DB column size while Optimizing Properties

In PEGA 7, When i optimize a text property, I don't see any options to set the size of it.

By default It is created as Varchar(32). What should i do if i want to create them as VarChar(max) when i optimize it?

 

Regards

Sathya G

To see attachments, please log in.
Data Integration

Posted: 8 years ago
Posted: 14 Jun 2016 5:24 EDT
Phani Sahukaru (sahup1)
Pegasystems Inc.
Phani Sahukaru
Pegasystems Inc.
IN

could you please check if the property is defined with max length under advanced tab? or if blank by adding some length helps in generating the required SQL?

To see attachments, please log in.
Posted: 8 years ago
Posted: 14 Jun 2016 7:01 EDT
Ravi Padwal (RaviP@incessant)
NIIT Technologies Limited

NIIT Technologies Limited
AU

Hi Sathya,

Do you have database access?

If yes, go to database and alter the column length to varchar(max), then resave the corresponding Data-Admin-DB-Table instance, this should work.

To see attachments, please log in.

Related content:

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice