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 <[email protected]> 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 < > [email protected]> 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 : [email protected] >> 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 > [email protected] > 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>
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
