Hello Bob and Jason, Thank you for your reply. I was testing hence the H2 database, I will try on postgres. Yes, that was where the log file stopped but I have attached output from starting the application from the command promp which seems to give more information.
Regards, Chris On 29 September 2012 18:00, Jason Pickering <jason.p.picker...@gmail.com>wrote: > Not traveling yet but soon. > > Most important is to resolve all metadata data integrity violations in 1.4 > and and I agree with Bob, do not use H2 for this. > > We will try and provide more feedback tomorrow. > > Regards, > Jason > > -- > Sent from my mobile > On Sep 29, 2012 5:23 PM, "Chris Onoja" <chrisono...@gmail.com> wrote: > >> Hello, >> >> I am trying to import data from DHIS 1.4 into the H2 database that comes >> with dhis live package, the system however hangs each time I invoke the >> import process (attached is the log file). I am using version 2.8, the >> webpage didnt load at all when i tried using version 2.9. Can anyone help >> please? >> >> I am using windows vista home edition, 64-bit OS. >> >> Thank you. >> >> _______________________________________________ >> Mailing list: https://launchpad.net/~dhis2-users >> Post to : dhis2-users@lists.launchpad.net >> Unsubscribe : https://launchpad.net/~dhis2-users >> More help : https://help.launchpad.net/ListHelp >> >>
C:\Users\conoja\Desktop\dhis-live>java -jar dhis2-live.jar * INFO 17:53:19,544 Environment variable DHIS2_HOME: C:\Users\conoja\Desktop \dhis-live\conf\hibernate.properties (TrayApp.java [main]) * INFO 17:53:19,595 Initialising DHIS 2 Live... (TrayApp.java [main]) * INFO 17:53:19,790 Loading DHIS 2 on port: 8082 (WebAppServer.java [main]) 2012-09-29 17:53:19.803:INFO::Logging to STDERR via org.mortbay.log.StdErrLog * INFO 17:53:19,847 Setting DHIS 2 web app context to: /C:/Users/conoja/Desk top/dhis-live/webapps/dhis (WebAppServer.java [main]) * INFO 17:53:19,849 Lifecycle: server starting (TrayApp.java [Thread-3]) 2012-09-29 17:53:19.860:INFO::jetty-6.1.x 2012-09-29 17:53:20.561:INFO::NO JSP Support for /, did not find org.apache.jasp er.servlet.JspServlet 2012-09-29 17:53:21.410:INFO:/:Initializing Spring root WebApplicationContext * INFO 17:53:30,501 System property dhis2.home points to /C:/Users/conoja/De sktop/dhis-live/conf (DefaultLocationManager.java [Thread-3]) * ERROR 17:54:06,882 HHH000388: Unsuccessful: alter table dataelementcategoryopt ion add constraint fk_dataelementcategory_conceptid foreign key (conceptid) refe rences concept (SchemaUpdate.java [Thread-3]) * ERROR 17:54:06,883 Constraint "FK_DATAELEMENTCATEGORY_CONCEPTID" already exist s; SQL statement: alter table dataelementcategoryoption add constraint fk_dataelementcategory_conc eptid foreign key (conceptid) references concept [90045-154] (SchemaUpdate.java [Thread-3]) * INFO 17:54:28,719 Found the following message senders: [org.hisp.dhis.message .EmailMessageSender@61201a5c] (DefaultMessageService.java [Thread-3]) * INFO 17:54:41,126 Camel context started (DHIS2LifecycleStrategy.java [Thread- 3]) * INFO 17:54:41,247 Camel endpoint added: spring-event://default (DHIS2Lifecycl eStrategy.java [Thread-3]) * INFO 17:54:41,265 Executing startup routine [1 of 9, runlevel 1]: TableAltero r (DefaultStartupRoutineExecutor.java [Thread-3]) * INFO 17:54:41,943 Tables updated (TableAlteror.java [Thread-3]) * INFO 17:54:41,945 Executing startup routine [2 of 9, runlevel 2]: IdentityPop ulator (DefaultStartupRoutineExecutor.java [Thread-3]) * INFO 17:54:41,958 Executing startup routine [3 of 9, runlevel 2]: PeriodTypeP opulator (DefaultStartupRoutineExecutor.java [Thread-3]) * INFO 17:54:42,008 Executing startup routine [4 of 9, runlevel 3]: TableCreato r (DefaultStartupRoutineExecutor.java [Thread-3]) * INFO 17:54:42,119 Executing startup routine [5 of 9, runlevel 3]: DataElement DefaultDimensionPopulator (DefaultStartupRoutineExecutor.java [Thread-3]) * INFO 17:54:42,164 Linked default category with default concept (DataElementDe faultDimensionPopulator.java [Thread-3]) * INFO 17:54:42,193 Executing startup routine [6 of 9, runlevel 4]: PatientTabl eAlteror (DefaultStartupRoutineExecutor.java [Thread-3]) * INFO 17:54:42,297 Executing startup routine [7 of 9, runlevel 5]: Organisatio nUnitGroupSetPopulator (DefaultStartupRoutineExecutor.java [Thread-3]) * INFO 17:54:42,306 Executing startup routine [8 of 9, runlevel 5]: DataEntryFo rmUpgrader (DefaultStartupRoutineExecutor.java [Thread-3]) * INFO 17:54:42,309 Upgraded custom case entry form identifiers: 0 (DataEntryFo rmUpgrader.java [Thread-3]) * INFO 17:54:42,310 Executing startup routine [9 of 9, runlevel 5]: ProgramAttr ibutePopulator (DefaultStartupRoutineExecutor.java [Thread-3]) * INFO 17:54:42,316 All startup routines done (DefaultStartupRoutineExecutor.ja va [Thread-3]) 2012-09-29 17:54:45.671:INFO:/:Initializing Spring FrameworkServlet 'webapiServl et' 2012-09-29 17:54:54.342:INFO::Started SelectChannelConnector@0.0.0.0:8082 * INFO 17:54:54,343 Lifecycle: server started (TrayApp.java [Thread-3]) * INFO 17:55:04,845 User login success: 'admin' (DefaultUserAuditService.java [ 169937755@qtp-739893596-0]) * INFO 17:55:55,779 Content-type: application/zip, filename: C:\Users\conoja \AppData\Local\Temp\Jetty_0_0_0_0_8082_dhis____.jo8ie7\upload__7d66249a_13a12bdb d63__8000_00000001.tmp (ImportAction.java [169937755@qtp-739893596-0]) * INFO 17:55:55,851 Internal process started (AbstractStatementInternalProcess. java [Thread-19]) * WARN 17:55:55,886 Resource Leaking: Could not remove uploaded file 'C:\Users \conoja\AppData\Local\Temp\Jetty_0_0_0_0_8082_dhis____.jo8ie7\upload__7d66249 a_13a12bdbd63__8000_00000001.tmp'. (CommonsLogger.java [169937755@qtp-739893596- 0]) * INFO 17:55:55,898 Reading file: NG_NIGERIA_MASTER_BACATMA_Bauchi_State_Oct_20 11_to_Nov_2011.xml (DefaultDhis14XMLImportService.java [Thread-19]) * INFO 17:55:55,902 Importing meta data (DefaultDhis14XMLImportService.java [Th read-19]) Exception in thread "Thread-19" java.lang.OutOfMemoryError: PermGen space 2012-09-29 17:56:22.526:WARN::handle failed java.lang.OutOfMemoryError: PermGen space 2012-09-29 17:56:38.842:WARN::Error for /dhis-web-maintenance-dataadmin/index.ac tion java.lang.OutOfMemoryError: PermGen space 2012-09-29 17:56:42.469:WARN::/dhis-web-maintenance-dataadmin/index.action java.lang.OutOfMemoryError: PermGen space
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp