dhis2-users team mailing list archive

[Jason Pickering <jason.p.pickering@xxxxxxxxx>]

Hi Angela,
You should created SQL views via the DHIS2 application. Go to Data
Administration -> SQL Views and create your view there.See here
<https://ci.dhis2.org/docs/master/en/user/html/dataAdmin_sqlView.html#d0e19320>
for
details. When the analytics process runs, it needs to drop certain resource
tables. If these tables are linked to a view in the database, then the
process fails.

If you must have views directly on the database (and not created through
the DHIS2 SQL View functionality) you need to be sure they do not reference
resource tables, or alternatively, encapsulate the view in a PLPSQL
function, so that they are not seen by the database.

Regards,
Jason


On Thu, Nov 24, 2016 at 11:20 AM, Hinds, Ms. Angela (CAR) <
hindsang@xxxxxxxxxx> wrote:

> Thanks everyone for the response. When I run the analytics it gives me the
> following below, which is related to a view I created in PgAdmin. Is the
> only option to move the view, run the analytics then add the view again?
>
> Regards,
> Angela
>
> Error
> Process failed: StatementCallback; uncategorized SQLException for SQL
> [drop table _dateperiodstructure;]; SQL state [2BP01]; error code [0];
> ERROR: cannot drop table _dateperiodstructure because other objects depend
> on it Detail: view "DHIS2MasterViewXtra" depends on table
> _dateperiodstructure
> Hint: Use DROP ... CASCADE to drop the dependent objects too.; nested
> exception is org.postgresql.util.PSQLException: ERROR: cannot drop table
> _dateperiodstructure because other objects depend on it Detail: view
> "DHIS2MasterViewXtra" depends on table _dateperiodstructure Hint: Use DROP
> ... CASCADE to drop the dependent objects too.
>
>
> -----Original Message-----
> From: Dan Cocos [mailto:dcocos@xxxxxxxxx]
> Sent: Wednesday, November 23, 2016 12:18 PM
> To: Hinds, Ms. Angela (CAR) <hindsang@xxxxxxxxxx>
> Cc: DHIS Users <dhis2-users@xxxxxxxxxxxxxxxxxxx>; DHIS 2 Developers list <
> dhis2-devs@xxxxxxxxxxxxxxxxxxx>
> Subject: Re: [Dhis2-devs] No totals visible in the pivot table
>
> You have to run Analytics for the Pivot Tables to update Apps —> Reports
> —> Analytics
>
>
> Dan Cocos
> Principal, BAO Systems
> dcocos@xxxxxxxxxxxxxx | http://www.baosystems.com |  2900 K Street, Suite
> 404, Washington D.C. 20007
>
> > On Nov 23, 2016, at 11:15 AM, Hinds, Ms. Angela (CAR) <
> hindsang@xxxxxxxxxx> wrote:
> >
> > Hi Folks,
> >
> > I recently imported records using a csv file into DHIS 2.  I can see the
> data in the data entry screen and using the browser option but nothing when
> I use the pivot table tool.  It is aggregate data and I have not set up
> indicators as yet so I am just running straightforward tables using the
> details option.
> >
> > Any ideas as to the reason for this?
> >
> > Regards,
> >
> > Angela
> >
> >
> > _______________________________________________
> > 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-users
> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>



-- 
Jason P. Pickering
email: jason.p.pickering@xxxxxxxxx
tel:+46764147049