Hi, Any update on this? Thanks
On Thu, Oct 6, 2016 at 11:27 AM, chathura widanage < [email protected]> wrote: > 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> > -- 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
