Yeah, I'm pretty sure this bug is still present in 2.16. Please try to fix it as Jason suggested..
-- Morten On Tue, Jul 14, 2015 at 5:47 PM, Alex Tumwesigye <atumwesi...@gmail.com> wrote: > Dear Dubey, > > Jason is right. > > I have had trouble before with a similar issue doing imports. > One thing I keep in mind when importing to a new instance (without using a > database dump) is to overwrite the "default" category option combo with > the one I am carrying from the existing data. > > To be safe, first import "categoryOptionCombos with depedencies" and then > import the rest. > > Alex > > On Tue, Jul 14, 2015 at 1:19 PM, Morten Olav Hansen <morte...@gmail.com> > wrote: > >> Could you also please provide your DHIS 2 version and build rev? we >> should have fixed this issue 1-2 months ago (or at least a similar issue) >> >> -- >> Morten >> >> On Tue, Jul 14, 2015 at 5:14 PM, Jason Pickering < >> jason.p.picker...@gmail.com> wrote: >> >>> In this case, you should probably alter the "default" category option >>> combo on the destination server to match that on the source server, if that >>> is possible for you. >>> >>> Something like >>> >>> UPDATE categoryoptioncombo set uid = 'XXXXXXXXX' where >>> categoryoptioncomboid = (SELECT categoryoptioncomboid from >>> _categoryoptioncomboname where categoryoptioncomboname = '(default)'); >>> >>> should work, where XXXXXXX is the uid of the source server. >>> >>> Clear your server cache and rebuild all the resource tables, and you >>> should be good to go. >>> >>> Regards, >>> Jason >>> >>> >>> On Tue, Jul 14, 2015 at 12:09 PM, Mritunjay Dubey < >>> mritu...@thoughtworks.com> wrote: >>> >>>> Hey Jason, >>>> >>>> Yes, I think it's "default" category option combo, but I'm not sure >>>> about it. I can see in UI of dataset, it shows as "default" and the >>>> date-created for category option combo is the date when I set-up the >>>> instance. >>>> >>>> So If it's a "default" *category-option-combo, *what should I do to >>>> sync it between instances ? >>>> >>>> Please let me know >>>> >>>> Thank you >>>> Mritunjay Dubey >>>> >>>> On Tue, Jul 14, 2015 at 3:19 PM, Jason Pickering < >>>> jason.p.picker...@gmail.com> wrote: >>>> >>>>> Does this happen to be the "default" category option combo? If so, it >>>>> will be different between different instances of the database, and you >>>>> will >>>>> thus need to sync this one manually between your instances. >>>>> >>>>> >>>>> Regards, >>>>> Jason >>>>> >>>>> >>>>> On Tue, Jul 14, 2015 at 11:43 AM, Mritunjay Dubey < >>>>> mritu...@thoughtworks.com> wrote: >>>>> >>>>>> >>>>>> ---------- Forwarded message ---------- >>>>>> From: Mritunjay Dubey <mritu...@thoughtworks.com> >>>>>> Date: Tue, Jul 14, 2015 at 2:58 PM >>>>>> Subject: Re: [Dhis2-devs] Deployable war for previous builds >>>>>> To: Lars Helge Øverland <larshe...@gmail.com> >>>>>> >>>>>> >>>>>> Just adding to that >>>>>> >>>>>> We had selected every metadata other than *Validation-criteria & >>>>>> Report Table.* >>>>>> >>>>>> And while importing I could see >>>>>> >>>>>> Importing 404 CategoryOptionCombos >>>>>> >>>>>> So it should not be re-generated. >>>>>> >>>>>> Thank You >>>>>> >>>>>> On Tue, Jul 14, 2015 at 2:52 PM, Mritunjay Dubey < >>>>>> mritu...@thoughtworks.com> wrote: >>>>>> >>>>>>> Hey Lars, >>>>>>> >>>>>>> For us, the second explanation seems relevant. If I got to the >>>>>>> source instance and pick a *category option combo*, in destination >>>>>>> instance for same *category option combo *the UID is different. >>>>>>> >>>>>>> For E.G. >>>>>>> >>>>>>> If I pick the dataset *Quarterly COIA Plus Dataset * >>>>>>> >>>>>>> In source instance, textbox in first row has id >>>>>>> *vIIFdYmaLk7-dCWAvZ8hcrs-val* >>>>>>> In destination instance, textbox in first row has id >>>>>>> *vIIFdYmaLk7-s1oqQs4sQhc-val* >>>>>>> >>>>>>> Which I think because *category option combo UID *is changed. >>>>>>> >>>>>>> Any clues what could be the reason for this? >>>>>>> >>>>>>> Thank You >>>>>>> Mritunjay Dubey >>>>>>> >>>>>>> >>>>>>> On Tue, Jul 14, 2015 at 2:28 PM, Lars Helge Øverland < >>>>>>> larshe...@gmail.com> wrote: >>>>>>> >>>>>>>> Another explanation is that the category option combos for some >>>>>>>> reason were not part of the exchange file, and was later re-generated >>>>>>>> in >>>>>>>> the destination system. This will give different UIDs. Let me know.. >>>>>>>> >>>>>>>> On Tue, Jul 14, 2015 at 10:47 AM, Lars Helge Øverland < >>>>>>>> larshe...@gmail.com> wrote: >>>>>>>> >>>>>>>>> Hi Mritunjay, >>>>>>>>> >>>>>>>>> are you referring the the internal database identifiers, or the >>>>>>>>> UIDs (stable identifiers) ? >>>>>>>>> >>>>>>>>> The UIDs will (should) not change and this has nothing to do with >>>>>>>>> the build. >>>>>>>>> >>>>>>>>> The database ids will likely change when you do an export followed >>>>>>>>> by an import. >>>>>>>>> >>>>>>>>> When writing reports you should base it on the UIDs just for this >>>>>>>>> reason. I am guessing you relied on the database identifiers which >>>>>>>>> then >>>>>>>>> changed during import-export. >>>>>>>>> >>>>>>>>> regards, >>>>>>>>> >>>>>>>>> Lars >>>>>>>>> >>>>>>>>> >>>>>>>>> On Tue, Jul 14, 2015 at 8:16 AM, Mritunjay Dubey < >>>>>>>>> mritu...@thoughtworks.com> wrote: >>>>>>>>> >>>>>>>>>> Hey team, >>>>>>>>>> >>>>>>>>>> We are setting up a new instance of DHIS. We had got already an >>>>>>>>>> instance running. So we exported metadata from there and imported in >>>>>>>>>> new >>>>>>>>>> one. >>>>>>>>>> >>>>>>>>>> But If we see, we are getting a difference between few *IDs, (*e.g.- >>>>>>>>>> category-option IDs) for few reports. >>>>>>>>>> What I think because we have used the same metadata it should be >>>>>>>>>> same in both. >>>>>>>>>> >>>>>>>>>> BTW we have different *Build Revision *in both instances. So if >>>>>>>>>> there is a way to get the *artifacts of previous builds*, it >>>>>>>>>> might solve the problem. >>>>>>>>>> >>>>>>>>>> Kindly let me know. >>>>>>>>>> >>>>>>>>>> Thank you >>>>>>>>>> Mritunjay Dubey >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> _______________________________________________ >>>>>>>>>> Mailing list: https://launchpad.net/~dhis2-devs >>>>>>>>>> Post to : dhis2-devs@lists.launchpad.net >>>>>>>>>> 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> >>>>>>>>> >>>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> -- >>>>>>>> Lars Helge Øverland >>>>>>>> Lead developer, DHIS 2 >>>>>>>> University of Oslo >>>>>>>> Skype: larshelgeoverland >>>>>>>> http://www.dhis2.org <https://www.dhis2.org> >>>>>>>> >>>>>>>> >>>>>>> >>>>>> >>>>>> >>>>>> _______________________________________________ >>>>>> Mailing list: https://launchpad.net/~dhis2-devs >>>>>> Post to : dhis2-devs@lists.launchpad.net >>>>>> Unsubscribe : https://launchpad.net/~dhis2-devs >>>>>> More help : https://help.launchpad.net/ListHelp >>>>>> >>>>>> >>>>> >>>>> >>>>> -- >>>>> Jason P. Pickering >>>>> email: jason.p.picker...@gmail.com >>>>> tel:+46764147049 >>>>> >>>> >>>> >>> >>> >>> -- >>> Jason P. Pickering >>> email: jason.p.picker...@gmail.com >>> tel:+46764147049 >>> >>> _______________________________________________ >>> Mailing list: https://launchpad.net/~dhis2-devs >>> Post to : dhis2-devs@lists.launchpad.net >>> Unsubscribe : https://launchpad.net/~dhis2-devs >>> More help : https://help.launchpad.net/ListHelp >>> >>> >> >> _______________________________________________ >> Mailing list: https://launchpad.net/~dhis2-devs >> Post to : dhis2-devs@lists.launchpad.net >> Unsubscribe : https://launchpad.net/~dhis2-devs >> More help : https://help.launchpad.net/ListHelp >> >> > > > -- > Alex Tumwesigye > > Technical Advisor - DHIS2 (Consultant), > Ministry of Health/AFENET > Kampala > Uganda > > IT Consultant - BarefootPower Uganda Ltd, SmartSolar, Kenya > > IT Specialist (Servers, Networks and Security, Health Information Systems > - DHIS2 ) & Solar Consultant > > +256 774149 775, + 256 759 800161 > > "I don't want to be anything other than what I have been - one tree hill " >
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp