dhis2-devs team mailing list archive

[Calle Hedberg <calle.hedberg@xxxxxxxxx>]

Jason

I was not executing any custom sql - I'm running the Data Administration ->
Data Integrity process checks.

My reference to the sql queries being run relates to my ASSUMPTION that the
Data Integrity checks are a series of SQL queries - but maybe not, maybe
the integrity checks are a series of web api calls followed by some kind of
front-end processing? I just don't know, and I'm not a Java developer and I
don't have the code base on my laptop so I cannot find out myself...

Seems my initial post was not clear enough on this - apologies for that.

Regards
Calle

On 1 September 2015 at 14:31, Jason Pickering <jason.p.pickering@xxxxxxxxx>
wrote:

> Hi Calle,
> It is very difficult to say much without knowing what SQL it was you
> executed. In general, use of the API or UI is usually much safer.
>
> Do you have any sort of cache in front of your DHIS2 instance?
>
> Can you confirm from the database that the names were actually changed?
>
> Regards,
> Jason
>
>
> On Tue, Sep 1, 2015 at 12:49 PM, Calle Hedberg <calle.hedberg@xxxxxxxxx>
> wrote:
>
>> Lars,
>>
>> Nope - all data set names and short names are the same.
>>
>> It's just weird, and I don't like inexplicable things happening to a
>> database....
>>
>> When you run data integrity - WHERE are those queries fetching data from?
>> Are the integrity queries running against the database itself, or some kind
>> of cache repository?
>>
>> Regards
>> Calle
>>
>> On 1 September 2015 at 13:00, Lars Helge Øverland <larshelge@xxxxxxxxx>
>> wrote:
>>
>>> Hi Calle,
>>>
>>> perhaps you did not update the data set short names?
>>>
>>> Lars
>>>
>>> On Tue, Sep 1, 2015 at 11:50 AM, Calle Hedberg <calle.hedberg@xxxxxxxxx>
>>> wrote:
>>>
>>>> Hi
>>>>
>>>> I've got a baffling problem (presumably related to some kind of
>>>> caching):
>>>>
>>>> 1. yesterday I updated various data records using pgremote, including
>>>> data set names. We restarted tomcat after the updates.
>>>>
>>>> 2. I've also cleared my browser cache, the DHIS2 cache, updated
>>>> resource tables, etc.
>>>>
>>>> 3. When I now open the list of data sets, all the changed/new names are
>>>> showing as expected.
>>>>
>>>> 4. BUT when I run Data Integrity, a few violations related to data sets
>>>> are coming up AND THE DATA SET NAMES ARE THE OLD ONES.
>>>>
>>>> Any ideas what could cause this weird behaviour?
>>>>
>>>> Regards
>>>> Calle
>>>>
>>>> *******************************************
>>>>
>>>> Calle Hedberg
>>>>
>>>> 46D Alma Road, 7700 Rosebank, SOUTH AFRICA
>>>>
>>>> Tel/fax (home): +27-21-685-6472
>>>>
>>>> Cell: +27-82-853-5352
>>>>
>>>> Iridium SatPhone: +8816-315-19274
>>>>
>>>> Email: calle.hedberg@xxxxxxxxx
>>>>
>>>> Skype: calle_hedberg
>>>>
>>>> *******************************************
>>>>
>>>>
>>>> _______________________________________________
>>>> Mailing list: https://launchpad.net/~dhis2-devs
>>>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>>> More help   : https://help.launchpad.net/ListHelp
>>>>
>>>>
>>>
>>>
>>> --
>>> Lars Helge Øverland
>>> Lead developer, DHIS 2
>>> University of Oslo
>>> Skype: larshelgeoverland
>>> http://www.dhis2.org <https://www.dhis2.org>
>>>
>>>
>>
>>
>> --
>>
>> *******************************************
>>
>> Calle Hedberg
>>
>> 46D Alma Road, 7700 Rosebank, SOUTH AFRICA
>>
>> Tel/fax (home): +27-21-685-6472
>>
>> Cell: +27-82-853-5352
>>
>> Iridium SatPhone: +8816-315-19274
>>
>> Email: calle.hedberg@xxxxxxxxx
>>
>> Skype: calle_hedberg
>>
>> *******************************************
>>
>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
> Jason P. Pickering
> email: jason.p.pickering@xxxxxxxxx
> tel:+46764147049
>



-- 

*******************************************

Calle Hedberg

46D Alma Road, 7700 Rosebank, SOUTH AFRICA

Tel/fax (home): +27-21-685-6472

Cell: +27-82-853-5352

Iridium SatPhone: +8816-315-19274

Email: calle.hedberg@xxxxxxxxx

Skype: calle_hedberg

*******************************************