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) < [email protected]> 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:[email protected]] > Sent: Wednesday, November 23, 2016 12:18 PM > To: Hinds, Ms. Angela (CAR) <[email protected]> > Cc: DHIS Users <[email protected]>; DHIS 2 Developers list < > [email protected]> > 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 > [email protected] | 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) < > [email protected]> 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 : [email protected] > > Unsubscribe : https://launchpad.net/~dhis2-devs > > More help : https://help.launchpad.net/ListHelp > > _______________________________________________ > Mailing list: https://launchpad.net/~dhis2-users > Post to : [email protected] > Unsubscribe : https://launchpad.net/~dhis2-users > More help : https://help.launchpad.net/ListHelp > -- Jason P. Pickering email: [email protected] tel:+46764147049
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
