dhis2-devs team mailing list archive

[Gichangi John <gichangijohn3@xxxxxxxxx>]

Hi

Each time i run the Analytics tables update the following error of process
failed

Process failed: StatementCallback; uncategorized SQLException for SQL
[CREATE VIEW "_view_itengetorganisationunit" AS SELECT
ou.organisationunitid, ou.name, ou.parentid, ou.shortname, ou.coordinates,
ou.lastupdated, ou.latitude, ou.longitude, ou.created, ou.uid, ous.level,
ou.featuretype , ou.code from _orgunitstructure ous join organisationunit
ou on ous.organisationunitid=ou.organisationunitid]; 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


What could be causing this failure