dhis2-devs team mailing list archive

[Morten Olav Hansen <mortenoh@xxxxxxxxx>]

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.pickering@xxxxxxxxx> 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 <
> mritunjd@xxxxxxxxxxxxxxxx> 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.pickering@xxxxxxxxx> 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 <
>>> mritunjd@xxxxxxxxxxxxxxxx> wrote:
>>>
>>>>
>>>> ---------- Forwarded message ----------
>>>> From: Mritunjay Dubey <mritunjd@xxxxxxxxxxxxxxxx>
>>>> Date: Tue, Jul 14, 2015 at 2:58 PM
>>>> Subject: Re: [Dhis2-devs] Deployable war for previous builds
>>>> To: Lars Helge Øverland <larshelge@xxxxxxxxx>
>>>>
>>>>
>>>> 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 <
>>>> mritunjd@xxxxxxxxxxxxxxxx> 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 <
>>>>> larshelge@xxxxxxxxx> 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 <
>>>>>> larshelge@xxxxxxxxx> 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 <
>>>>>>> mritunjd@xxxxxxxxxxxxxxxx> 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@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>
>>>>>>>
>>>>>>>
>>>>>>
>>>>>>
>>>>>> --
>>>>>> 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@xxxxxxxxxxxxxxxxxxx
>>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>>> More help   : https://help.launchpad.net/ListHelp
>>>>
>>>>
>>>
>>>
>>> --
>>> Jason P. Pickering
>>> email: jason.p.pickering@xxxxxxxxx
>>> tel:+46764147049
>>>
>>
>>
>
>
> --
> Jason P. Pickering
> email: jason.p.pickering@xxxxxxxxx
> tel:+46764147049
>
> _______________________________________________
> 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
>
>