dhis2-devs team mailing list archive

[Jason Pickering <jason.p.pickering@xxxxxxxxx>]

Hi Lamin,
I suspect this is due to an orgunit which is assigned to a dataset,
but which does not exist in the hierarchy. DHIS 1.4 does not catch
this in the integrity checks, but you should run the integrity checks
anyway by choosing "Add-Ins->Core Module->Advanced->Data integrity
checks" from the DHIS 1.4 menu (if you are using Office 2007). You
should resolve ALL data integrity violations if they exist in the 1.4
database.

In terms of resolving this issue here is my guess. You need to open
the "DataSetOrgUnit" table in 1.4, and then sort from "A-Z" in both
columns. If you see any numbers, this implies that there are orgunits
which are assigned to a dataset which do not exist in the hierarchy.
You should delete these columms, re-export from 1.4, and attempt the
import again. We have discussed this issue previously on the mailing
list, so you can search through the archives for some more mails.

This may have been corrected in subsequent versions, but it should
nonetheless be fixed in the 1.4 database.

Regards,
Jason


On Thu, Jul 21, 2011 at 1:05 PM, Lamin B. Jawara <laminbjawara@xxxxxxxxx> wrote:
> Hi Jason,
> The build revision is 2976,  I have not run integrity check, can you show me
> how to do that.
> We have 6 regions in the Gambia and all the other regions will be imported
> in the system expect two regions which doubt me.
>
> On Thu, Jul 21, 2011 at 10:08 AM, Jason Pickering
> <jason.p.pickering@xxxxxxxxx> wrote:
>>
>> Hi there.
>>
>> Could you also provide the build revision you are using (Available
>> from the "Help->About" menu under Build revision). I know Lars has
>> made some changes lately which may correct this issue, but it seems to
>> be something to do with some metadata element being NULL when it
>> should not be.
>>
>> Have you run all integrity checks on the 1.4 database to be sure the
>> metadata is OK?
>>
>> Regards,
>> Jason
>>
>>
>> On Wed, Jul 20, 2011 at 7:39 AM, Bharath <chbharathk@xxxxxxxxx> wrote:
>> >
>> >
>> > ---------- Forwarded message ----------
>> > From: Lamin B. Jawara <laminbjawara@xxxxxxxxx>
>> > Date: Wed, Jul 20, 2011 at 6:52 AM
>> > Subject: Re: Greeting from the Gambia
>> > To: Bharath <chbharathk@xxxxxxxxx>
>> >
>> >
>> > Dear Kumar,
>> > I try to import two of my region but it fails and attached is the log
>> > file.
>> > All the other regions works expect these two and it keep failing.
>> > please i need your help.
>> > Many thanks,
>> >
>> >>
>> >> On Sun, Jul 17, 2011 at 3:13 PM, Lamin B. Jawara
>> >> <laminbjawara@xxxxxxxxx>
>> >> wrote:
>> >>>
>> >>> Hello Sir,
>> >>> My name is Lamin, I am from the Gambia working with dhis, i just want
>> >>> to
>> >>> say hello to you.
>> >>> All the best,
>> >>> --
>> >>> Lamin B. Jawara
>> >>> Tel: +220 9907404 / 7229017
>> >>> Email: laminbjawara@xxxxxxxxx
>> >>> http://lbjawara.wordpress.com
>> >>>
>> >>
>> >>
>> >>
>> >> --
>> >>
>> >> Regards,
>> >> Bharath Kumar. Ch
>> >
>> >
>> >
>> >
>> > --
>> > Lamin B. Jawara
>> > Tel: +220 9907404 / 7229017
>> > Email: laminbjawara@xxxxxxxxx
>> > http://lbjawara.wordpress.com
>> >
>> >
>> >
>> >
>> > --
>> >
>> > Regards,
>> > Bharath Kumar. Ch
>> >
>> > _______________________________________________
>> > 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
>> >
>> >
>
>
>
> --
> Lamin B. Jawara
> Tel: +220 9907404 / 7229017
> Email: laminbjawara@xxxxxxxxx
> http://lbjawara.wordpress.com
>
>