Re: [Dhis2-devs] DHIS Import Log?

2013-12-19 Thread Edwin Mulwa
Hi Lars, That could indeed be the case though the interesting thing is that it was only after I created the resources tables that the import went through - using the same dataset that had failed initially when I did not do the resource tables creation. I tested this multiple times just to be

Re: [Dhis2-devs] DHIS Import Log?

2013-12-19 Thread Lars Helge Ă˜verland
Okay thank you Edwin.. Lars On Thu, Dec 19, 2013 at 9:16 AM, Edwin Mulwa eddi...@gmail.com wrote: Hi Lars, That could indeed be the case though the interesting thing is that it was only after I created the resources tables that the import went through - using the same dataset that had

Re: [Dhis2-devs] DHIS Import Log?

2013-12-18 Thread Lars Helge Ă˜verland
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

Re: [Dhis2-devs] DHIS Import Log?

2013-12-17 Thread Edwin Mulwa
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

Re: [Dhis2-devs] DHIS Import Log?

2013-12-16 Thread Morten Olav Hansen
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 eddi...@gmail.com wrote: Hi, I am importing all metadata from one instance of DHIS2 to another. The import process seems to be hanging on the Importing

Re: [Dhis2-devs] DHIS Import Log?

2013-12-16 Thread Edwin Mulwa
Ok, thanks. Yes I am... On Mon, Dec 16, 2013 at 3:37 PM, Morten Olav Hansen morte...@gmail.comwrote: 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 eddi...@gmail.com wrote: Hi, I am importing

Re: [Dhis2-devs] DHIS Import Log?

2013-12-16 Thread Edwin Mulwa
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

Re: [Dhis2-devs] DHIS Import Log?

2013-12-16 Thread Morten Olav Hansen
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 eddi...@gmail.com wrote: Hi