← Back to team overview

dhis2-devs team mailing list archive

Re: SQL Views Dependency Issue


Hi Lars,

We have two sets of SQL Views,

dnms nutrition last event (A)
dnms nutrition psi pi map(B)

Here A depends on B
dnms risk last event (C)
dnms risk psi pi map (D)

Here C depends on D

Problem is, from above two sets just the first set fails during maintenance
procedure. Following your directions, I tried changing the names of the
views to make B and D come Alphabetically before A and C. Then second set
started to fail during maintenance.  Any reason for this to happen?


On Tue, Oct 4, 2016 at 3:41 PM, Lars Helge Øverland <lars@xxxxxxxxx> wrote:

> Hi Chathura,
> currently the approach to achieve this is to rely on the alphabetical
> ordering of SQL view names. For the scheduled tasks, the system first drops
> the SQL views in *reversed* alphabetical order. Finally, the system
> regenerates the SQL views in alphabetical order.
> So in your case where A depends on B, you should ensure that that the name
> of SQL view B comes before the name of SQL view A alphabetically. This way,
> the system will first drop A, then B, and when it is time to regenerate the
> views, first generate B, then A, and you should be good.
> best regards,
> Lars
> On Tue, Oct 4, 2016 at 11:10 AM, chathura widanage <
> chathurawidanage@xxxxxxxxx> wrote:
>> Dear Devs,
>> We have two SQLViews created in DHIS2 v2.24 where one view depends on
>> other one(Say, A depends on B). We have also scheduled an automatic
>> maintenance event every day at 12.00 a.m. Problem is DHIS2 tries to drop
>> view B first during this automated procedure and as a result whole
>> procedure fails including analytics table generation.
>> Is there a way to make DHIS2 scheduled event drop A before B in above
>> case.
>> Thanks & Regards,
>> Chathura Widanage
>> _______________________________________________
>> 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
> lars@xxxxxxxxx
> http://www.dhis2.org <https://www.dhis2.org/>

Best Regards,

*Chathura Widanage,*
Department of Computer Science and Engineering,
University of Moratuwa,
Sri Lanka

Follow ups