← Back to team overview

dhis2-devs team mailing list archive

Re: SQL Views Dependency Issue


Dear Chathura,

Why do u wanna drop the views at the first place?


On Tue, Oct 4, 2016 at 2:40 PM, 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

A negative thinker see a difficulty in every opportunity..........
A positive thinker see an opportunity in every difficulty..........
He is able who thinks he is able.  ~ Buddha