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
