That would explain it, as 2.16 is a year old now... On Tue, Jul 14, 2015 at 12:32 PM, Mritunjay Dubey <mritu...@thoughtworks.com > wrote:
> Hey Jason, > > We are using DHIS 2.16 at both instances. > The build rev for source instance is *16594* and for destination instance > it is *16598*. > > Let me know if it is fixed. > Thank you > > > > On Tue, Jul 14, 2015 at 3:49 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 > > -- Knut Staring Dept. of Informatics, University of Oslo Norway: +4791880522 Skype: knutstar http://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