← Back to team overview

dhis2-devs team mailing list archive

[Bug 1211010] [NEW] Analytics tables not generated when sql views linked to analytics tables exist

 

Public bug reported:

Analytics tables are not generated when sql view linked to the analytics
table is present. Postgres cannot drop a table linked to a view without
a cascade statement dropping the particular view. Since postgres cannot
drop the analytics tables to populate a new one, the process is
truncated .

Using version 2.12 build 11268.

** Affects: dhis2
     Importance: Undecided
         Status: New


** Tags: 11268 2.12 build

-- 
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/1211010

Title:
  Analytics tables not generated when sql views linked to analytics
  tables exist

Status in DHIS 2 - District Health Information Software:
  New

Bug description:
  Analytics tables are not generated when sql view linked to the
  analytics table is present. Postgres cannot drop a table linked to a
  view without a cascade statement dropping the particular view. Since
  postgres cannot drop the analytics tables to populate a new one, the
  process is truncated .

  Using version 2.12 build 11268.

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1211010/+subscriptions


Follow ups

References