dhis2-devs team mailing list archive

[Edwin Mulwa <eddiemu@xxxxxxxxx>]

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
>>>>>
>>>>>
>>>>
>>>
>>
>