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>
_______________________________________________
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
