i am not increasing the size of property max length.
i am increasing the size of the column size directly from DB because after optimize property for reporting,
by default pega create table pr_index_(CLASS NAME)
on this table they have column called pxIndexPurpose created with 32 byte size.(can't sett the default because it was create automatically by pega when we optimize property for reporting)
i need to change it to 64 byte because when i try to save on my property that was optimize for reporting i get this error : The key property pxIndexPurpose in database PegaDATA, table pr_Index_ASM_FW_GISFW_Data_Pay is too big for its column; column size: 32, property size: 45, property value:.
the pxIndexPurpose value is around 45 bytes.
I have found the solution after create sr to pega, turn out i need to do this in order for pega to be able sync if i modify the column size from DB Directly in order for pega to sync the column size .:
1) Open the table in which the column is available and done the changes in DB. 2) Click on the test connectivity. 3) Save it.