dhis2-devs team mailing list archive

[Bob Jolliffe <bobjolliffe@xxxxxxxxx>]

Was the view created through the web interface as described
https://www.dhis2.org/doc/snapshot/en/user/html/ch22s06.html ?

These are the views that will get rebuilt.

I am pretty sure you can create views directly through the database which
will not be dropped if you don't adopt the _view* naming convention, but,
and its a big but, its usually not a good idea.  Views often refer to
transient tables (analytics, datamart) and the processes which drop and
regenerate those will fail if there are dependent views.




On 8 July 2014 18:02, Jason Pickering <jason.p.pickering@xxxxxxxxx> wrote:

> Hi Pierre,
> So, can you confirm that the view is not replaced? Otherwise, this is
> still not a bug.
>
> Regards,
> Jason
>
>
> On 7/8/14, Pierre Dane <pierre@xxxxxxxxx> wrote:
> > Thank you Jason - I will submit a new bug stating that the view is not
> > rebuilt
> >
> > --
> > You received this bug notification because you are a member of DHIS 2
> > developers, which is subscribed to DHIS.
> > https://bugs.launchpad.net/bugs/1339078
> >
> > Title:
> >   sql view is dropped after analytics run
> >
> > Status in DHIS 2:
> >   Invalid
> >
> > Bug description:
> >   the sql view is dropped at the end of the analytics run:
> >   * INFO  2014-07-08 15:12:10,861 Drop view SQL: DROP VIEW IF EXISTS
> > "_view_facilityregistry" (JdbcSqlViewExpandStore.java
> > [http-bio-8080-exec-69])
> >   * INFO  2014-07-08 15:12:14,398 Drop view SQL: DROP VIEW IF EXISTS
> > "_view_facilityregistry" (JdbcSqlViewExpandStore.java
> > [http-bio-8080-exec-75])
> >
> >   Version:
> >   2.15
> >   Build revision:
> >   15054
> >
> > To manage notifications about this bug go to:
> > https://bugs.launchpad.net/dhis2/+bug/1339078/+subscriptions
> >
> > _______________________________________________
> > 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
> >
>
>
> --
> Jason P. Pickering
> email: jason.p.pickering@xxxxxxxxx
> tel:+260974901293
>
> _______________________________________________
> 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
>