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 c
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
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 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
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 DHI
This is not a bug, but happens because the views (which might be linked
to resource tables), need to be dropped, as the analytics process drops
the resource tables and rebuilds them. After this, the views should be
restored. So, it might be a bug if the views which are dropped, are not
restored, bu
5 matches
Mail list logo