Hi John, could you try to first delete the SQL view called "itenget organisationunit" or similar, run analytics again and see if that avoids the error?
regards, Lars On Mon, Dec 14, 2015 at 5:14 PM, Gichangi John <gichangijo...@gmail.com> wrote: > 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 > > _______________________________________________ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : dhis2-devs@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > > -- Lars Helge Øverland Lead developer, DHIS 2 University of Oslo Skype: larshelgeoverland http://www.dhis2.org <https://www.dhis2.org>
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
