Question

2
Replies
40
Views
Hiba Alami Yanboui (HibaA120)
Capgemini

Capgemini
FR
HibaA120 Member since 2021 1 post
Capgemini
Posted: June 24, 2021
Last activity: June 24, 2021
Posted: 24 Jun 2021 4:11 EDT
Last activity: 24 Jun 2021 8:46 EDT
Solved

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.

Pega Platform 8.5 Case Management Healthcare and Life Sciences System Architect