← Back to team overview

dhis2-devs team mailing list archive

Reaching the limit: 1600 columns (event analytics temp tables)

 

Hi devs,

so, it was difficult, but finally we got there. When we run the analytics,
we are getting the following exception

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

and, yes, we have programs containing above 1600 dataelements,

I'm just writing this email to know if someone here may have a solution for
this, although I'm sure this is a restriction of postgresQL (and in fact,
google says, the only way to change that limit is hacking the core of
postgres...)

Thanks guys
Jose

Follow ups