Error "Synchronize Portfolio: Unknown error" when trying to sync Portfolios.
The job fails with error:
PSQLException: Error tables can have at most 1600 columns.
In the bg-ca logs, an error is noted in relation to the table that causes the problem (different tables may be involved!):
ALTER TABLE TEMP_PFM_CA_IDEA ADD TEST bigint NULL] ERROR 2021-06-29 08:10:26,818 [Dispatch Synchronize portfolio investments : [email protected] (tenant=clarity)] job.PFMSyncManager (clarity:admin:21265500__1E4F9A7E-9ED3-480E-B55A-66EF5584EF66:Synchronize portfolio investments) com.niku.dbtools.DBUpdateException: org.postgresql.util.PSQLException: ERROR: tables can have at most 1600 columns
By design, Postgres has a limitation of 1600 columns for a database table.
When a column is removed from a table, Postgres will still count the deleted columns toward the limitation count.
The TEMP tables such as TEMP_PFM_CA_PROJECT, TEMP_PFM_CA_IDEA and others, have columns added and removed as a part of their general usage.
Release : 15.9.2, 15.9.3
Component : CLARITY PORTFOLIOS
Fixed in 16.0 and 22.214.171.124 as DE61489,
Once the limitation is reached, the only way to reset the count would be to perform the following:
The backup does not retain the older deleted column information, so the restore will not have that information either.
See also: Clarity frequently reported issues