dhis2-users team mailing list archive

[Lars Helge Øverland <larshelge@xxxxxxxxx>]

Hi Edwin,

there is no link between resource tables and meta-data import so I don't
think that's significant. Since the logs says surname cannot be null I
think that was the source of the problem - there might be a problem with
the export function not including surnames, or some database integrity
issues with the source database.

Lars



On Tue, Dec 17, 2013 at 11:10 AM, Edwin Mulwa <eddiemu@xxxxxxxxx> wrote:

> Hi All,
>
> An interesting update is as follows:
>
> I removed ALL the users in the XML file and managed to import everything.
> This of course didn't really solve my problem because I eventually needed
> to import users as well.
>
> After importation, I encountered a new problem:
>
> When I tried to do data entry, the Data Sets combo box was not loading
> with data. Checking the log, I found the following message:
>
>
> ** ERROR 2013-12-17 01:00:56,744 Resource table
> _dataelementcategoryoptioncomboname does not exist, please generate it
> (HibernateDataElementStore.java [http-bio-8080-exec-9])*
> I found, from checking previous posts, that I needed to create resource
> tables from Maintenance->Data Administration; which I did. Then I decided
> to try and import all my metadata afresh, including the users (ensuring
> that all users have firstname and surname defined) and the import WORKED!!
>
> What this means is that the error I was getting telling me that the
> surname should not be null AFTER I had rectified the source XML file was
> not an accurately reported error. The error must have been something to do
> with missing resource tables. I think this is a potential bug in DHIS that
> should be investigated.
>
> Edwin
>
>
>
> On Mon, Dec 16, 2013 at 5:03 PM, Morten Olav Hansen <mortenoh@xxxxxxxxx>wrote:
>
>> Hi Edwin,
>>
>> I'm not really sure.. if you know your way around a text-editor, you can
>> try and remove all user but a few.. and see if it still fails, there might
>> be a few users in there that have some errors
>>
>> --
>> Morten
>>
>>
>> On Mon, Dec 16, 2013 at 2:52 PM, Edwin Mulwa <eddiemu@xxxxxxxxx> wrote:
>>
>>> Hi Morten,
>>>
>>> You pointed me in the right direction. Thanks.
>>>
>>> Taking a look at the log, it shows that there is a NULL value in surname
>>> field when its trying to insert a record in the userinfo table. I checked
>>> the source metadata.xml file and ensured that all surname entries have a
>>> value. I still get the same error.
>>>
>>> See attached log snippet.
>>>
>>> Any thoughts on why this is persisting even in the absence of NULL
>>> values?
>>>
>>> Edwin
>>>
>>>
>>>
>>> On Mon, Dec 16, 2013 at 4:59 AM, Edwin Mulwa <eddiemu@xxxxxxxxx> wrote:
>>>
>>>> Ok, thanks. Yes I am...
>>>>
>>>>
>>>> On Mon, Dec 16, 2013 at 3:37 PM, Morten Olav Hansen <mortenoh@xxxxxxxxx
>>>> > wrote:
>>>>
>>>>> I would recommend looking at logs/catalina.out (assuming you are
>>>>> running tomcat)
>>>>>
>>>>> --
>>>>> Morten
>>>>>
>>>>>
>>>>> On Mon, Dec 16, 2013 at 1:31 PM, Edwin Mulwa <eddiemu@xxxxxxxxx>wrote:
>>>>>
>>>>>> Hi,
>>>>>>
>>>>>> I am importing all metadata from one instance of DHIS2 to another.
>>>>>> The import process seems to be hanging on the Importing Users section (see
>>>>>> attached screenshot).
>>>>>>
>>>>>> Is there an import log that I can check to see what is happening?
>>>>>>
>>>>>> Edwin
>>>>>>
>>>>>>
>>>>>>
>>>>>> _______________________________________________
>>>>>> 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
>>>>>>
>>>>>>
>>>>>
>>>>
>>>
>>
>
> _______________________________________________
> 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
>
>