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
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.
Release : 15.9.2, 15.9.3
Component : CLARITY PORTFOLIOS