dhis2-devs team mailing list archive

[Lars Helge Øverland <larshelge@xxxxxxxxx>]

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 <gichangijohn3@xxxxxxxxx>
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@xxxxxxxxxxxxxxxxxxx
> 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>