← 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?

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