dhis2-users team mailing list archive
-
dhis2-users team
-
Mailing list archive
-
Message #08039
Re: Data Loss
Dear Juan,
Furthermore, for another district "Bonthe" with organisation units
(Bendu Cha, BMC, Bum
Dema, Imperi, Jong, Kpanda Kemoh, Kwamabai Krim, Nongoba Bullum,
Sittia, Sogbini, Yawbeko)
>From the query again,
hmis=# SELECT period.startdate, period.enddate, organisationunit.name,
count(datavalue.sourceid) FROM datavalue, period, organisationunit
hmis-# WHERE datavalue.periodid = period.periodid AND
datavalue.sourceid = organisationunit.organisationunitid
hmis-# AND datavalue.dataelementid IN (SELECT dataelementid FROM
dataelement WHERE uid IN
hmis(# ('Uh0eZaSBoy1','EByDLRrUQQ7','t4cOzeDmRBS','oQstHNsrsJm','q22MFSRWNe8','wyMiVZXcDp4','mPNtI6rlJgx','CzFJu6gOT8a','H5lP3PsNGmn','gSDWcj0oWwb','US013EpQT09','MciaFRdH99E','wcO9l9VDdjm','GNPQd1JagxH','Ch6DcBg6c6o','M24QWMWyKhX'))
hmis-# AND datavalue.sourceid IN (SELECT organisationunitid FROM
organisationunit WHERE uid in
('WBbZ4IsR4fJ','KuGGNmQRNRG','ZNSxAuPYkmc','bAfHAdToWpH','JGXzvo6cui0','qgKbTso4uxs','BwLuMFCgNXY','gbBGavOWAOJ','pxCSw2YnJkG','eqvAT82OSZK','Rftqk5lhju2','bSeyZOqAPAo'))
hmis-# GROUP BY period.startdate, period.enddate,
organisationunit.name, datavalue.sourceid;
startdate | enddate | name | count
------------+------------+------+-------
2013-11-01 | 2013-11-30 | BMC | 6
(1 row)
Please help me; i need to know why this is happening. As you can see
we had been loosing data for quit awhile now on those data elements.
On 9/7/15, gerald thomas <gerald17006@xxxxxxxxx> wrote:
> Dear Juan,
> Sorry about the time lapse for this subject but i am currently in the
> field trying to understand why we are having the data loss. One of our
> district "Pujehun" is currently facing this issue. The data entry
> clerk said he had successfully entered information for 2 months:
> January & February and partially for March 2015 for one of his
> organisation unit "Barri" which has the following sub organisation
> units ( Bandasuma CHC, Konia MCHP, Njaluahun CHP, Potoru CHC, Saahun
> (barri) MCHP, Tambeyama MCHP, Taninahun MCHP, Vaama MCHP, Waiima
> MCHP). Barri and its sub-organisation unit have information for
> February and March 2015 as per the following data elements: suspected
> malaria; total head counts all services, etc but not January 2015.
>
> Using the query you gave me the last time i discovered the following:
>
> SELECT period.startdate, period.enddate, organisationunit.name,
> count(datavalue.sourceid) FROM datavalue, period, organisationunit
> WHERE datavalue.periodid = period.periodid AND datavalue.sourceid =
> organisationunit.organisationunitid
> AND datavalue.dataelementid IN (SELECT dataelementid FROM dataelement
> WHERE uid IN
> ('Uh0eZaSBoy1','EByDLRrUQQ7','t4cOzeDmRBS','oQstHNsrsJm','q22MFSRWNe8','wyMiVZXcDp4','mPNtI6rlJgx','CzFJu6gOT8a','H5lP3PsNGmn','gSDWcj0oWwb','US013EpQT09','MciaFRdH99E','wcO9l9VDdjm','GNPQd1JagxH','Ch6DcBg6c6o','M24QWMWyKhX'))
> AND datavalue.sourceid IN (SELECT organisationunitid FROM
> organisationunit WHERE uid in
> ('TTcxkf1OGPx','BCnDvAuxUou','r6XG4nxlNxn','BKIrj3yjYJT','bqquAB6z7lS','xZGdhrCZjTn','hOQQ0w4iYio','qHuVAR7RvCa','qHuVAR7RvCa'))
> GROUP BY period.startdate, period.enddate, organisationunit.name,
> datavalue.sourceid;
>
>
>
> startdate | enddate | name | count
> ------------+------------+---------------------+-------
> 2014-09-01 | 2014-09-30 | Tambeyama MCHP | 19
> 2013-02-01 | 2013-02-28 | Konia MCHP | 19
> 2011-07-01 | 2011-07-31 | Njaluahun CHP | 22
> 2013-10-01 | 2013-10-31 | Bandasuma CHC | 33
> 2014-11-01 | 2014-11-30 | Tambeyama MCHP | 20
> 2011-05-01 | 2011-05-31 | Taninahun MCHP | 21
> 2011-11-01 | 2011-11-30 | Potoru CHC | 24
> 2014-01-01 | 2014-01-31 | Saahun (barri) MCHP | 12
> 2012-09-01 | 2012-09-30 | Bandasuma CHC | 26
> 2011-08-01 | 2011-08-31 | Konia MCHP | 20
> 2012-08-01 | 2012-08-31 | Njaluahun CHP | 21
> 2013-01-01 | 2013-01-31 | Saahun (barri) MCHP | 5
> 2011-05-01 | 2011-05-31 | Tambeyama MCHP | 14
> 2014-11-01 | 2014-11-30 | Taninahun MCHP | 28
> 2013-12-01 | 2013-12-31 | Konia MCHP | 22
> 2014-09-01 | 2014-09-30 | Taninahun MCHP | 28
> 2015-02-01 | 2015-02-28 | Saahun (barri) MCHP | 22
> 2013-05-01 | 2013-05-31 | Taninahun MCHP | 20
> 2012-10-01 | 2012-10-31 | Potoru CHC | 26
> 2012-03-01 | 2012-03-31 | Bandasuma CHC | 22
> 2011-04-01 | 2011-04-30 | Tambeyama MCHP | 13
> 2012-05-01 | 2012-05-31 | Tambeyama MCHP | 20
> 2014-08-01 | 2014-08-31 | Tambeyama MCHP | 20
> 2013-07-01 | 2013-07-31 | Bandasuma CHC | 10
> 2013-02-01 | 2013-02-28 | Vaama MCHP | 20
> 2015-03-01 | 2015-03-31 | Taninahun MCHP | 33
> 2014-07-01 | 2014-07-31 | Bandasuma CHC | 28
> 2014-05-01 | 2014-05-31 | Bandasuma CHC | 33
> 2012-07-01 | 2012-07-31 | Tambeyama MCHP | 20
> 2011-12-01 | 2011-12-31 | Potoru CHC | 25
> 2013-04-01 | 2013-04-30 | Bandasuma CHC | 22
> 2012-04-01 | 2012-04-30 | Taninahun MCHP | 26
> 2014-02-01 | 2014-02-28 | Bandasuma CHC | 30
> 2012-07-01 | 2012-07-31 | Taninahun MCHP | 23
> 2014-04-01 | 2014-04-30 | Saahun (barri) MCHP | 22
> 2012-04-01 | 2012-04-30 | Tambeyama MCHP | 13
> 2011-06-01 | 2011-06-30 | Njaluahun CHP | 22
> 2013-12-01 | 2013-12-31 | Vaama MCHP | 28
> 2014-10-01 | 2014-10-31 | Potoru CHC | 38
> 2015-03-01 | 2015-03-31 | Tambeyama MCHP | 21
> 2012-06-01 | 2012-06-30 | Potoru CHC | 24
> 2011-08-01 | 2011-08-31 | Vaama MCHP | 25
> 2012-05-01 | 2012-05-31 | Taninahun MCHP | 24
> 2014-08-01 | 2014-08-31 | Taninahun MCHP | 28
> 2012-12-01 | 2012-12-31 | Potoru CHC | 25
> 2013-03-01 | 2013-03-31 | Saahun (barri) MCHP | 5
> 2011-04-01 | 2011-04-30 | Taninahun MCHP | 16
> 2013-09-01 | 2013-09-30 | Saahun (barri) MCHP | 16
> 2013-05-01 | 2013-05-31 | Tambeyama MCHP | 18
> 2014-10-01 | 2014-10-31 | Konia MCHP | 18
> 2012-02-01 | 2012-02-29 | Njaluahun CHP | 25
> 2012-01-01 | 2012-01-31 | Njaluahun CHP | 21
> 2012-03-01 | 2012-03-31 | Saahun (barri) MCHP | 6
> 2013-11-01 | 2013-11-30 | Tambeyama MCHP | 20
> 2011-09-01 | 2011-09-30 | Taninahun MCHP | 22
> 2012-06-01 | 2012-06-30 | Konia MCHP | 22
> 2011-10-01 | 2011-10-31 | Njaluahun CHP | 17
> 2013-07-01 | 2013-07-31 | Saahun (barri) MCHP | 4
> 2012-12-01 | 2012-12-31 | Konia MCHP | 20
> 2014-05-01 | 2014-05-31 | Saahun (barri) MCHP | 23
> 2014-02-01 | 2014-02-28 | Saahun (barri) MCHP | 14
> 2013-04-01 | 2013-04-30 | Saahun (barri) MCHP | 4
> 2014-07-01 | 2014-07-31 | Saahun (barri) MCHP | 22
> 2014-12-01 | 2014-12-31 | Njaluahun CHP | 31
> 2011-11-01 | 2011-11-30 | Vaama MCHP | 22
> 2014-04-01 | 2014-04-30 | Bandasuma CHC | 31
> 2012-10-01 | 2012-10-31 | Konia MCHP | 20
> 2011-09-01 | 2011-09-30 | Tambeyama MCHP | 19
> 2013-03-01 | 2013-03-31 | Bandasuma CHC | 24
> 2014-06-01 | 2014-06-30 | Njaluahun CHP | 31
> 2013-09-01 | 2013-09-30 | Bandasuma CHC | 29
> 2013-11-01 | 2013-11-30 | Taninahun MCHP | 29
> 2011-12-01 | 2011-12-31 | Konia MCHP | 17
> 2013-10-01 | 2013-10-31 | Saahun (barri) MCHP | 19
> 2013-06-01 | 2013-06-30 | Tambeyama MCHP | 21
> 2011-08-01 | 2011-08-31 | Potoru CHC | 24
> 2012-12-01 | 2012-12-31 | Vaama MCHP | 24
> 2012-11-01 | 2012-11-30 | Tambeyama MCHP | 18
> 2012-06-01 | 2012-06-30 | Vaama MCHP | 23
> 2014-10-01 | 2014-10-31 | Vaama MCHP | 32
> 2013-12-01 | 2013-12-31 | Potoru CHC | 34
> 2015-01-01 | 2015-01-31 | Potoru CHC | 8
> 2014-03-01 | 2014-03-31 | Njaluahun CHP | 34
> 2014-01-01 | 2014-01-31 | Bandasuma CHC | 33
> 2011-12-01 | 2011-12-31 | Vaama MCHP | 24
> 2013-02-01 | 2013-02-28 | Potoru CHC | 24
> 2013-01-01 | 2013-01-31 | Bandasuma CHC | 24
> 2012-09-01 | 2012-09-30 | Saahun (barri) MCHP | 5
> 2012-11-01 | 2012-11-30 | Taninahun MCHP | 25
> 2011-11-01 | 2011-11-30 | Konia MCHP | 22
> 2013-06-01 | 2013-06-30 | Taninahun MCHP | 22
> 2015-02-01 | 2015-02-28 | Bandasuma CHC | 23
> 2012-10-01 | 2012-10-31 | Vaama MCHP | 25
> 2012-08-01 | 2012-08-31 | Vaama MCHP | 25
> 2014-01-01 | 2014-01-31 | Tambeyama MCHP | 14
> 2013-01-01 | 2013-01-31 | Tambeyama MCHP | 15
> 2011-05-01 | 2011-05-31 | Saahun (barri) MCHP | 19
> 2012-02-01 | 2012-02-29 | Potoru CHC | 24
> 2012-01-01 | 2012-01-31 | Potoru CHC | 24
> 2011-06-01 | 2011-06-30 | Konia MCHP | 6
> 2011-10-01 | 2011-10-31 | Potoru CHC | 25
> 2015-02-01 | 2015-02-28 | Tambeyama MCHP | 16
> 2014-09-01 | 2014-09-30 | Saahun (barri) MCHP | 16
> 2014-06-01 | 2014-06-30 | Potoru CHC | 34
> 2015-02-01 | 2015-02-28 | Taninahun MCHP | 24
> 2013-06-01 | 2013-06-30 | Bandasuma CHC | 22
> 2011-07-01 | 2011-07-31 | Vaama MCHP | 25
> 2014-11-01 | 2014-11-30 | Saahun (barri) MCHP | 21
> 2014-12-01 | 2014-12-31 | Potoru CHC | 24
> 2013-01-01 | 2013-01-31 | Taninahun MCHP | 18
> 2012-11-01 | 2012-11-30 | Bandasuma CHC | 24
> 2014-01-01 | 2014-01-31 | Taninahun MCHP | 27
> 2014-04-01 | 2014-04-30 | Tambeyama MCHP | 19
> 2012-04-01 | 2012-04-30 | Saahun (barri) MCHP | 4
> 2015-03-01 | 2015-03-31 | Saahun (barri) MCHP | 19
> 2013-12-01 | 2013-12-31 | Njaluahun CHP | 24
> 2014-03-01 | 2014-03-31 | Potoru CHC | 46
> 2011-06-01 | 2011-06-30 | Vaama MCHP | 26
> 2011-09-01 | 2011-09-30 | Bandasuma CHC | 26
> 2013-03-01 | 2013-03-31 | Tambeyama MCHP | 21
> 2013-09-01 | 2013-09-30 | Tambeyama MCHP | 6
> 2012-08-01 | 2012-08-31 | Konia MCHP | 20
> 2013-05-01 | 2013-05-31 | Saahun (barri) MCHP | 6
> 2011-08-01 | 2011-08-31 | Njaluahun CHP | 23
> 2013-03-01 | 2013-03-31 | Taninahun MCHP | 22
> 2013-09-01 | 2013-09-30 | Taninahun MCHP | 34
> 2011-04-01 | 2011-04-30 | Saahun (barri) MCHP | 10
> 2012-05-01 | 2012-05-31 | Saahun (barri) MCHP | 16
> 2013-11-01 | 2013-11-30 | Bandasuma CHC | 33
> 2014-08-01 | 2014-08-31 | Saahun (barri) MCHP | 21
> 2011-07-01 | 2011-07-31 | Konia MCHP | 15
> 2013-02-01 | 2013-02-28 | Njaluahun CHP | 18
> 2012-07-01 | 2012-07-31 | Saahun (barri) MCHP | 5
> 2014-04-01 | 2014-04-30 | Taninahun MCHP | 22
> 2015-03-01 | 2015-03-31 | Bandasuma CHC | 30
> 2014-07-01 | 2014-07-31 | Taninahun MCHP | 29
> 2014-05-01 | 2014-05-31 | Taninahun MCHP | 33
> 2013-04-01 | 2013-04-30 | Taninahun MCHP | 16
> 2012-04-01 | 2012-04-30 | Bandasuma CHC | 24
> 2014-02-01 | 2014-02-28 | Taninahun MCHP | 21
> 2014-12-01 | 2014-12-31 | Vaama MCHP | 36
> 2011-11-01 | 2011-11-30 | Njaluahun CHP | 18
> 2013-07-01 | 2013-07-31 | Taninahun MCHP | 22
> 2011-09-01 | 2011-09-30 | Saahun (barri) MCHP | 6
> 2011-07-01 | 2011-07-31 | Potoru CHC | 23
> 2013-05-01 | 2013-05-31 | Bandasuma CHC | 24
> 2012-03-01 | 2012-03-31 | Taninahun MCHP | 28
> 2014-06-01 | 2014-06-30 | Vaama MCHP | 34
> 2011-10-01 | 2011-10-31 | Vaama MCHP | 21
> 2012-03-01 | 2012-03-31 | Tambeyama MCHP | 14
> 2012-05-01 | 2012-05-31 | Bandasuma CHC | 23
> 2013-11-01 | 2013-11-30 | Saahun (barri) MCHP | 12
> 2014-08-01 | 2014-08-31 | Bandasuma CHC | 26
> 2012-02-01 | 2012-02-29 | Vaama MCHP | 23
> 2012-01-01 | 2012-01-31 | Vaama MCHP | 24
> 2014-03-01 | 2014-03-31 | Konia MCHP | 22
> 2011-04-01 | 2011-04-30 | Bandasuma CHC | 26
> 2013-07-01 | 2013-07-31 | Tambeyama MCHP | 19
> 2012-07-01 | 2012-07-31 | Bandasuma CHC | 8
> 2014-05-01 | 2014-05-31 | Tambeyama MCHP | 21
> 2014-02-01 | 2014-02-28 | Tambeyama MCHP | 21
> 2013-04-01 | 2013-04-30 | Tambeyama MCHP | 20
> 2012-08-01 | 2012-08-31 | Potoru CHC | 26
> 2014-07-01 | 2014-07-31 | Tambeyama MCHP | 18
> 2014-06-01 | 2014-06-30 | Konia MCHP | 16
> 2011-05-01 | 2011-05-31 | Bandasuma CHC | 26
> 2012-09-01 | 2012-09-30 | Tambeyama MCHP | 19
> 2011-12-01 | 2011-12-31 | Njaluahun CHP | 17
> 2012-10-01 | 2012-10-31 | Njaluahun CHP | 22
> 2014-12-01 | 2014-12-31 | Konia MCHP | 18
> 2013-10-01 | 2013-10-31 | Taninahun MCHP | 26
> 2013-10-01 | 2013-10-31 | Tambeyama MCHP | 13
> 2012-12-01 | 2012-12-31 | Njaluahun CHP | 17
> 2014-09-01 | 2014-09-30 | Bandasuma CHC | 30
> 2013-06-01 | 2013-06-30 | Saahun (barri) MCHP | 5
> 2014-11-01 | 2014-11-30 | Bandasuma CHC | 28
> 2012-09-01 | 2012-09-30 | Taninahun MCHP | 26
> 2012-11-01 | 2012-11-30 | Saahun (barri) MCHP | 18
> 2011-06-01 | 2011-06-30 | Potoru CHC | 12
> 2014-03-01 | 2014-03-31 | Vaama MCHP | 31
> 2014-10-01 | 2014-10-31 | Njaluahun CHP | 31
> 2012-02-01 | 2012-02-29 | Konia MCHP | 21
> 2012-01-01 | 2012-01-31 | Konia MCHP | 22
> 2012-06-01 | 2012-06-30 | Njaluahun CHP | 23
> 2011-10-01 | 2011-10-31 | Konia MCHP | 19
> 2014-09-01 | 2014-09-30 | Njaluahun CHP | 22
> 2011-07-01 | 2011-07-31 | Tambeyama MCHP | 17
> 2012-12-01 | 2012-12-31 | Bandasuma CHC | 25
> 2014-11-01 | 2014-11-30 | Njaluahun CHP | 31
> 2014-10-01 | 2014-10-31 | Bandasuma CHC | 29
> 2012-08-01 | 2012-08-31 | Taninahun MCHP | 24
> 2012-06-01 | 2012-06-30 | Bandasuma CHC | 26
> 2013-09-01 | 2013-09-30 | Konia MCHP | 16
> 2013-07-01 | 2013-07-31 | Potoru CHC | 22
> 2013-01-01 | 2013-01-31 | Vaama MCHP | 22
> 2013-03-01 | 2013-03-31 | Konia MCHP | 13
> 2014-05-01 | 2014-05-31 | Potoru CHC | 35
> 2014-01-01 | 2014-01-31 | Vaama MCHP | 34
> 2013-04-01 | 2013-04-30 | Potoru CHC | 24
> 2014-02-01 | 2014-02-28 | Potoru CHC | 33
> 2011-12-01 | 2011-12-31 | Bandasuma CHC | 26
> 2012-08-01 | 2012-08-31 | Tambeyama MCHP | 21
> 2011-05-01 | 2011-05-31 | Njaluahun CHP | 18
> 2014-07-01 | 2014-07-31 | Potoru CHC | 36
> 2012-03-01 | 2012-03-31 | Potoru CHC | 28
> 2015-02-01 | 2015-02-28 | Vaama MCHP | 33
> 2012-10-01 | 2012-10-31 | Bandasuma CHC | 26
> 2014-04-01 | 2014-04-30 | Konia MCHP | 20
> 2011-07-01 | 2011-07-31 | Taninahun MCHP | 24
> 2011-04-01 | 2011-04-30 | Njaluahun CHP | 15
> 2012-05-01 | 2012-05-31 | Njaluahun CHP | 23
> 2014-08-01 | 2014-08-31 | Njaluahun CHP | 22
> 2013-02-01 | 2013-02-28 | Saahun (barri) MCHP | 5
> 2012-07-01 | 2012-07-31 | Njaluahun CHP | 21
> 2012-09-01 | 2012-09-30 | Potoru CHC | 26
> 2011-06-01 | 2011-06-30 | Taninahun MCHP | 21
> 2011-06-01 | 2011-06-30 | Tambeyama MCHP | 20
> 2012-04-01 | 2012-04-30 | Njaluahun CHP | 21
> 2015-03-01 | 2015-03-31 | Njaluahun CHP | 31
> 2013-12-01 | 2013-12-31 | Saahun (barri) MCHP | 10
> 2015-02-01 | 2015-02-28 | Konia MCHP | 19
> 2011-11-01 | 2011-11-30 | Bandasuma CHC | 26
> 2014-04-01 | 2014-04-30 | Vaama MCHP | 30
> 2014-01-01 | 2014-01-31 | Konia MCHP | 22
> 2013-10-01 | 2013-10-31 | Potoru CHC | 34
> 2013-03-01 | 2013-03-31 | Vaama MCHP | 22
> 2013-09-01 | 2013-09-30 | Vaama MCHP | 31
> 2013-01-01 | 2013-01-31 | Konia MCHP | 22
> 2011-08-01 | 2011-08-31 | Saahun (barri) MCHP | 5
> 2013-05-01 | 2013-05-31 | Njaluahun CHP | 21
> 2012-01-01 | 2012-01-31 | Tambeyama MCHP | 20
> 2012-02-01 | 2012-02-29 | Tambeyama MCHP | 16
> 2013-11-01 | 2013-11-30 | Njaluahun CHP | 35
> 2015-02-01 | 2015-02-28 | Potoru CHC | 34
> 2012-03-01 | 2012-03-31 | Vaama MCHP | 23
> 2014-06-01 | 2014-06-30 | Taninahun MCHP | 28
> 2011-10-01 | 2011-10-31 | Tambeyama MCHP | 22
> 2013-02-01 | 2013-02-28 | Bandasuma CHC | 24
> 2014-07-01 | 2014-07-31 | Vaama MCHP | 32
> 2014-05-01 | 2014-05-31 | Vaama MCHP | 38
> 2014-01-01 | 2014-01-31 | Potoru CHC | 42
> 2013-04-01 | 2013-04-30 | Vaama MCHP | 23
> 2013-10-01 | 2013-10-31 | Konia MCHP | 22
> 2014-02-01 | 2014-02-28 | Vaama MCHP | 28
> 2014-12-01 | 2014-12-31 | Taninahun MCHP | 30
> 2013-01-01 | 2013-01-31 | Potoru CHC | 24
> 2013-07-01 | 2013-07-31 | Vaama MCHP | 22
> 2014-12-01 | 2014-12-31 | Tambeyama MCHP | 17
> 2013-12-01 | 2013-12-31 | Bandasuma CHC | 33
> 2011-11-01 | 2011-11-30 | Saahun (barri) MCHP | 5
> 2011-09-01 | 2011-09-30 | Njaluahun CHP | 21
> 2011-10-01 | 2011-10-31 | Taninahun MCHP | 17
> 2014-06-01 | 2014-06-30 | Tambeyama MCHP | 22
> 2011-08-01 | 2011-08-31 | Bandasuma CHC | 26
> 2012-09-01 | 2012-09-30 | Konia MCHP | 21
> 2012-02-01 | 2012-02-29 | Taninahun MCHP | 28
> 2012-01-01 | 2012-01-31 | Taninahun MCHP | 20
> 2012-12-01 | 2012-12-31 | Saahun (barri) MCHP | 4
> 2013-09-01 | 2013-09-30 | Potoru CHC | 38
> 2013-06-01 | 2013-06-30 | Njaluahun CHP | 22
> 2013-07-01 | 2013-07-31 | Konia MCHP | 22
> 2013-03-01 | 2013-03-31 | Potoru CHC | 22
> 2014-07-01 | 2014-07-31 | Konia MCHP | 20
> 2014-05-01 | 2014-05-31 | Konia MCHP | 20
> 2013-04-01 | 2013-04-30 | Konia MCHP | 22
> 2013-10-01 | 2013-10-31 | Vaama MCHP | 36
> 2014-02-01 | 2014-02-28 | Konia MCHP | 18
> 2012-11-01 | 2012-11-30 | Njaluahun CHP | 22
> 2014-04-01 | 2014-04-30 | Potoru CHC | 38
> 2014-10-01 | 2014-10-31 | Saahun (barri) MCHP | 22
> 2012-03-01 | 2012-03-31 | Konia MCHP | 20
> 2012-06-01 | 2012-06-30 | Saahun (barri) MCHP | 6
> 2014-03-01 | 2014-03-31 | Tambeyama MCHP | 19
> 2012-09-01 | 2012-09-30 | Vaama MCHP | 27
> 2014-03-01 | 2014-03-31 | Taninahun MCHP | 22
> 2011-12-01 | 2011-12-31 | Saahun (barri) MCHP | 6
> 2012-10-01 | 2012-10-31 | Saahun (barri) MCHP | 22
> 2011-05-01 | 2011-05-31 | Vaama MCHP | 26
> 2014-01-01 | 2014-01-31 | Njaluahun CHP | 29
> 2013-05-01 | 2013-05-31 | Konia MCHP | 22
> 2012-08-01 | 2012-08-31 | Saahun (barri) MCHP | 19
> 2013-01-01 | 2013-01-31 | Njaluahun CHP | 21
> 2015-03-01 | 2015-03-31 | Konia MCHP | 16
> 2012-04-01 | 2012-04-30 | Konia MCHP | 21
> 2013-11-01 | 2013-11-30 | Potoru CHC | 34
> 2015-02-01 | 2015-02-28 | Njaluahun CHP | 30
> 2014-11-01 | 2014-11-30 | Vaama MCHP | 33
> 2011-09-01 | 2011-09-30 | Potoru CHC | 22
> 2011-07-01 | 2011-07-31 | Saahun (barri) MCHP | 6
> 2012-07-01 | 2012-07-31 | Konia MCHP | 22
> 2014-09-01 | 2014-09-30 | Vaama MCHP | 33
> 2012-05-01 | 2012-05-31 | Konia MCHP | 22
> 2014-08-01 | 2014-08-31 | Konia MCHP | 16
> 2014-03-01 | 2014-03-31 | Bandasuma CHC | 33
> 2011-04-01 | 2011-04-30 | Konia MCHP | 22
> 2011-06-01 | 2011-06-30 | Saahun (barri) MCHP | 15
> 2012-11-01 | 2012-11-30 | Potoru CHC | 25
> 2014-04-01 | 2014-04-30 | Njaluahun CHP | 29
> 2014-12-01 | 2014-12-31 | Bandasuma CHC | 27
> 2013-12-01 | 2013-12-31 | Tambeyama MCHP | 15
> 2013-02-01 | 2013-02-28 | Taninahun MCHP | 20
> 2015-03-01 | 2015-03-31 | Vaama MCHP | 30
> 2012-04-01 | 2012-04-30 | Vaama MCHP | 24
> 2013-05-01 | 2013-05-31 | Vaama MCHP | 22
> 2013-09-01 | 2013-09-30 | Njaluahun CHP | 30
> 2013-06-01 | 2013-06-30 | Potoru CHC | 22
> 2013-03-01 | 2013-03-31 | Njaluahun CHP | 16
> 2014-06-01 | 2014-06-30 | Bandasuma CHC | 31
> 2011-05-01 | 2011-05-31 | Konia MCHP | 15
> 2011-08-01 | 2011-08-31 | Tambeyama MCHP | 20
> 2012-05-01 | 2012-05-31 | Vaama MCHP | 23
> 2011-08-01 | 2011-08-31 | Taninahun MCHP | 20
> 2014-08-01 | 2014-08-31 | Vaama MCHP | 16
> 2012-02-01 | 2012-02-29 | Bandasuma CHC | 26
> 2012-01-01 | 2012-01-31 | Bandasuma CHC | 26
> 2011-04-01 | 2011-04-30 | Vaama MCHP | 23
> 2011-10-01 | 2011-10-31 | Bandasuma CHC | 25
> 2012-07-01 | 2012-07-31 | Vaama MCHP | 24
> 2013-12-01 | 2013-12-31 | Taninahun MCHP | 28
> 2014-09-01 | 2014-09-30 | Konia MCHP | 18
> 2013-02-01 | 2013-02-28 | Tambeyama MCHP | 21
> 2014-11-01 | 2014-11-30 | Konia MCHP | 18
> 2014-12-01 | 2014-12-31 | Saahun (barri) MCHP | 22
> 2011-06-01 | 2011-06-30 | Bandasuma CHC | 26
> 2011-11-01 | 2011-11-30 | Tambeyama MCHP | 10
> 2014-09-01 | 2014-09-30 | Potoru CHC | 36
> 2014-06-01 | 2014-06-30 | Saahun (barri) MCHP | 22
> 2011-09-01 | 2011-09-30 | Vaama MCHP | 24
> 2014-11-01 | 2014-11-30 | Potoru CHC | 36
> 2012-01-01 | 2012-01-31 | Saahun (barri) MCHP | 3
> 2012-02-01 | 2012-02-29 | Saahun (barri) MCHP | 5
> 2012-03-01 | 2012-03-31 | Njaluahun CHP | 21
> 2013-11-01 | 2013-11-30 | Vaama MCHP | 36
> 2012-11-01 | 2012-11-30 | Konia MCHP | 21
> 2011-10-01 | 2011-10-31 | Saahun (barri) MCHP | 4
> 2013-07-01 | 2013-07-31 | Njaluahun CHP | 18
> 2011-11-01 | 2011-11-30 | Taninahun MCHP | 17
> 2014-05-01 | 2014-05-31 | Njaluahun CHP | 27
> 2013-04-01 | 2013-04-30 | Njaluahun CHP | 19
> 2014-02-01 | 2014-02-28 | Njaluahun CHP | 34
> 2014-07-01 | 2014-07-31 | Njaluahun CHP | 22
> 2011-05-01 | 2011-05-31 | Potoru CHC | 26
> 2012-06-01 | 2012-06-30 | Taninahun MCHP | 24
> 2011-09-01 | 2011-09-30 | Konia MCHP | 19
> 2014-10-01 | 2014-10-31 | Taninahun MCHP | 30
> 2012-08-01 | 2012-08-31 | Bandasuma CHC | 22
> 2012-09-01 | 2012-09-30 | Njaluahun CHP | 21
> 2012-07-01 | 2012-07-31 | Potoru CHC | 24
> 2011-12-01 | 2011-12-31 | Tambeyama MCHP | 15
> 2012-10-01 | 2012-10-31 | Tambeyama MCHP | 22
> 2011-04-01 | 2011-04-30 | Potoru CHC | 12
> 2012-05-01 | 2012-05-31 | Potoru CHC | 24
> 2014-08-01 | 2014-08-31 | Potoru CHC | 34
> 2012-12-01 | 2012-12-31 | Taninahun MCHP | 24
> 2011-07-01 | 2011-07-31 | Bandasuma CHC | 26
> 2012-12-01 | 2012-12-31 | Tambeyama MCHP | 16
> 2013-10-01 | 2013-10-31 | Njaluahun CHP | 28
> 2013-06-01 | 2013-06-30 | Vaama MCHP | 19
> 2013-05-01 | 2013-05-31 | Potoru CHC | 23
> 2012-10-01 | 2012-10-31 | Taninahun MCHP | 24
> 2012-04-01 | 2012-04-30 | Potoru CHC | 26
> 2011-12-01 | 2011-12-31 | Taninahun MCHP | 21
> 2014-10-01 | 2014-10-31 | Tambeyama MCHP | 17
> 2015-03-01 | 2015-03-31 | Potoru CHC | 28
> 2014-03-01 | 2014-03-31 | Saahun (barri) MCHP | 14
> 2012-06-01 | 2012-06-30 | Tambeyama MCHP | 20
> 2013-11-01 | 2013-11-30 | Konia MCHP | 20
> 2012-11-01 | 2012-11-30 | Vaama MCHP | 24
> (368 rows)
>
> (END)
>
> The query didn't come back with any information about January 2015 for
> those data elements but there is information for the others on the HF1
> forms.
>
> QUESTIONS:
> 1. Is it possible that minimum & maximum values as per data elements
> is affecting our data?
> 2. We have a lock period to verify the data entry clerks efficiency;
> and most of them are saying this situation normally happened after the
> system had been reopened and they are trying to key in their backlogs.
> Is it possible that the lock period is the cause of our loss data.
>
> Thanks for your usual cooperation.
>
>
> On 8/28/15, Juan Manuel Alcantara Acosta <jmalcantara1@xxxxxxxxx> wrote:
>> Hello Gerald
>> That looks fine, should return all the org units in your database. I
>> think
>> it will be simpler for you to get the UIDs from the API or from the org
>> unit
>> administration tools, for example using Organisation unit search, the
>> results will show the UID in the first column.
>> Regards,
>> JM
>>
>> El 27/08/2015, a las 15:58, gerald thomas <gerald17006@xxxxxxxxx>
>> escribió:
>>
>>> Dear Juan,
>>> Sorry about the confusion with the query;
>>>
>>> To get all the UIDs for organisationunit, i tried this query but it
>>> didn't
>>> work:
>>>
>>> SELECT * FROM organisationunit;
>>>
>>> Please am i correct or wrong to run this query?
>>>
>>> On 8/27/15, gerald thomas <gerald17006@xxxxxxxxx> wrote:
>>>> Dear Juan,
>>>>
>>>> If it is, then please view result:
>>>>
>>>>
>>>> hmis=# SELECT period.startdate, period.enddate, organisationunit.name,
>>>> count(datavalue.sourceid) FROM datavalue, period, organisationunit
>>>> hmis-# WHERE datavalue.periodid = period.periodid AND
>>>> datavalue.sourceid = organisationunit.organisationunitid
>>>> hmis-# AND datavalue.dataelementid IN (SELECT dataelementid FROM
>>>> dataelement WHERE uid IN
>>>> hmis(#
>>>> ('Uh0eZaSBoy1','EByDLRrUQQ7','t4cOzeDmRBS','oQstHNsrsJm','q22MFSRWNe8','wyMiVZXcDp4','mPNtI6rlJgx','CzFJu6gOT8a','H5lP3PsNGmn','gSDWcj0oWwb','US013EpQT09','MciaFRdH99E','wcO9l9VDdjm','GNPQd1JagxH','Ch6DcBg6c6o','M24QWMWyKhX'))
>>>> hmis-# AND datavalue.sourceid IN (SELECT organisationunitid FROM
>>>> organisationunit WHERE uid in
>>>> ('Uh0eZaSBoy1','EByDLRrUQQ7','t4cOzeDmRBS','oQstHNsrsJm','q22MFSRWNe8','wyMiVZXcDp4','mPNtI6rlJgx','CzFJu6gOT8a','H5lP3PsNGmn','gSDWcj0oWwb','US013EpQT09','MciaFRdH99E','wcO9l9VDdjm','GNPQd1JagxH','Ch6DcBg6c6o','M24QWMWyKhX'))
>>>> hmis-# GROUP BY period.startdate, period.enddate,
>>>> organisationunit.name, datavalue.sourceid;
>>>> startdate | enddate | name | count
>>>> -----------+---------+------+-------
>>>> (0 rows)
>>>>
>>>>
>>>> On 8/27/15, gerald thomas <gerald17006@xxxxxxxxx> wrote:
>>>>> Dear Juan,
>>>>> This means i am going to use the UIDs (those that are loosing data) in
>>>>> both part of the query?
>>>>> Please confirm!!
>>>>>
>>>>> On 8/27/15, Juan Manuel Alcantara Acosta <jmalcantara1@xxxxxxxxx>
>>>>> wrote:
>>>>>> Hello Gerald
>>>>>> You have to look for the UIDs of the Org Units that are loosing the
>>>>>> data
>>>>>> and
>>>>>> add them just like you did for the data element UIDs, the list of org
>>>>>> units
>>>>>> you have to replace is ('UID1','UID2','UID3')
>>>>>> Regards,
>>>>>> JM
>>>>>>
>>>>>> El 27/08/2015, a las 15:32, gerald thomas <gerald17006@xxxxxxxxx>
>>>>>> escribió:
>>>>>>
>>>>>>> Dear Juan,
>>>>>>> Sorry about the typo in my previous mail.
>>>>>>> As per query you sent:
>>>>>>>
>>>>>>> hmis(#
>>>>>>> ('Uh0eZaSBoy1','EByDLRrUQQ7','t4cOzeDmRBS','oQstHNsrsJm','q22MFSRWNe8','wyMiVZXcDp4','mPNtI6rlJgx','CzFJu6gOT8a','H5lP3PsNGmn','gSDWcj0oWwb','US013EpQT09','MciaFRdH99E','wcO9l9VDdjm','GNPQd1JagxH','Ch6DcBg6c6o','M24QWMWyKhX'))
>>>>>>> hmis-# AND datavalue.sourceid IN (SELECT organisationunitid FROM
>>>>>>> organisationunit WHERE uid in ('UID1','UID2','UID3'))
>>>>>>> hmis-# GROUP BY period.startdate, period.enddate,
>>>>>>> organisationunit.name, datavalue.sourceid;
>>>>>>> startdate | enddate | name | count
>>>>>>> -----------+---------+------+-------
>>>>>>> (0 rows)
>>>>>>>
>>>>>>> Please what should i do next?
>>>>>>> Thanks in advance for your help.
>>>>>>>
>>>>>>> On 8/27/15, Juan Manuel Alcantara Acosta <jmalcantara1@xxxxxxxxx>
>>>>>>> wrote:
>>>>>>>> Hello Gerald
>>>>>>>> I hope you are well.
>>>>>>>> The result of the query shows that you have data for the data
>>>>>>>> elements
>>>>>>>> in
>>>>>>>> question, now we should filter for the org units that loose the
>>>>>>>> information
>>>>>>>> and also check the periods.
>>>>>>>>
>>>>>>>> Try the following query as a SQL View, just add your own UID list
>>>>>>>> for
>>>>>>>> the
>>>>>>>> org units that apparently loose the data.
>>>>>>>>
>>>>>>>> SELECT period.startdate, period.enddate, organisationunit.name,
>>>>>>>> count(datavalue.sourceid) FROM datavalue, period, organisationunit
>>>>>>>> WHERE datavalue.periodid = period.periodid AND datavalue.sourceid
>>>>>>>> =
>>>>>>>> organisationunit.organisationunitid
>>>>>>>> AND datavalue.dataelementid IN (SELECT dataelementid FROM
>>>>>>>> dataelement
>>>>>>>> WHERE
>>>>>>>> uid IN
>>>>>>>> ('oQstHNsrsJm','wyMiVZXcDp4','q22MFSRWNe8','CzFJu6gOT8a','M24QWMWyKhX','Ch6DcBg6c6o','H5lP3PsNGmn','IYOtI5eARlr','mZNp0D7rBas','HXTw4HhlblV','IGgo6jmjEl7','pzvrFsbY4eA','GNPQd1JagxH','T1R75oOtd58','zVH9yk8sgsG','Lx1eDpyVnnl','bTO0YHKALOJ'))
>>>>>>>> AND datavalue.sourceid IN (SELECT organisationunitid FROM
>>>>>>>> organisationunit
>>>>>>>> WHERE uid in ('UID1','UID2','UID3'))
>>>>>>>> GROUP BY period.startdate, period.enddate, organisationunit.name,
>>>>>>>> datavalue.sourceid;
>>>>>>>>
>>>>>>>> Regards,
>>>>>>>> JM
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> El 27/08/2015, a las 02:12, gerald thomas <gerald17006@xxxxxxxxx>
>>>>>>>> escribió:
>>>>>>>>
>>>>>>>>> Dear Juan,
>>>>>>>>> Please help us we are struggling with this issue. Any update on
>>>>>>>>> the
>>>>>>>>> query
>>>>>>>>> result I sent you?
>>>>>>>>> Thanks for your usual cooperation.
>>>>>>>>>
>>>>>>>>> Regards,
>>>>>>>>> Gerald
>>>>>>>>>
>>>>>>>>> On Aug 25, 2015 6:04 PM, "gerald thomas" <gerald17006@xxxxxxxxx>
>>>>>>>>> wrote:
>>>>>>>>> Dear Juan,
>>>>>>>>> I already sent you the count result; what should i do next?
>>>>>>>>>
>>>>>>>>> Thanks in advance for your usual cooperation.
>>>>>>>>>
>>>>>>>>> On 8/25/15, Juan Manuel Alcantara Acosta <jmalcantara1@xxxxxxxxx>
>>>>>>>>> wrote:
>>>>>>>>>> Hi Gerald
>>>>>>>>>> I see there is a typo in the query and the closing parentheses is
>>>>>>>>>> missing,
>>>>>>>>>> here's the correction:
>>>>>>>>>>
>>>>>>>>>> SELECT COUNT(*) FROM datavalue WHERE dataelementid IN (SELECT
>>>>>>>>>> dataelementid FROM dataelement WHERE uid IN
>>>>>>>>>> ('oQstHNsrsJm','wyMiVZXcDp4','q22MFSRWNe8','CzFJu6gOT8a','M24QWMWyKhX','Ch6DcBg6c6o','H5lP3PsNGmn','IYOtI5eARlr','mZNp0D7rBas','HXTw4HhlblV','IGgo6jmjEl7','pzvrFsbY4eA','GNPQd1JagxH','T1R75oOtd58','zVH9yk8sgsG','Lx1eDpyVnnl','bTO0YHKALOJ'));
>>>>>>>>>>
>>>>>>>>>> This queries can also be used as SQL Views in Data
>>>>>>>>>> administration.
>>>>>>>>>>
>>>>>>>>>> Regards,
>>>>>>>>>> JM
>>>>>>>>>>
>>>>>>>>>> El 24/08/2015, a las 19:37, gerald thomas <gerald17006@xxxxxxxxx>
>>>>>>>>>> escribió:
>>>>>>>>>>
>>>>>>>>>>> Dear Juan,
>>>>>>>>>>> The dataelement query hanger here:
>>>>>>>>>>>
>>>>>>>>>>> hmis=#SELECT COUNT(*) FROM datavalue WHERE dataelemendid IN
>>>>>>>>>>> (SELECT
>>>>>>>>>>> dataelementid FROM dataelement WHERE uid IN
>>>>>>>>>>> ('oQstHNsrsJm','wyMiVZXcDp4','q22MFSRWNe8','CzFJu6gOT8a','M24QWMWyKhX','Ch6DcBg6c6o','H5lP3PsNGmn','IYOtI5eARlr','mZNp0D7rBas','HXTw4HhlblV','IGgo6jmjEl7','pzvrFsbY4eA','GNPQd1JagxH','T1R75oOtd58','zVH9yk8sgsG','Lx1eDpyVnnl','bTO0YHKALOJ');
>>>>>>>>>>>
>>>>>>>>>>> hmis(#
>>>>>>>>>>>
>>>>>>>>>>> On 8/25/15, gerald thomas <gerald17006@xxxxxxxxx> wrote:
>>>>>>>>>>>> Dear Juan,
>>>>>>>>>>>> Please find the attached file showing dataelement and UIDs. I
>>>>>>>>>>>> had
>>>>>>>>>>>> already excluded the 17 dataelement which giving these issues.
>>>>>>>>>>>> Furthermore i will like to bring to your notices that issue
>>>>>>>>>>>> only
>>>>>>>>>>>> occur
>>>>>>>>>>>> on a particular districts (Kailahun, Kenema, Koinadugu, Western
>>>>>>>>>>>> Area).
>>>>>>>>>>>>
>>>>>>>>>>>> I am currently running the dataelement query and i will update
>>>>>>>>>>>> you
>>>>>>>>>>>> first thing in the morning
>>>>>>>>>>>>
>>>>>>>>>>>> On 8/24/15, Juan Manuel Alcantara Acosta
>>>>>>>>>>>> <jmalcantara1@xxxxxxxxx>
>>>>>>>>>>>> wrote:
>>>>>>>>>>>>> Hi Gerald
>>>>>>>>>>>>> I can see the UIDs in the file you sent me. Look for the
>>>>>>>>>>>>> following
>>>>>>>>>>>>> strings:
>>>>>>>>>>>>>
>>>>>>>>>>>>> SW3YgUOEbWh
>>>>>>>>>>>>> ZUFq86FDx2d
>>>>>>>>>>>>> eTutFs33XIs
>>>>>>>>>>>>> HautHb3QIiN
>>>>>>>>>>>>> fJXh2KAO50U
>>>>>>>>>>>>> RuF2y6PRNFx
>>>>>>>>>>>>> jpxNWRzDYCW
>>>>>>>>>>>>> OYlcECL1USm
>>>>>>>>>>>>> ReCEa4ZIji8
>>>>>>>>>>>>> t4ds6TNqajx
>>>>>>>>>>>>>
>>>>>>>>>>>>> Those are the UIDs.
>>>>>>>>>>>>>
>>>>>>>>>>>>> You can use port forwarding with putty to use pgAdmin, look at
>>>>>>>>>>>>> step
>>>>>>>>>>>>> 7
>>>>>>>>>>>>> of
>>>>>>>>>>>>> the
>>>>>>>>>>>>> following instructions:
>>>>>>>>>>>>> https://intranet.cs.hku.hk/csintranet/contents/technical/howto/putty-portforward.jsp
>>>>>>>>>>>>>
>>>>>>>>>>>>> If you have a standard configuration, the port you have to
>>>>>>>>>>>>> forward
>>>>>>>>>>>>> is
>>>>>>>>>>>>> 5432
>>>>>>>>>>>>> and then you can connect to the database with pgAdmin to
>>>>>>>>>>>>> localhost
>>>>>>>>>>>>> and
>>>>>>>>>>>>> the
>>>>>>>>>>>>> same port.
>>>>>>>>>>>>>
>>>>>>>>>>>>> JM
>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>> El 24/08/2015, a las 12:34, gerald thomas
>>>>>>>>>>>>> <gerald17006@xxxxxxxxx>
>>>>>>>>>>>>> escribió:
>>>>>>>>>>>>>
>>>>>>>>>>>>>> Dear Juan,
>>>>>>>>>>>>>> Kindly note i am access the server through ssh by putty and I
>>>>>>>>>>>>>> am
>>>>>>>>>>>>>> doing
>>>>>>>>>>>>>> psql to database.
>>>>>>>>>>>>>> Please find the attached file containing some of the
>>>>>>>>>>>>>> dataelement
>>>>>>>>>>>>>> within the database. As i said before there is no UID for
>>>>>>>>>>>>>> them.
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> On 8/24/15, gerald thomas <gerald17006@xxxxxxxxx> wrote:
>>>>>>>>>>>>>>> Dear Juan,
>>>>>>>>>>>>>>> I did but it took me to *****api/resource. Tried to edit URL
>>>>>>>>>>>>>>> and
>>>>>>>>>>>>>>> use
>>>>>>>>>>>>>>> ****api/dataelement nothing comes up.
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>> On 8/24/15, Juan Manuel Alcantara Acosta
>>>>>>>>>>>>>>> <jmalcantara1@xxxxxxxxx>
>>>>>>>>>>>>>>> wrote:
>>>>>>>>>>>>>>>> Hi Gerald
>>>>>>>>>>>>>>>> Yes, you can use the following query.
>>>>>>>>>>>>>>>> SELECT * FROM dataelement;
>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>> That will return all the existing data elements. It's very
>>>>>>>>>>>>>>>> strange
>>>>>>>>>>>>>>>> to
>>>>>>>>>>>>>>>> see
>>>>>>>>>>>>>>>> data elements without UID, this happens only when you
>>>>>>>>>>>>>>>> inject
>>>>>>>>>>>>>>>> the
>>>>>>>>>>>>>>>> data
>>>>>>>>>>>>>>>> elements into the database and the UIDs are created when
>>>>>>>>>>>>>>>> you
>>>>>>>>>>>>>>>> restart
>>>>>>>>>>>>>>>> the
>>>>>>>>>>>>>>>> system. Did you try to use the API?
>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>> JM
>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>> El 24/08/2015, a las 11:27, gerald thomas
>>>>>>>>>>>>>>>> <gerald17006@xxxxxxxxx>
>>>>>>>>>>>>>>>> escribió:
>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>> Dear Juan,
>>>>>>>>>>>>>>>>> i can't find the UID as per your directions. I thought it
>>>>>>>>>>>>>>>>> was
>>>>>>>>>>>>>>>>> automatically generated but it seem not to be the case.
>>>>>>>>>>>>>>>>> Is there any query to verify the UID of these dataelements
>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>> On 8/24/15, gerald thomas <gerald17006@xxxxxxxxx> wrote:
>>>>>>>>>>>>>>>>>> Dear Juan,
>>>>>>>>>>>>>>>>>> My server version Linux dhis 3.13.0-30-generic #55-Ubuntu
>>>>>>>>>>>>>>>>>> SMP
>>>>>>>>>>>>>>>>>> Fri
>>>>>>>>>>>>>>>>>> Jul
>>>>>>>>>>>>>>>>>> 4 21:40:53 UTC 2014 x86_64 x86_64 x86_64 GNU/Linux
>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>> DHIS2 version
>>>>>>>>>>>>>>>>>> Version:
>>>>>>>>>>>>>>>>>> 2.18
>>>>>>>>>>>>>>>>>> Build revision:
>>>>>>>>>>>>>>>>>> Build date:
>>>>>>>>>>>>>>>>>> 2015-04-04 09:34
>>>>>>>>>>>>>>>>>> And it is on the cloud.
>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>> On 8/24/15, Juan Manuel Alcantara Acosta
>>>>>>>>>>>>>>>>>> <jmalcantara1@xxxxxxxxx>
>>>>>>>>>>>>>>>>>> wrote:
>>>>>>>>>>>>>>>>>>> Sure, here's the query. Don't forget to replace the list
>>>>>>>>>>>>>>>>>>> of
>>>>>>>>>>>>>>>>>>> UIDs
>>>>>>>>>>>>>>>>>>> with
>>>>>>>>>>>>>>>>>>> the
>>>>>>>>>>>>>>>>>>> corresponding text from your data elements.
>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>> SELECT COUNT(*) FROM datavalue WHERE dataelemendid IN
>>>>>>>>>>>>>>>>>>> (SELECT
>>>>>>>>>>>>>>>>>>> dataelementid
>>>>>>>>>>>>>>>>>>> FROM dataelement WHERE uid IN
>>>>>>>>>>>>>>>>>>> ('UID1','UID2','UID3','UID4','UID5','UID6','UID7','UID8','UID9','UID10',);
>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>> Can you tell me more about your server setup?
>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>> JM
>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>> El 24/08/2015, a las 10:04, gerald thomas
>>>>>>>>>>>>>>>>>>> <gerald17006@xxxxxxxxx>
>>>>>>>>>>>>>>>>>>> escribió:
>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>> Please can you send it again
>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>> Regards,
>>>>>>>>>>>>>>>>>>>> Gerald
>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>> On Aug 24, 2015 3:01 PM, "Juan Manuel Alcantara Acosta"
>>>>>>>>>>>>>>>>>>>> <jmalcantara1@xxxxxxxxx> wrote:
>>>>>>>>>>>>>>>>>>>> Is this happening too with the last query I sent you?
>>>>>>>>>>>>>>>>>>>> JM
>>>>>>>>>>>>>>>>>>>> El 24/08/2015, a las 09:54, gerald thomas
>>>>>>>>>>>>>>>>>>>> <gerald17006@xxxxxxxxx>
>>>>>>>>>>>>>>>>>>>> escribió:
>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>> Dear Juan,
>>>>>>>>>>>>>>>>>>>>> I am still having issues with datavalue query. Please
>>>>>>>>>>>>>>>>>>>>> can
>>>>>>>>>>>>>>>>>>>>> you
>>>>>>>>>>>>>>>>>>>>> help
>>>>>>>>>>>>>>>>>>>>> me
>>>>>>>>>>>>>>>>>>>>> by checking the query again.
>>>>>>>>>>>>>>>>>>>>> It is still showing "Out of memory"
>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>> On 8/24/15, gerald thomas <gerald17006@xxxxxxxxx>
>>>>>>>>>>>>>>>>>>>>> wrote:
>>>>>>>>>>>>>>>>>>>>>> Dear Juan,
>>>>>>>>>>>>>>>>>>>>>> I am still having issues with datavalue query. Please
>>>>>>>>>>>>>>>>>>>>>> can
>>>>>>>>>>>>>>>>>>>>>> you
>>>>>>>>>>>>>>>>>>>>>> help
>>>>>>>>>>>>>>>>>>>>>> me
>>>>>>>>>>>>>>>>>>>>>> by checking the query again.
>>>>>>>>>>>>>>>>>>>>>> It is still giving
>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>> On 8/24/15, Juan Manuel Alcantara Acosta
>>>>>>>>>>>>>>>>>>>>>> <jmalcantara1@xxxxxxxxx>
>>>>>>>>>>>>>>>>>>>>>> wrote:
>>>>>>>>>>>>>>>>>>>>>>> Hello Gerald
>>>>>>>>>>>>>>>>>>>>>>> What was the result of the datavalue query?
>>>>>>>>>>>>>>>>>>>>>>> You should also check the sharing settings of the
>>>>>>>>>>>>>>>>>>>>>>> data
>>>>>>>>>>>>>>>>>>>>>>> elements
>>>>>>>>>>>>>>>>>>>>>>> that
>>>>>>>>>>>>>>>>>>>>>>> are
>>>>>>>>>>>>>>>>>>>>>>> giving you trouble.
>>>>>>>>>>>>>>>>>>>>>>> JM
>>>>>>>>>>>>>>>>>>>>>>> El 24/08/2015, a las 08:43, gerald thomas
>>>>>>>>>>>>>>>>>>>>>>> <gerald17006@xxxxxxxxx>
>>>>>>>>>>>>>>>>>>>>>>> escribió:
>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>> Dear Juan,
>>>>>>>>>>>>>>>>>>>>>>>> Please find the attached updated combo query.
>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>> On 8/24/15, gerald thomas <gerald17006@xxxxxxxxx>
>>>>>>>>>>>>>>>>>>>>>>>> wrote:
>>>>>>>>>>>>>>>>>>>>>>>>> Dear Juan,
>>>>>>>>>>>>>>>>>>>>>>>>> Noted!!! It is now generating resource table and i
>>>>>>>>>>>>>>>>>>>>>>>>> will
>>>>>>>>>>>>>>>>>>>>>>>>> keep
>>>>>>>>>>>>>>>>>>>>>>>>> you
>>>>>>>>>>>>>>>>>>>>>>>>> posted once it had been completed
>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>> On 8/24/15, Juan Manuel Alcantara Acosta
>>>>>>>>>>>>>>>>>>>>>>>>> <jmalcantara1@xxxxxxxxx>
>>>>>>>>>>>>>>>>>>>>>>>>> wrote:
>>>>>>>>>>>>>>>>>>>>>>>>>> Select "Update category option combinations" and
>>>>>>>>>>>>>>>>>>>>>>>>>> click
>>>>>>>>>>>>>>>>>>>>>>>>>> on
>>>>>>>>>>>>>>>>>>>>>>>>>> "perform
>>>>>>>>>>>>>>>>>>>>>>>>>> maintenance". After that finished select from the
>>>>>>>>>>>>>>>>>>>>>>>>>> menu
>>>>>>>>>>>>>>>>>>>>>>>>>> of
>>>>>>>>>>>>>>>>>>>>>>>>>> the
>>>>>>>>>>>>>>>>>>>>>>>>>> left
>>>>>>>>>>>>>>>>>>>>>>>>>> "Resource
>>>>>>>>>>>>>>>>>>>>>>>>>> Table" and click on "Generate tables".
>>>>>>>>>>>>>>>>>>>>>>>>>> Regards,
>>>>>>>>>>>>>>>>>>>>>>>>>> JM
>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>> El 24/08/2015, a las 08:00, gerald thomas
>>>>>>>>>>>>>>>>>>>>>>>>>> <gerald17006@xxxxxxxxx>
>>>>>>>>>>>>>>>>>>>>>>>>>> escribió:
>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>> Dear Juan,
>>>>>>>>>>>>>>>>>>>>>>>>>>> Under Maintenance column i am seeing the
>>>>>>>>>>>>>>>>>>>>>>>>>>> following:
>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>> Clear analytics tables
>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>> Clear data mart
>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>> Rebuild data mart index
>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>> Clear zero values
>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>> Clear data set completeness
>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>> Prune periods
>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>> Remove expired invitations
>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>> Drop SQL views
>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>> Create SQL views
>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>> Update category option combinations
>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>> What should I check for the performance
>>>>>>>>>>>>>>>>>>>>>>>>>>> maintenance
>>>>>>>>>>>>>>>>>>>>>>>>>>> before
>>>>>>>>>>>>>>>>>>>>>>>>>>> doing
>>>>>>>>>>>>>>>>>>>>>>>>>>> the
>>>>>>>>>>>>>>>>>>>>>>>>>>> query again?
>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>> On 8/24/15, gerald thomas
>>>>>>>>>>>>>>>>>>>>>>>>>>> <gerald17006@xxxxxxxxx>
>>>>>>>>>>>>>>>>>>>>>>>>>>> wrote:
>>>>>>>>>>>>>>>>>>>>>>>>>>>> Dear Juan,
>>>>>>>>>>>>>>>>>>>>>>>>>>>> No!!! This is the holistic data from that
>>>>>>>>>>>>>>>>>>>>>>>>>>>> query.
>>>>>>>>>>>>>>>>>>>>>>>>>>>> Previously
>>>>>>>>>>>>>>>>>>>>>>>>>>>> i
>>>>>>>>>>>>>>>>>>>>>>>>>>>> only
>>>>>>>>>>>>>>>>>>>>>>>>>>>> had
>>>>>>>>>>>>>>>>>>>>>>>>>>>> the first part of the result. Do you want me to
>>>>>>>>>>>>>>>>>>>>>>>>>>>> rebuild
>>>>>>>>>>>>>>>>>>>>>>>>>>>> tables
>>>>>>>>>>>>>>>>>>>>>>>>>>>> and
>>>>>>>>>>>>>>>>>>>>>>>>>>>> run
>>>>>>>>>>>>>>>>>>>>>>>>>>>> query again?
>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>>> On 8/24/15, Juan Manuel Alcantara Acosta
>>>>>>>>>>>>>>>>>>>>>>>>>>>> <jmalcantara1@xxxxxxxxx>
>>>>>>>>>>>>>>>>>>>>>>>>>>>> wrote:
>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Hello Gerald
>>>>>>>>>>>>>>>>>>>>>>>>>>>>> This looks much different than the fist one
>>>>>>>>>>>>>>>>>>>>>>>>>>>>> you
>>>>>>>>>>>>>>>>>>>>>>>>>>>>> sent
>>>>>>>>>>>>>>>>>>>>>>>>>>>>> me
>>>>>>>>>>>>>>>>>>>>>>>>>>>>> and
>>>>>>>>>>>>>>>>>>>>>>>>>>>>> it's
>>>>>>>>>>>>>>>>>>>>>>>>>>>>> still
>>>>>>>>>>>>>>>>>>>>>>>>>>>>> missing a lot of names, did you rebuild
>>>>>>>>>>>>>>>>>>>>>>>>>>>>> resource
>>>>>>>>>>>>>>>>>>>>>>>>>>>>> tables?
>>>>>>>>>>>>>>>>>>>>>>>>>>>>> JM
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>> El 24/08/2015, a las 05:44, gerald thomas
>>>>>>>>>>>>>>>>>>>>>>>>>>>>> <gerald17006@xxxxxxxxx>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>> escribió:
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Dear Juan,
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Thanks for your responses.
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Sorry i am only responding now but please
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> find
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> the
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> attached
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> category
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> combo query.
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> On 8/23/15, Juan Manuel Alcantara Acosta
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> <jmalcantara1@xxxxxxxxx>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> wrote:
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Sorry, I got distracted and hit send before
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> completing
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> the
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> message.
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> You should limit the query to show the
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> values
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> of
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> the
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> specific
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> data
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> elements
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> that are giving you trouble, you'll need the
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> uid
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> of
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> each
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> of
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> the
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> data
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> element., In case you don't know how to get
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> that
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> information,
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> you
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> can
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> use
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> the api
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> (your_server_URL/api/dataElements?paging=false)
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> or
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> look
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> at
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> the
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> information if each data element in data
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> element
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> management
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> selecting
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> "show
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> details" from the contextual menu that
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> appears
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> when
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> clocking
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> on
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> the
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> name
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> of
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> each data element. Then add to the query the
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> list
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> of
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> UIDs
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> just
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> before
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> the
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> semicolon.
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> WHERE de.uid IN
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> ('UID1','UID2','UID3','UID4','UID5','UID6','UID7','UID8','UID9','UID10')
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Please excuse me if you already know all of
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> these
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> things,
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> since I
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> don't
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> have
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> a way to know how much you know about the
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> system
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> and
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> postgres
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> queries
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> I
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> rather be detailed on what you have to do
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> than
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> leave
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> you
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> guessing.
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> In addition to running maintenance to update
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> category
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> option
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> combinations
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> you should re-generate resource tables,
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> you'll
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> find
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> that
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> in
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> "Data
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Administration" too.
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Regards,
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> JM
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> El 23/08/2015, a las 16:18, Juan Manuel
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Alcantara
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Acosta
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> <jmalcantara1@xxxxxxxxx> escribió:
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Hi Gerald
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> I see you are missing a few category option
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> combo
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> names,
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> you
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> should
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> run
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> the maintenance to "Update category option
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> combinations",
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> you'll
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> find
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> this
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> in "Data Administration" -> "maintenance"
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> I also don't see the option combinations of
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> the
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> data
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> elements
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> you
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> highlighted in the excel you sent to the
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> list.
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Which
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> category
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> combination
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> are you using with those data elements? Run
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> the
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> query
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> again
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> after
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> doing
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> the maintenance.
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> <15 yrs, 15-24yrs, 25-34yrs, 35-44yrs,
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> 45-49yrs,
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> 49yrs
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> About the out of memory error, I recommend
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> that
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> you
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> use
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> pgAdmin3
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> and
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> try
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> to run the query again. You should limit
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> the
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> query
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> to
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> show
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> you
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> the
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> data
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> El 23/08/2015, a las 15:39, gerald thomas
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> <gerald17006@xxxxxxxxx>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> escribió:
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Dear Juan,
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> For the datavalues query; i am getting
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> "Out
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> of
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> memory"
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> as
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> result.
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Please find the attached result for the
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> combo
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> query.
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> On 8/23/15, Juan Manuel Alcantara Acosta
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> <jmalcantara1@xxxxxxxxx>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> wrote:
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Hello Gerald
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Does data disappear only from data
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> elements
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> that
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> use
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> the
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> default
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> category
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> combination?
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Since you are querying your database
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> directly,
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> I'm
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> sending
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> you
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> here
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> a
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> couple
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> of queries you can use to verify the
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> existing
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> values
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> of
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> the
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> database
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> and
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> the
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> category combinations. Check if you have
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> more
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> than
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> one
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> default
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> option
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> combination.
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Regards,
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> JM
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> El 23/08/2015, a las 11:36, gerald thomas
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> <gerald17006@xxxxxxxxx>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> escribió:
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Juan,
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Thanks for your response but we are not
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> using
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> custom
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> forms
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> for
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> data
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> entry.
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Regards,
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Gerald
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> On Aug 23, 2015 4:29 PM, "Juan Manuel
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Alcantara
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Acosta"
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> <jmalcantara1@xxxxxxxxx> wrote:
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Hello Gerald
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Are you using custom forms for data
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> entry?
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> JM
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> El 22/08/2015, a las 15:37, gerald
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> thomas
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> <gerald17006@xxxxxxxxx>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> escribió:
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Dear dhis2-users,
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> If someone cannot help me; can anyone
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> explain
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> why
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> am
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> i
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> having
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> data
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> for
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> October, November, December 2015 on my
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> database?
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> dhis=# select * from period where
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> startdate
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> '2015-01-01';
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> periodid | periodtypeid | startdate |
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> enddate
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> ----------+--------------+------------+------------
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> 1121694 | 6 | 2016-01-01 |
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> 2016-12-31
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> 2058605 | 3 | 2015-11-01 |
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> 2015-11-30
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> 2058606 | 3 | 2015-12-01 |
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> 2015-12-31
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> 2058607 | 3 | 2015-10-01 |
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> 2015-10-31
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> 2058611 | 1 | 2015-01-16 |
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> 2015-01-16
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> 2058619 | 1 | 2015-01-26 |
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> 2015-01-26
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> 2058631 | 1 | 2015-01-29 |
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> 2015-01-29
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> 2058632 | 3 | 2015-09-01 |
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> 2015-09-30
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> 2058656 | 3 | 2015-02-01 |
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> 2015-02-28
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> 2058727 | 3 | 2015-06-01 |
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> 2015-06-30
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> 2058806 | 3 | 2015-07-01 |
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> 2015-07-31
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> 2058811 | 2 | 2015-03-02 |
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> 2015-03-08
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> 2058812 | 3 | 2015-03-01 |
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> 2015-03-31
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> 2058814 | 3 | 2015-05-01 |
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> 2015-05-31
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> 2065151 | 6 | 2020-01-01 |
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> 2020-12-31
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> 2072304 | 3 | 2015-04-01 |
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> 2015-04-30
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> 2109802 | 4 | 2015-04-01 |
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> 2015-06-30
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> 2115342 | 3 | 2015-08-01 |
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> 2015-08-31
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> 2122928 | 292091 | 2015-03-01 |
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> 2015-04-30
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> 2129098 | 2 | 2015-05-25 |
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> 2015-05-31
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> 2129099 | 1 | 2015-12-31 |
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> 2015-12-31
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Please we need to fix this issue of
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> data
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> loss;
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> can
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> anyone
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> out
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> there
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> help
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> me.
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Please !!!!!!!!!!!!!!!
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> On 8/20/15, gerald thomas
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> <gerald17006@xxxxxxxxx>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> wrote:
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Dear All,
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> We are having a serious issues on our
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> online
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> server
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> in
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Sierra
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Leone.
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Data are normally entered but during
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> analysis
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> these
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> data
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> normally
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> got
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> missing. This had been an issue i had
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> raised
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> before
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> but
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> the
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> situation
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> is still the same and it is even worst
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> now.
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Please this is an urgent technical
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> problem
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> we
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> need
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> to
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> fix
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> for
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Sierra
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Leone and any help will be appreciated
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> till
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> we
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> overcome
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> this
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> situation.
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Please help us!!!!!
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> --
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Regards,
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Gerald
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> --
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Regards,
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Gerald
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> _______________________________________________
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> 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
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> --
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Regards,
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Gerald
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> <Combo_Query result.txt>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> --
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Regards,
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Gerald
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> <categoryoptioncombon.txt>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>>> --
>>>>>>>>>>>>>>>>>>>>>>>>>>>> Regards,
>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>>> Gerald
>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>> --
>>>>>>>>>>>>>>>>>>>>>>>>>>> Regards,
>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>> Gerald
>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>> --
>>>>>>>>>>>>>>>>>>>>>>>>> Regards,
>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>> Gerald
>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>> --
>>>>>>>>>>>>>>>>>>>>>>>> Regards,
>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>> Gerald
>>>>>>>>>>>>>>>>>>>>>>>> <New_categoryoptioncombon.txt>
>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>> --
>>>>>>>>>>>>>>>>>>>>>> Regards,
>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>> Gerald
>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>> --
>>>>>>>>>>>>>>>>>>>>> Regards,
>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>> Gerald
>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>> --
>>>>>>>>>>>>>>>>>> Regards,
>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>> Gerald
>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>> --
>>>>>>>>>>>>>>>>> Regards,
>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>> Gerald
>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>> --
>>>>>>>>>>>>>>> Regards,
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>> Gerald
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> --
>>>>>>>>>>>>>> Regards,
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> Gerald
>>>>>>>>>>>>>> <dataelement;.txt>
>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>> --
>>>>>>>>>>>> Regards,
>>>>>>>>>>>>
>>>>>>>>>>>> Gerald
>>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>> --
>>>>>>>>>>> Regards,
>>>>>>>>>>>
>>>>>>>>>>> Gerald
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> --
>>>>>>>>> Regards,
>>>>>>>>>
>>>>>>>>> Gerald
>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> --
>>>>>>> Regards,
>>>>>>>
>>>>>>> Gerald
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> Regards,
>>>>>
>>>>> Gerald
>>>>>
>>>>
>>>>
>>>> --
>>>> Regards,
>>>>
>>>> Gerald
>>>>
>>>
>>>
>>> --
>>> Regards,
>>>
>>> Gerald
>>
>>
>
>
> --
> Regards,
>
> Gerald
>
--
Regards,
Gerald
Follow ups
References
-
Data Loss
From: gerald thomas, 2015-08-20
-
Re: Data Loss
From: gerald thomas, 2015-08-22
-
Re: Data Loss
From: Juan Manuel Alcantara Acosta, 2015-08-23
-
Re: Data Loss
From: gerald thomas, 2015-08-23
-
Re: Data Loss
From: gerald thomas, 2015-08-24
-
Re: Data Loss
From: Juan Manuel Alcantara Acosta, 2015-08-24
-
Re: Data Loss
From: gerald thomas, 2015-08-24
-
Re: Data Loss
From: gerald thomas, 2015-08-24
-
Re: Data Loss
From: Juan Manuel Alcantara Acosta, 2015-08-24
-
Re: Data Loss
From: gerald thomas, 2015-08-24
-
Re: Data Loss
From: gerald thomas, 2015-08-25
-
Re: Data Loss
From: gerald thomas, 2015-09-07
