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.