dhis2-devs team mailing list archive

[chathura widanage <chathurawidanage@xxxxxxxxx>]

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?

Thanks,
Chathura





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,*
Undergraduate,
Department of Computer Science and Engineering,
University of Moratuwa,
Sri Lanka
<https://www.linkedin.com/profile/public-profile-settings?trk=prof-edit-edit-public_profile>
  <http://facebook.com/chathura.widanage>
<https://plus.google.com/u/0/109418781686423002025>
<https://github.com/chathurawidanage>