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 <[email protected]> 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 <[email protected]> > 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 <[email protected]> >> 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 <[email protected]> >>> 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: [email protected] >>>> >>>> Skype: calle_hedberg >>>> >>>> ******************************************* >>>> >>>> >>>> _______________________________________________ >>>> Mailing list: https://launchpad.net/~dhis2-devs >>>> Post to : [email protected] >>>> 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: [email protected] >> >> Skype: calle_hedberg >> >> ******************************************* >> >> >> _______________________________________________ >> Mailing list: https://launchpad.net/~dhis2-devs >> Post to : [email protected] >> Unsubscribe : https://launchpad.net/~dhis2-devs >> More help : https://help.launchpad.net/ListHelp >> >> > > > -- > Jason P. Pickering > email: [email protected] > 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: [email protected] Skype: calle_hedberg *******************************************
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
