Pega 8.5 error : Table can't have more than 1600 columns
We are using surveys in pega 8.5, which are cases in this version.
We also have several cases whose classes point to our main Work class : EXAMPLE_Work.
Each simple question our property on our surveys is a column on EXAMPLE_Work.
Hence, starting from a specific number of columns in EXAMPLE_Work, we have an error stating that there can't be more than 1600 columns in a table.
So we tried to free some space by deleting columns. From 1600, we only have 160 remaining.
Yet, the error still persists and we can't edit or save any of our cases in EXAMPLE_Work, even after the 1440 deletions, as shown in the following screenshots.
We are using Postgres as a database.
Accepted Solution
Updated: 24 Jun 2021 8:46 EDT
Capgemini
FR
After investigating the issue with a DBA, it is due to a Postgres specification that the Alter table for deleting columns applies the changes to Pega tables but only hides columns in PG.
So basically there were still 1600 columns.
Proximus
BE
Hello,
Have you checked the table itself in your DB? is it also showing 160 columns?
Since the table is much smaller and with very few lines, you could maybe consider rebuilding it from scratch.
Regards
Anthony
Accepted Solution
Updated: 24 Jun 2021 8:46 EDT
Capgemini
FR
After investigating the issue with a DBA, it is due to a Postgres specification that the Alter table for deleting columns applies the changes to Pega tables but only hides columns in PG.
So basically there were still 1600 columns.