dhis2-devs team mailing list archive

[Lars Helge Øverland <larshelge@xxxxxxxxx>]

On Mon, May 3, 2010 at 12:44 PM, Jason Pickering <
jason.p.pickering@xxxxxxxxx> wrote:

> Duh, sorry for this. My own mistake, but at least it is documented now..
>
> I was missing
>
> hibernate.hbm2ddl.auto = update
>
> in the hibernate.properties file.
>
> Since this seems to be required, it might be a good idea to be sure it
> is there before the app attempts to fire itself up!
>
> Regards,
> Jason
>

Okay. Using hbm2dll in production settings is not really recommended but we
are doing it anyway. The alternative is to distribute sql scripts that
creates the database - and publishing new ones/amendments every time we make
a change.

I guess you were starting up a new database this time..

Lars


>
>
> On Mon, May 3, 2010 at 11:44 AM, Jason Pickering
> <jason.p.pickering@xxxxxxxxx> wrote:
> > Hi there. I am having some issues with the latest version. Sorry for
> > the lengthy mail, but I have copied and pasted a bunch of log files.
> >
> > I am using Postgres, Java 1.6.19, Tomcat 6.0.24 on Ubuntu.
> >
> > During startup on a clean DB, only these are the tables that are created.
> >
> > dhis2_tj=# \dt
> >                     List of relations
> >  Schema |             Name              | Type  |  Owner
> > --------+-------------------------------+-------+----------
> >  public | aggregateddatasetcompleteness | table | postgres
> >  public | aggregateddatavalue           | table | postgres
> >  public | aggregatedindicatorvalue      | table | postgres
> >  public | categoryoptioncombo           | table | postgres
> >  public | dataelement                   | table | postgres
> >  public | datavaluearchive              | table | postgres
> >  public | period                        | table | postgres
> >  public | source                        | table | postgres
> > (8 rows)
> >
> > DHIS2 appears to start correctly the application, I get this..
> >
> > May 3, 2010 10:48:05 AM org.apache.catalina.startup.HostConfig
> deployDirectory
> > INFO: Deploying web application directory ROOT
> > May 3, 2010 10:48:05 AM org.apache.catalina.startup.HostConfig
> deployDirectory
> > INFO: Deploying web application directory docs
> > May 3, 2010 10:48:05 AM org.apache.coyote.http11.Http11AprProtocol start
> > INFO: Starting Coyote HTTP/1.1 on http-8080
> > May 3, 2010 10:48:05 AM org.apache.coyote.ajp.AjpAprProtocol start
> > INFO: Starting Coyote AJP/1.3 on ajp-8009
> > May 3, 2010 10:48:05 AM org.apache.catalina.startup.Catalina start
> > INFO: Server startup in 36108 ms
> > May 3, 2010 11:35:12 AM org.apache.catalina.core.AprLifecycleListener
> init
> > INFO: Loaded APR based Apache Tomcat Native library 1.1.20.
> > May 3, 2010 11:35:12 AM org.apache.catalina.core.AprLifecycleListener
> init
> > INFO: APR capabilities: IPv6 [true], sendfile [true], accept filters
> > [false], random [true].
> > May 3, 2010 11:35:12 AM org.apache.catalina.core.AprLifecycleListener
> > lifecycleEvent
> > INFO: Failed to initialize the SSLEngine.
> > May 3, 2010 11:35:12 AM org.apache.coyote.http11.Http11AprProtocol init
> > INFO: Initializing Coyote HTTP/1.1 on http-8080
> > May 3, 2010 11:35:12 AM org.apache.coyote.ajp.AjpAprProtocol init
> > INFO: Initializing Coyote AJP/1.3 on ajp-8009
> > May 3, 2010 11:35:12 AM org.apache.catalina.startup.Catalina load
> > INFO: Initialization processed in 2020 ms
> > May 3, 2010 11:35:13 AM org.apache.catalina.core.StandardService start
> > INFO: Starting service Catalina
> > May 3, 2010 11:35:13 AM org.apache.catalina.core.StandardEngine start
> > INFO: Starting Servlet Engine: Apache Tomcat/6.0.26
> > May 3, 2010 11:35:13 AM org.apache.catalina.startup.HostConfig
> deployDescriptor
> > INFO: Deploying configuration descriptor manager.xml
> > May 3, 2010 11:35:13 AM org.apache.catalina.startup.HostConfig
> deployDescriptor
> > INFO: Deploying configuration descriptor host-manager.xml
> > May 3, 2010 11:35:14 AM org.apache.catalina.startup.HostConfig deployWAR
> > INFO: Deploying web application archive dhis.war
> > May 3, 2010 11:35:17 AM org.apache.catalina.loader.WebappClassLoader
> > validateJarFile
> > INFO:
> validateJarFile(/usr/local/apache-tomcat-6.0.26/webapps/dhis/WEB-INF/lib/servlet-api-2.4.jar)
> > - jar not loaded. See Servlet Spec 2.3, section 9.7.2. Offending
> > class: javax/servlet/Servlet.class
> > log4j:WARN No such property [maxFileSize] in
> > org.apache.log4j.DailyRollingFileAppender.
> > log4j:WARN No such property [maxBackupIndex] in
> > org.apache.log4j.DailyRollingFileAppender.
> > * INFO  11:35:25,504 System property dhis2.home not set
> > (DefaultLocationManager.java [main])
> > * INFO  11:35:25,523 Environment variable DHIS2_HOME points to
> > /usr/local/apache-tomcat-6.0.26/conf/dhis2/
> > (DefaultLocationManager.java [main])
> > * INFO  11:35:45,159 Executing startup routine [1 of 13, runlevel 0]:
> > DataSetShortNamePopulator (DefaultStartupRoutineExecutor.java [main])
> > * INFO  11:35:45,383 Populated DataSet short name and code
> > (DataSetShortNamePopulator.java [main])
> > * INFO  11:35:45,384 Executing startup routine [2 of 13, runlevel 0]:
> > UuidPopulator (DefaultStartupRoutineExecutor.java [main])
> > * INFO  11:35:45,392 Checked CategoryOption uuids (UuidPopulator.java
> [main])
> > * INFO  11:35:45,400 Checked Category uuids (UuidPopulator.java [main])
> > * INFO  11:35:45,413 Checked DataElement uuids (UuidPopulator.java
> [main])
> > * INFO  11:35:45,413 Executing startup routine [3 of 13, runlevel 0]:
> > OrganisationUnitHierarchyVerifier (DefaultStartupRoutineExecutor.java
> > [main])
> > * WARN  11:35:45,729 firstResult/maxResults specified with collection
> > fetch; applying in memory! (QueryTranslatorImpl.java [main])
> > * INFO  11:35:45,821 Added organistion unit hierarchy
> > (OrganisationUnitHierarchyVerifier.java [main])
> > * INFO  11:35:45,821 Executing startup routine [4 of 13, runlevel 0]:
> > OrganisationUnitGroupSetPopulator (DefaultStartupRoutineExecutor.java
> > [main])
> > * INFO  11:35:45,841 Executing startup routine [5 of 13, runlevel 0]:
> > OpenHealthDataSourceWriter (DefaultStartupRoutineExecutor.java [main])
> > * INFO  11:35:45,841 Environment variable OPENHEALTH_HOME not set
> > (OpenHealthDataSourceWriter.java [main])
> > * INFO  11:35:45,842 Executing startup routine [6 of 13, runlevel 0]:
> > ReportTableUpgrader (DefaultStartupRoutineExecutor.java [main])
> > * INFO  11:35:45,845 Upgraded report tables (ReportTableUpgrader.java
> [main])
> > * INFO  11:35:45,846 Executing startup routine [7 of 13, runlevel 1]:
> > $Proxy34 (DefaultStartupRoutineExecutor.java [main])
> > * INFO  11:35:46,183 Updated Category sort order and primary keys
> > (OptionsCategoriesDefaultSortOrderPopulator.java [main])
> > * INFO  11:35:46,184 Executing startup routine [8 of 13, runlevel 1]:
> > $Proxy34 (DefaultStartupRoutineExecutor.java [main])
> > * INFO  11:35:46,202 Executing startup routine [9 of 13, runlevel 1]:
> > $Proxy34 (DefaultStartupRoutineExecutor.java [main])
> > * INFO  11:35:46,203 Removing datasetid column from dataentryform
> > table (DataEntryFormPopulator.java [main])
> > * INFO  11:35:46,346 Executing startup routine [10 of 13, runlevel 2]:
> > $Proxy34 (DefaultStartupRoutineExecutor.java [main])
> > * INFO  11:35:46,383 Added default dataelement dimension
> > (DataElementDefaultDimensionPopulator.java [main])
> > * INFO  11:35:46,407 Executing startup routine [11 of 13, runlevel 2]:
> > $Proxy34 (DefaultStartupRoutineExecutor.java [main])
> > * INFO  11:35:46,434 Executing startup routine [12 of 13, runlevel 3]:
> > TableCreator (DefaultStartupRoutineExecutor.java [main])
> > * INFO  11:35:46,438 Created table aggregateddatavalue
> > (TableCreator.java [main])
> > * INFO  11:35:46,441 Created table aggregatedindicatorvalue
> > (TableCreator.java [main])
> > * INFO  11:35:46,457 Created index crosstab on table datavalue
> > (TableCreator.java [main])
> > * INFO  11:35:46,460 Created table aggregateddatasetcompleteness
> > (TableCreator.java [main])
> > * INFO  11:35:46,473 Created table aggregateddatasetcompleteness
> > (TableCreator.java [main])
> > * INFO  11:35:46,473 Executing startup routine [13 of 13, runlevel
> > 10]: I18nUpgrader (DefaultStartupRoutineExecutor.java [main])
> > * INFO  11:35:46,508 I18n Upgrader running using locale English
> > (United Kingdom) (I18nUpgrader.java [main])
> > * INFO  11:35:46,527 I18n Upgrader: OrganisationUnitGroupSet (2)
> > (I18nUpgrader.java [main])
> > * INFO  11:35:46,534 I81n Upgrader: DataElementCategory (1)
> > (I18nUpgrader.java [main])
> > * INFO  11:35:46,537 I81n Upgrader: DataElementCategoryOption (1)
> > (I18nUpgrader.java [main])
> > * INFO  11:35:46,540 I81n Upgrader: DataElementCategoryCombo (1)
> > (I18nUpgrader.java [main])
> > * INFO  11:35:46,541 All startup routines done
> > (DefaultStartupRoutineExecutor.java [main])
> > May 3, 2010 11:35:49 AM org.apache.catalina.startup.HostConfig
> deployDirectory
> > INFO: Deploying web application directory examples
> > May 3, 2010 11:35:49 AM org.apache.catalina.startup.HostConfig
> deployDirectory
> > INFO: Deploying web application directory ROOT
> > May 3, 2010 11:35:49 AM org.apache.catalina.startup.HostConfig
> deployDirectory
> > INFO: Deploying web application directory docs
> > May 3, 2010 11:35:49 AM org.apache.coyote.http11.Http11AprProtocol start
> > INFO: Starting Coyote HTTP/1.1 on http-8080
> > May 3, 2010 11:35:49 AM org.apache.coyote.ajp.AjpAprProtocol start
> > INFO: Starting Coyote AJP/1.3 on ajp-8009
> > May 3, 2010 11:35:49 AM org.apache.catalina.startup.Catalina start
> > INFO: Server startup in 36984 ms
> > * AUDIT_TRAIL 11:36:11,757 User  "null" added User "admin admin"
> > (HibernateUserStore.java [http-8080-1])
> > * INFO  11:36:17,940 User login success: 'admin'
> > (DefaultUserAuditService.java [http-8080-1])
> > * INFO  11:36:21,364 User logout: 'admin'
> > (DefaultUserAuditService.java [http-8080-2])
> >
> > I was able to login, which seems very strange, as there is no user
> > table. But when I logout I see this..
> >
> > INFO: Stopping service Catalina
> > May 3, 2010 11:36:31 AM org.apache.catalina.loader.WebappClassLoader
> > clearReferencesJdbc
> > SEVERE: A web application registered the JBDC driver [org.h2.Driver]
> > but failed to unregister it when the web application was stopped. To
> > prevent a memory leak, the JDBC Driver has been forcibly unregistered.
> > May 3, 2010 11:36:31 AM org.apache.catalina.loader.WebappClassLoader
> > clearReferencesJdbc
> > SEVERE: A web application registered the JBDC driver
> > [com.mysql.jdbc.Driver] but failed to unregister it when the web
> > application was stopped. To prevent a memory leak, the JDBC Driver has
> > been forcibly unregistered.
> > May 3, 2010 11:36:31 AM org.apache.catalina.loader.WebappClassLoader
> > clearReferencesJdbc
> > SEVERE: A web application registered the JBDC driver
> > [org.postgresql.Driver] but failed to unregister it when the web
> > application was stopped. To prevent a memory leak, the JDBC Driver has
> > been forcibly unregistered.
> > May 3, 2010 11:36:31 AM org.apache.catalina.loader.WebappClassLoader
> > clearThreadLocalMap
> > SEVERE: A web application created a ThreadLocal with key of type
> > [null] (value [com.opensymphony.xwork2.inject.ContainerImpl$10@ffeba4])
> > and a value of type [java.lang.Object[]] (value
> > [[Ljava.lang.Object;@1c78066]) but failed to remove it when the web
> > application was stopped. To prevent a memory leak, the ThreadLocal has
> > been forcibly removed.
> > May 3, 2010 11:36:31 AM org.apache.catalina.loader.WebappClassLoader
> > clearThreadLocalMap
> > SEVERE: A web application created a ThreadLocal with key of type
> > [null] (value [com.opensymphony.xwork2.inject.ContainerImpl$10@becf68])
> > and a value of type [java.lang.Object[]] (value
> > [[Ljava.lang.Object;@122c082]) but failed to remove it when the web
> > application was stopped. To prevent a memory leak, the ThreadLocal has
> > been forcibly removed.
> > May 3, 2010 11:36:31 AM org.apache.catalina.loader.WebappClassLoader
> > clearThreadLocalMap
> > SEVERE: A web application created a ThreadLocal with key of type
> > [null] (value [com.opensymphony.xwork2.inject.ContainerImpl$10@becf68])
> > and a value of type [java.lang.Object[]] (value
> > [[Ljava.lang.Object;@1fd8905]) but failed to remove it when the web
> > application was stopped. To prevent a memory leak, the ThreadLocal has
> > been forcibly removed.
> > No protocol specified
> >
> >
> >
> > Finally, when I try and start the application again, I get this..
> >
> > ction 9.7.2. Offending class: javax/servlet/Servlet.class
> > log4j:WARN No such property [maxFileSize] in
> > org.apache.log4j.DailyRollingFileAppender.
> > log4j:WARN No such property [maxBackupIndex] in
> > org.apache.log4j.DailyRollingFileAppender.
> > * INFO  11:41:47,577 System property dhis2.home not set
> > (DefaultLocationManager.java [main])
> > * INFO  11:41:47,582 Environment variable DHIS2_HOME points to
> > /usr/local/apache-tomcat-6.0.26/conf/dhis2/
> > (DefaultLocationManager.java [main])
> > * ERROR 11:41:56,075 Unsuccessful: create table categoryoptioncombo
> > (categoryoptioncomboid int4 not null, primary key
> > (categoryoptioncomboid)) (SchemaExport.java [main])
> > * ERROR 11:41:56,076 ERROR: relation "categoryoptioncombo" already
> > exists (SchemaExport.java [main])
> > * ERROR 11:41:56,277 Unsuccessful: create table dataelement
> > (dataelementid int4 not null, uuid varchar(40), name varchar(230) not
> > null unique, alternativename varchar(230) unique, shortname
> > varchar(25) not null unique, code varchar(100), description text,
> > active bool, valuetype varchar(16) not null, domaintype varchar(16),
> > aggregationtype varchar(16) not null, extendeddataelementid int4
> > unique, categorycomboid int4, sortOrder int4, url varchar(255),
> > lastUpdated timestamp, zeroIsSignificant bool, primary key
> > (dataelementid)) (SchemaExport.java [main])
> > * ERROR 11:41:56,279 ERROR: relation "dataelement" already exists
> > (SchemaExport.java [main])
> > * ERROR 11:41:57,400 Unsuccessful: create table period (periodid int4
> > not null, periodtypeid int4, startdate date not null, enddate date not
> > null, primary key (periodid), unique (periodtypeid, startdate,
> > enddate)) (SchemaExport.java [main])
> > * ERROR 11:41:57,402 ERROR: relation "period" already exists
> > (SchemaExport.java [main])
> > * ERROR 11:41:57,877 Unsuccessful: create table source (sourceid int4
> > not null, primary key (sourceid)) (SchemaExport.java [main])
> > * ERROR 11:41:57,879 ERROR: relation "source" already exists
> > (SchemaExport.java [main])
> > * INFO  11:42:08,405 Executing startup routine [1 of 13, runlevel 0]:
> > DataSetShortNamePopulator (DefaultStartupRoutineExecutor.java [main])
> > * INFO  11:42:08,572 Populated DataSet short name and code
> > (DataSetShortNamePopulator.java [main])
> > * INFO  11:42:08,572 Executing startup routine [2 of 13, runlevel 0]:
> > UuidPopulator (DefaultStartupRoutineExecutor.java [main])
> > * INFO  11:42:08,581 Checked CategoryOption uuids (UuidPopulator.java
> [main])
> > * INFO  11:42:08,591 Checked Category uuids (UuidPopulator.java [main])
> > * INFO  11:42:08,604 Checked DataElement uuids (UuidPopulator.java
> [main])
> > * INFO  11:42:08,604 Executing startup routine [3 of 13, runlevel 0]:
> > OrganisationUnitHierarchyVerifier (DefaultStartupRoutineExecutor.java
> > [main])
> > * WARN  11:42:08,901 firstResult/maxResults specified with collection
> > fetch; applying in memory! (QueryTranslatorImpl.java [main])
> > * INFO  11:42:08,975 Added organistion unit hierarchy
> > (OrganisationUnitHierarchyVerifier.java [main])
> > * INFO  11:42:08,975 Executing startup routine [4 of 13, runlevel 0]:
> > OrganisationUnitGroupSetPopulator (DefaultStartupRoutineExecutor.java
> > [main])
> > * INFO  11:42:08,993 Executing startup routine [5 of 13, runlevel 0]:
> > OpenHealthDataSourceWriter (DefaultStartupRoutineExecutor.java [main])
> > * INFO  11:42:08,993 Environment variable OPENHEALTH_HOME not set
> > (OpenHealthDataSourceWriter.java [main])
> > * INFO  11:42:08,994 Executing startup routine [6 of 13, runlevel 0]:
> > ReportTableUpgrader (DefaultStartupRoutineExecutor.java [main])
> > * INFO  11:42:08,997 Upgraded report tables (ReportTableUpgrader.java
> [main])
> > * INFO  11:42:08,997 Executing startup routine [7 of 13, runlevel 1]:
> > $Proxy34 (DefaultStartupRoutineExecutor.java [main])
> > * INFO  11:42:09,151 Updated Category sort order and primary keys
> > (OptionsCategoriesDefaultSortOrderPopulator.java [main])
> > * INFO  11:42:09,152 Executing startup routine [8 of 13, runlevel 1]:
> > $Proxy34 (DefaultStartupRoutineExecutor.java [main])
> > * INFO  11:42:09,166 Executing startup routine [9 of 13, runlevel 1]:
> > $Proxy34 (DefaultStartupRoutineExecutor.java [main])
> > * INFO  11:42:09,167 Removing datasetid column from dataentryform
> > table (DataEntryFormPopulator.java [main])
> > * INFO  11:42:09,286 Executing startup routine [10 of 13, runlevel 2]:
> > $Proxy34 (DefaultStartupRoutineExecutor.java [main])
> > * INFO  11:42:09,338 Added default dataelement dimension
> > (DataElementDefaultDimensionPopulator.java [main])
> > * WARN  11:42:09,352 SQL Error: 0, SQLState: 23505
> > (JDBCExceptionReporter.java [main])
> > * ERROR 11:42:09,353 Batch entry 0 insert into categoryoptioncombo
> > (categoryoptioncomboid) values ('16') was aborted.  Call
> > getNextException to see the cause. (JDBCExceptionReporter.java [main])
> > * WARN  11:42:09,353 SQL Error: 0, SQLState: 23505
> > (JDBCExceptionReporter.java [main])
> > * ERROR 11:42:09,355 ERROR: duplicate key value violates unique
> > constraint "categoryoptioncombo_pkey" (JDBCExceptionReporter.java
> > [main])
> > * ERROR 11:42:09,358 Could not synchronize database state with session
> > (AbstractFlushingEventListener.java [main])
> > org.hibernate.exception.ConstraintViolationException: Could not
> > execute JDBC batch update
> >        at
> org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71)
> >        at
> org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
> >        at
> org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:253)
> >        at
> org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:92)
> >        at
> org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:87)
> >        at
> org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2237)
> >        at
> org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2665)
> >        at
> org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:60)
> >        at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279)
> >        at
> org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:263)
> >        at
> org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:167)
> >        at
> org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
> >        at
> org.hibernate.event.def.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:41)
> >        at
> org.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:969)
> >        at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1562)
> >        at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:283)
> >        at
> org.hibernate.impl.CriteriaImpl.uniqueResult(CriteriaImpl.java:305)
> >        at
> org.hisp.dhis.hibernate.HibernateGenericStore.getObject(HibernateGenericStore.java:125)
> >        at
> org.hisp.dhis.hibernate.HibernateGenericStore.getByName(HibernateGenericStore.java:178)
> >        at
> org.hisp.dhis.dataelement.DefaultDataElementCategoryService.getDataElementCategoryComboByName(DefaultDataElementCategoryService.java:243)
> >        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> >        at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> >        at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> >        at java.lang.reflect.Method.invoke(Method.java:597)
> >        at
> org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
> >        at
> org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
> >        at
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
> >        at
> org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
> >        at
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
> >        at
> org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
> >        at
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
> >        at
> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
> >        at $Proxy15.getDataElementCategoryComboByName(Unknown Source)
> >        at
> org.hisp.dhis.dataelement.DataElementDefaultDimensionPopulator.execute(DataElementDefaultDimensionPopulator.java:90)
> >        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> >        at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> >        at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> >        at java.lang.reflect.Method.invoke(Method.java:597)
> >        at
> org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
> >        at
> org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
> >        at
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
> >        at
> org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
> >        at
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
> >        at
> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
> >        at $Proxy34.execute(Unknown Source)
> >        at
> org.hisp.dhis.system.startup.DefaultStartupRoutineExecutor.execute(DefaultStartupRoutineExecutor.java:101)
> >        at
> org.hisp.dhis.system.startup.DefaultStartupRoutineExecutor.execute(DefaultStartupRoutineExecutor.java:77)
> >        at
> org.hisp.dhis.system.startup.StartupListener.contextInitialized(StartupListener.java:57)
> >        at
> org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3972)
> >        at
> org.apache.catalina.core.StandardContext.start(StandardContext.java:4467)
> >        at
> org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
> >        at
> org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
> >        at
> org.apache.catalina.core.StandardHost.addChild(StandardHost.java:546)
> >        at
> org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:905)
> >        at
> org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:740)
> >        at
> org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:500)
> >        at
> org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277)
> >        at
> org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:321)
> >        at
> org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
> >        at
> org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
> >        at
> org.apache.catalina.core.StandardHost.start(StandardHost.java:785)
> >        at
> org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
> >        at
> org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
> >        at
> org.apache.catalina.core.StandardService.start(StandardService.java:519)
> >        at
> org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
> >        at org.apache.catalina.startup.Catalina.start(Catalina.java:581)
> >        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> >        at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> >        at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> >        at java.lang.reflect.Method.invoke(Method.java:597)
> >        at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
> >        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
> > Caused by: java.sql.BatchUpdateException: Batch entry 0 insert into
> > categoryoptioncombo (categoryoptioncomboid) values ('16') was aborted.
> >  Call getNextException to see the cause.
> >        at
> org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2569)
> >        at
> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1796)
> >        at
> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:407)
> >        at
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2708)
> >        at
> com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723)
> >        at
> org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
> >        at
> org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:246)
> >        ... 69 more
> > May 3, 2010 11:42:09 AM org.apache.catalina.core.StandardContext start
> > SEVERE: Error listenerStart
> > May 3, 2010 11:42:09 AM org.apache.catalina.core.StandardContext start
> > SEVERE: Context [/dhis] startup failed due to previous errors
> > May 3, 2010 11:42:10 AM org.apache.catalina.loader.WebappClassLoader
> > clearReferencesJdbc
> > SEVERE: A web application registered the JBDC driver [org.h2.Driver]
> > but failed to unregister it when the web application was stopped. To
> > prevent a memory leak, the JDBC Driver has been forcibly unregistered.
> > May 3, 2010 11:42:10 AM org.apache.catalina.loader.WebappClassLoader
> > clearReferencesJdbc
> > SEVERE: A web application registered the JBDC driver
> > [com.mysql.jdbc.Driver] but failed to unregister it when the web
> > application was stopped. To prevent a memory leak, the JDBC Driver has
> > been forcibly unregistered.
> > May 3, 2010 11:42:10 AM org.apache.catalina.loader.WebappClassLoader
> > clearReferencesJdbc
> > SEVERE: A web application registered the JBDC driver
> > [org.postgresql.Driver] but failed to unregister it when the web
> > application was stopped. To prevent a memory leak, the JDBC Driver has
> > been forcibly unregistered.
> > No protocol specified
> > May 3, 2010 11:42:10 AM org.apache.catalina.startup.HostConfig
> deployDirectory
> > INFO: Deploying web application directory examples
> > May 3, 2010 11:42:11 AM org.apache.catalina.startup.HostConfig
> deployDirectory
> > INFO: Deploying web application directory ROOT
> > May 3, 2010 11:42:11 AM org.apache.catalina.startup.HostConfig
> deployDirectory
> > INFO: Deploying web application directory docs
> > May 3, 2010 11:42:11 AM org.apache.coyote.http11.Http11AprProtocol start
> > INFO: Starting Coyote HTTP/1.1 on http-8080
> > May 3, 2010 11:42:11 AM org.apache.coyote.ajp.AjpAprProtocol start
> > INFO: Starting Coyote AJP/1.3 on ajp-8009
> > May 3, 2010 11:42:11 AM org.apache.catalina.startup.Catalina start
> > INFO: Server startup in 31159 ms
> >
> >
> > Regards,
> > Jason
> >
> >
> > ---
> > Jason P. Pickering
> > email: jason.p.pickering@xxxxxxxxx
> > tel:+260968395190
> >
>
>
>
> --
> --
> Jason P. Pickering
> email: jason.p.pickering@xxxxxxxxx
> tel:+260968395190
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-devs<https://launchpad.net/%7Edhis2-devs>
> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs<https://launchpad.net/%7Edhis2-devs>
> More help   : https://help.launchpad.net/ListHelp
>