dhis2-users team mailing list archive

[Chris Onoja <chrisonoja0@xxxxxxxxx>]

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.pickering@xxxxxxxxx>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" <chrisonoja0@xxxxxxxxx> 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@xxxxxxxxxxxxxxxxxxx
>> 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