dhis2-devs team mailing list archive

[Gichangi John <gichangijohn3@xxxxxxxxx>]

Hi Lars

Thanks for the quick reply. I dropped the sql view  and the analytics ran
without the error but no data was available on pivot and other reports and
analysis module.
It also takes 30 mins to run the whole analytics as compared to the usual
3-5 hrs.

The analytics issue arose on upgrade to 2.20.



On Tue, Dec 15, 2015 at 11:30 AM, Lars Helge Øverland <larshelge@xxxxxxxxx>
wrote:

> 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>
>
>