The view is definitely not replaced - I have to re-execute it every morning. It also fails to re-create when I run the analytics manually.
I checked catalina logs this morning and there is no CREATE VIEW statement or any reference to the view name (except for 4 DROP VIEW statements) Bob - I did create the view through the web interface. Can someone please confirm that a 'create org.hisp.dhis.sqlview.SqlView' or a 'CREATE VIEW' statement is logged during the analytics run when the view is re-created. UPDATE: I added a new view and this one IS re-created after manually running analytics. Is there any difference between the nightly analytics run and a manual run? Thanks On Tue, Jul 8, 2014 at 7:18 PM, Bob Jolliffe <bobjolli...@gmail.com> wrote: > 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.picker...@gmail.com> 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 <pie...@jembi.org> 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@lists.launchpad.net >> > Unsubscribe : https://launchpad.net/~dhis2-devs >> > More help : https://help.launchpad.net/ListHelp >> > >> >> >> -- >> Jason P. Pickering >> email: jason.p.picker...@gmail.com >> tel:+260974901293 >> >> _______________________________________________ >> Mailing list: https://launchpad.net/~dhis2-devs >> Post to : dhis2-devs@lists.launchpad.net >> Unsubscribe : https://launchpad.net/~dhis2-devs >> More help : https://help.launchpad.net/ListHelp >> > > > _______________________________________________ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : dhis2-devs@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > >
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp