Dear All,
Any help with reference to the information i had provided? Please help
me with ever necessary so that we could fixed this issue.

Ola & Knut,
If i want to remove all limitations (minimum and maximum) per data
elements; what the procedures?
Secondly, how can i disable dataset locked permanently? Because even
when we unlock dataset; it is still saying dataset is lock.

Thanks in advance for your cooperation.

On 9/7/15, gerald thomas <gerald17...@gmail.com> wrote:
> 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 <gerald17...@gmail.com> 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 <jmalcanta...@gmail.com> 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 <gerald17...@gmail.com>
>>> 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 <gerald17...@gmail.com> 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 <gerald17...@gmail.com> 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 <jmalcanta...@gmail.com>
>>>>>> 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 <gerald17...@gmail.com>
>>>>>>> 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 <jmalcanta...@gmail.com>
>>>>>>>> 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 <gerald17...@gmail.com>
>>>>>>>>> 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" <gerald17...@gmail.com>
>>>>>>>>>> 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 <jmalcanta...@gmail.com>
>>>>>>>>>> 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
>>>>>>>>>>> <gerald17...@gmail.com>
>>>>>>>>>>> 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 <gerald17...@gmail.com> 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
>>>>>>>>>>>>> <jmalcanta...@gmail.com>
>>>>>>>>>>>>> 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
>>>>>>>>>>>>>> <gerald17...@gmail.com>
>>>>>>>>>>>>>> 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 <gerald17...@gmail.com> 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
>>>>>>>>>>>>>>>> <jmalcanta...@gmail.com>
>>>>>>>>>>>>>>>> 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
>>>>>>>>>>>>>>>>> <gerald17...@gmail.com>
>>>>>>>>>>>>>>>>> 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 <gerald17...@gmail.com> 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
>>>>>>>>>>>>>>>>>>> <jmalcanta...@gmail.com>
>>>>>>>>>>>>>>>>>>> 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
>>>>>>>>>>>>>>>>>>>> <gerald17...@gmail.com>
>>>>>>>>>>>>>>>>>>>> escribió:
>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>> Please can you send it again
>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>> Regards,
>>>>>>>>>>>>>>>>>>>>> Gerald
>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>> On Aug 24, 2015 3:01 PM, "Juan Manuel Alcantara
>>>>>>>>>>>>>>>>>>>>> Acosta"
>>>>>>>>>>>>>>>>>>>>> <jmalcanta...@gmail.com> wrote:
>>>>>>>>>>>>>>>>>>>>> Is this happening too with the last query I sent you?
>>>>>>>>>>>>>>>>>>>>> JM
>>>>>>>>>>>>>>>>>>>>> El 24/08/2015, a las 09:54, gerald thomas
>>>>>>>>>>>>>>>>>>>>> <gerald17...@gmail.com>
>>>>>>>>>>>>>>>>>>>>> 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 <gerald17...@gmail.com>
>>>>>>>>>>>>>>>>>>>>>> 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
>>>>>>>>>>>>>>>>>>>>>>> <jmalcanta...@gmail.com>
>>>>>>>>>>>>>>>>>>>>>>> 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
>>>>>>>>>>>>>>>>>>>>>>>> <gerald17...@gmail.com>
>>>>>>>>>>>>>>>>>>>>>>>> escribió:
>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>> Dear Juan,
>>>>>>>>>>>>>>>>>>>>>>>>> Please find the attached updated combo query.
>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>> On 8/24/15, gerald thomas <gerald17...@gmail.com>
>>>>>>>>>>>>>>>>>>>>>>>>> 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
>>>>>>>>>>>>>>>>>>>>>>>>>> <jmalcanta...@gmail.com>
>>>>>>>>>>>>>>>>>>>>>>>>>> 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
>>>>>>>>>>>>>>>>>>>>>>>>>>> <gerald17...@gmail.com>
>>>>>>>>>>>>>>>>>>>>>>>>>>> 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
>>>>>>>>>>>>>>>>>>>>>>>>>>>> <gerald17...@gmail.com>
>>>>>>>>>>>>>>>>>>>>>>>>>>>> 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
>>>>>>>>>>>>>>>>>>>>>>>>>>>>> <jmalcanta...@gmail.com>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>> 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
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> <gerald17...@gmail.com>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> 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
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> <jmalcanta...@gmail.com>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> 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
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> <jmalcanta...@gmail.com> 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
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> <gerald17...@gmail.com>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> 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
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> <jmalcanta...@gmail.com>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> 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
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> <gerald17...@gmail.com>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> 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"
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> <jmalcanta...@gmail.com> wrote:
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Hello Gerald
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Are you using custom forms for data
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> entry?
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> JM
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> El 22/08/2015, a las 15:37, gerald
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> thomas
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> <gerald17...@gmail.com>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> 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
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> <gerald17...@gmail.com>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> 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@lists.launchpad.net
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> 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
>


-- 
Regards,

Gerald

_______________________________________________
Mailing list: https://launchpad.net/~dhis2-users
Post to     : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Reply via email to