Error: Process failed: StatementCallback; SQL [create table if not exists analytics_event ERROR: tables can have at most 1600 columns

Getting the above error when trying to Run Analytics table in the System Admin module, is there a work around this?

ERROR: tables can have at most 1600 columns; nested exception is org.postgresql.util.PSQLException: ERROR: tables can have at most 1600 columns

1 Like

@drlappies

Thank you for your post! This issue happens when the number of data elements that are being run in analytics table export exceed the number 1600 (1600 is the number of columns limit in Postgresql tables, source)

A feature request had been created to fix this: [DHIS2-11720] - Jira