Question

3
Replies
253
Views
yapj1 Member since 2015 32 posts
PEGA
Posted: 1 year ago
Last activity: 1 year 4 months ago
Closed

Can I have an exposed column that contain data as long as 500 chars?

Hi,

Can I have an exposed column that contain data as long as 500 chars? (In Oracle, I can declare a column that is VARCHAR2 with 2000 chars)

I had created a TEXT property, exposed the column and then tried to insert that column with string of around 400 chars, but Pega throws an error.

I went to the DB, increased the column size of that column to VARCHAR2 with 500 chars.

I also went to that Pega property and check the setting, the max length was somehow automatically set to 256 (Done by Pega during exposing column?). I then change it to 500, but Pega does not allow it, so I just cleared it and save that property.

After that, I go to the Pega Database Table record and resave the class to DB table mapping record of that class.

However, when I retry, it still throws the same error, stating that the max length is 256.

My questions:

1) Can I have an exposed column that is more than 256 chars in Pega? (In Oracle DB, I have defined column that is 2000 chars before.) If yes, how can this be done? (putting performance, etc. aside first, I want to know if Pega explicitly disallowed this)

2) What is the recommended procedure to unexpose a column? I deleted the column in the DB table itself, and also removed the record in the Log-System-PropertyOptimization, I also saved the class database table mapping record entry. This would technically means that this column is now only in BLOB. However, when I try again, I still receive the 256 max length error. It seems to suggest to me that apart from the DB table, I also need to delete the Pega property and recreate it again?

Thanks in advance and looking forward to any advice on the above.

Regards,

Jacky

Low-Code App Development Data Integration
Moderation Team has archived post
Share this page LinkedIn