dhis2-users team mailing list archive

[Marko David Garcia <markodavidgm@xxxxxxxxx>]

Hello all.

When we try to run Analytics tables the system show this error:

Process failed: StatementCallback; uncategorized SQLException for SQL
[CREATE TABLE _orgunitstructure ( organisationunitid INTEGER NOT NULL
PRIMARY KEY, organisationunituid CHARACTER(11), level INTEGER, "idlevel1"
INTEGER, "uidlevel1" CHARACTER(11), "idlevel2" INTEGER, "uidlevel2"
CHARACTER(11), "idlevel3" INTEGER, "uidlevel3" CHARACTER(11), "idlevel4"
INTEGER, "uidlevel4" CHARACTER(11), "idlevel5" INTEGER, "uidlevel5"
CHARACTER(11));]; SQL state [25P02]; error code [0]; ERROR: current
transaction is aborted, commands ignored until end of transaction block;
nested exception is org.postgresql.util.PSQLException: ERROR: current
transaction is aborted, commands ignored until end of transaction block

Dhis version: 2.20
Build revision: 20001

Over the Build revision 19841, works fine.

Thank you very much.

Best regards


*Marko David Garcia M.*