dhis2-devs team mailing list archive

[Pierre Dane <pierre@xxxxxxxxx>]

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 <bobjolliffe@xxxxxxxxx> 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.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
>>
>
>
> _______________________________________________
> 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
>
>