dhis2-devs team mailing list archive
-
dhis2-devs team
-
Mailing list archive
-
Message #47030
Re: SQL Views Dependency Issue
Dear Chathura,
Why do u wanna drop the views at the first place?
Sampath
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
References