Question
Salame
Last activity: 25 Aug 2016 11:27 EDT
Reverting optimization on property
Hello,
Is it possible to revert the optimization of a certain property already exposed?
Thanks,
Rosy
Message was edited by: Lochan to add Category
-
Like (0)
-
Share this page Facebook Twitter LinkedIn Email Copying... Copied!
Accepted Solution
Pegasystems
IN
You need to drop the column from the database and then resave the Data-Admin-DB-Name instance for that table for changes to take effect.
PEG
IN
I don't think there is an option to unexposed the property from exposed property. We can expose the property from unexposed property and vice version wouldn't be possible.
Salame
thanks a lot
Capgemini UK Plc
IN
Just curious to know, what will happen if we remove the corresponding column from table in database!!!
PEG
IN
If you follow the steps mentioned by Rajeev, property gets un-optimized.
Accepted Solution
Pegasystems
IN
You need to drop the column from the database and then resave the Data-Admin-DB-Name instance for that table for changes to take effect.
Salame
Thanks a lot Rajiv
Rajiv, I understand this process is to un-expose the column.
Just out of curiosity, When we drop the column from the DB, what would happen to the existing values of that property? Will they still be retained?
Pegasystems
IN
If the table has a BLOB (pzPVStream) column, the data for that property (which mapped to the dropped column) will be retained there. But if the table doesn't have BLOB, and the column is dropped, subsequent saves might fail if the clipboard page contains a value for this property whose corresponding column no longer exists.
-
Mounisha M
U.S. Bank National Association
US
Hi Rajiv,
We encounted a problem (V 6.2 SP2) :
There is an existing property which has been optimized for classes, and later the column has been removed from the respective tables.
Recently we saved as this property into higher RSV and just updated the max length.
Then we found that the coulmn has been exposed again into the tables.
Could you please suggest how did this happen ?? We haven't done any optimiation using wizard/any utility. It was just a save as of the property.