25 Jun 2014 16:46:25,124  WARN JDBCExceptionReporter,http-bio-8080-exec-3:100 - SQL Error: 0, SQLState: S1009
25 Jun 2014 16:46:25,125 ERROR JDBCExceptionReporter,http-bio-8080-exec-3:101 - Cannot convert value '0000-00-00 00:00:00' from column 10 to TIMESTAMP.
25 Jun 2014 16:46:25,127  WARN LoadContexts,http-bio-8080-exec-3:132 - fail-safe cleanup (collections) : org.hibernate.engine.loading.CollectionLoadContext@54128188<rs=org.apache.commons.dbcp.DelegatingResultSet@677f80fe>
25 Jun 2014 16:46:25,132  WARN CollectionLoadContext,http-bio-8080-exec-3:348 - On CollectionLoadContext#cleanup, localLoadingCollectionKeys contained [50] entries
25 Jun 2014 16:46:25,133 ERROR ErrorHelper,http-bio-8080-exec-3:147 - Failed to execute query: {0}.
org.openvpms.component.business.service.archetype.ArchetypeServiceException: Failed to execute query: {0}.
        at org.openvpms.component.business.service.archetype.ArchetypeService.getObjects(ArchetypeService.java:394)
        at sun.reflect.GeneratedMethodAccessor150.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:606)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
        at org.springframework.security.access.intercept.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:67)
        at org.openvpms.component.business.service.security.OpenVPMSMethodSecurityInterceptor.invoke(OpenVPMSMethodSecurityInterceptor.java:50)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
        at com.sun.proxy.$Proxy4.getObjects(Unknown Source)
        at org.openvpms.component.business.service.archetype.rule.ArchetypeRuleService.getObjects(ArchetypeRuleService.java:397)
        at org.openvpms.web.component.im.query.ObjectSetQueryExecutor.query(ObjectSetQueryExecutor.java:45)
        at org.openvpms.web.component.im.query.AbstractArchetypeServiceResultSet.query(AbstractArchetypeServiceResultSet.java:251)
        at org.openvpms.web.component.im.query.AbstractCachingResultSet.query(AbstractCachingResultSet.java:186)
        at org.openvpms.web.component.im.query.AbstractCachingResultSet.get(AbstractCachingResultSet.java:163)
        at org.openvpms.web.component.im.query.AbstractResultSet.getPage(AbstractResultSet.java:89)
        at org.openvpms.web.component.im.query.TableBrowser.hasResults(TableBrowser.java:232)
        at org.openvpms.web.component.im.query.TableBrowser.query(TableBrowser.java:142)
        at org.openvpms.web.component.im.query.AbstractQueryBrowser.onQuery(AbstractQueryBrowser.java:189)
        at org.openvpms.web.component.im.query.AbstractQueryBrowser.access$000(AbstractQueryBrowser.java:39)
        at org.openvpms.web.component.im.query.AbstractQueryBrowser$2.onAction(AbstractQueryBrowser.java:151)
        at org.openvpms.web.echo.event.ActionListener.actionPerformed(ActionListener.java:40)
        at nextapp.echo2.app.button.AbstractButton.fireActionPerformed(AbstractButton.java:135)
        at echopointng.ButtonEx$1.actionPerformed(ButtonEx.java:120)
        at nextapp.echo2.app.button.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:70)
        at echopointng.model.DefaultButtonModelEx.doAction(DefaultButtonModelEx.java:51)
        at echopointng.ButtonEx.processInput(ButtonEx.java:202)
        at nextapp.echo2.app.update.ClientUpdateManager.process(ClientUpdateManager.java:116)
        at nextapp.echo2.app.update.UpdateManager.processClientUpdates(UpdateManager.java:89)
        at nextapp.echo2.webcontainer.ContainerSynchronizeService.renderUpdate(ContainerSynchronizeService.java:471)
        at nextapp.echo2.webrender.service.SynchronizeService.service(SynchronizeService.java:279)
        at nextapp.echo2.webrender.WebRenderServlet.process(WebRenderServlet.java:273)
        at org.openvpms.web.echo.servlet.SpringWebContainerServlet.process(SpringWebContainerServlet.java:174)
        at nextapp.echo2.webrender.WebRenderServlet.doPost(WebRenderServlet.java:189)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:647)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:343)
        at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109)
        at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)
        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:355)
        at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:78)
        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:355)
        at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:187)
        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:355)
        at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:97)
        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:355)
        at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:79)
        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:355)
        at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:149)
        at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:237)
        at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)
        at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
        at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1041)
        at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:603)
        at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
        at java.lang.Thread.run(Thread.java:744)
Caused by: org.openvpms.component.business.dao.im.common.IMObjectDAOException: Failed to execute the query: select customer from org.openvpms.component.business.dao.hibernate.im.party.PartyDO as customer where (customer.archetypeId.shortName = :shortName0 and customer.active = :active0) order by customer.name asc, customer.id asc.
        at org.openvpms.component.business.dao.hibernate.im.IMObjectDAOHibernate.get(IMObjectDAOHibernate.java:303)
        at org.openvpms.component.business.dao.hibernate.im.IMObjectDAOHibernate$DefaultQueryDelegator.get(IMObjectDAOHibernate.java:1195)
        at org.openvpms.component.business.dao.hibernate.im.IMObjectDAOHibernate$DefaultQueryDelegator.getObjects(IMObjectDAOHibernate.java:1178)
        at org.openvpms.component.business.dao.hibernate.im.IMObjectDAOHibernate.getObjects(IMObjectDAOHibernate.java:262)
        at org.openvpms.component.business.service.archetype.ArchetypeService.getObjects(ArchetypeService.java:392)
        ... 70 more
Caused by: org.springframework.dao.TransientDataAccessResourceException: Hibernate operation: could not initialize a collection batch: [org.openvpms.component.business.dao.hibernate.im.entity.EntityDOImpl.sourceEntityRelationships#<274, 168, 3578, 3080, 4515, 21, 3383, 1201, 703, 701, 3143, 700, 3077, 3916, 167, 1308, 294, 1003, 1317, 4901, 708, 3144, 705, 1314, 2537, 1310, 170, 3078, 2544, 704, 2540, 1313, 3145, 4613, 710, 804, 4545, 712, 709, 698, 4001, 711, 4819, 1309, 2532, 23, 4308, 1167, 2268, 4564>]; SQL [select sourceenti0_.source_id as source11_1_, sourceenti0_.entity_relationship_id as entity1_1_, sourceenti0_.entity_relationship_id as entity1_25_0_, sourceenti0_.version as version25_0_, sourceenti0_.linkId as linkId25_0_, sourceenti0_.arch_short_name as arch4_25_0_, sourceenti0_.arch_version as arch5_25_0_, sourceenti0_.name as name25_0_, sourceenti0_.description as descript7_25_0_, sourceenti0_.active_start_time as active8_25_0_, sourceenti0_.active_end_time as active9_25_0_, sourceenti0_.sequence as sequence25_0_, sourceenti0_.source_id as source11_25_0_, sourceenti0_.target_id as target12_25_0_, sourceenti0_.identity_id as identity13_25_0_ from entity_relationships sourceenti0_ where sourceenti0_.source_id in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; Cannot convert value '0000-00-00 00:00:00' from column 10 to TIMESTAMP.; nested exception is java.sql.SQLException: Cannot convert value '0000-00-00 00:00:00' from column 10 to TIMESTAMP.
        at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:107)
        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
        at org.springframework.orm.hibernate3.HibernateAccessor.convertJdbcAccessException(HibernateAccessor.java:424)
        at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:410)
        at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:411)
        at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:339)
        at org.openvpms.component.business.dao.hibernate.im.IMObjectDAOHibernate.execute(IMObjectDAOHibernate.java:1115)
        at org.openvpms.component.business.dao.hibernate.im.IMObjectDAOHibernate.executeQuery(IMObjectDAOHibernate.java:609)
        at org.openvpms.component.business.dao.hibernate.im.IMObjectDAOHibernate.get(IMObjectDAOHibernate.java:299)
        ... 74 more
Caused by: java.sql.SQLException: Cannot convert value '0000-00-00 00:00:00' from column 10 to TIMESTAMP.
        at com.mysql.jdbc.ResultSetRow.getTimestampFast(ResultSetRow.java:1298)
        at com.mysql.jdbc.ByteArrayRow.getTimestampFast(ByteArrayRow.java:124)
        at com.mysql.jdbc.ResultSetImpl.getTimestampInternal(ResultSetImpl.java:6610)
        at com.mysql.jdbc.ResultSetImpl.getTimestamp(ResultSetImpl.java:5928)
        at com.mysql.jdbc.ResultSetImpl.getTimestamp(ResultSetImpl.java:5966)
        at org.apache.commons.dbcp.DelegatingResultSet.getTimestamp(DelegatingResultSet.java:261)
        at org.hibernate.type.TimestampType.get(TimestampType.java:53)
        at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:184)
        at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:173)
        at org.hibernate.type.AbstractType.hydrate(AbstractType.java:105)
        at org.hibernate.persister.entity.AbstractEntityPersister.hydrate(AbstractEntityPersister.java:2114)
        at org.hibernate.loader.Loader.loadFromResultSet(Loader.java:1404)
        at org.hibernate.loader.Loader.instanceNotYetLoaded(Loader.java:1332)
        at org.hibernate.loader.Loader.getRow(Loader.java:1230)
        at org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:603)
        at org.hibernate.loader.Loader.doQuery(Loader.java:724)
        at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259)
        at org.hibernate.loader.Loader.loadCollectionBatch(Loader.java:2057)
        at org.hibernate.loader.collection.BatchingCollectionInitializer.initialize(BatchingCollectionInitializer.java:70)
        at org.hibernate.persister.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:587)
        at org.hibernate.event.def.DefaultInitializeCollectionEventListener.onInitializeCollection(DefaultInitializeCollectionEventListener.java:83)
        at org.hibernate.impl.SessionImpl.initializeCollection(SessionImpl.java:1744)
        at org.hibernate.collection.AbstractPersistentCollection.initialize(AbstractPersistentCollection.java:366)
        at org.hibernate.collection.AbstractPersistentCollection.read(AbstractPersistentCollection.java:108)
        at org.hibernate.collection.AbstractPersistentCollection.readSize(AbstractPersistentCollection.java:131)
        at org.hibernate.collection.PersistentSet.isEmpty(PersistentSet.java:169)
        at org.openvpms.component.business.dao.hibernate.im.common.SetAssembler.assembleObject(SetAssembler.java:161)
        at org.openvpms.component.business.dao.hibernate.im.entity.EntityAssembler.assembleObject(EntityAssembler.java:123)
        at org.openvpms.component.business.dao.hibernate.im.party.PartyAssembler.assembleObject(PartyAssembler.java:77)
        at org.openvpms.component.business.dao.hibernate.im.party.PartyAssembler.assembleObject(PartyAssembler.java:36)
        at org.openvpms.component.business.dao.hibernate.im.common.IMObjectAssembler.assemble(IMObjectAssembler.java:178)
        at org.openvpms.component.business.dao.hibernate.im.common.CompoundAssembler.assemble(CompoundAssembler.java:118)
        at org.openvpms.component.business.dao.hibernate.im.entity.ObjectSetResultCollector.assemble(ObjectSetResultCollector.java:159)
        at org.openvpms.component.business.dao.hibernate.im.entity.ObjectSetResultCollector.collect(ObjectSetResultCollector.java:141)
        at org.openvpms.component.business.dao.hibernate.im.IMObjectDAOHibernate$6.doInHibernate(IMObjectDAOHibernate.java:655)
        at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:406)
        ... 78 more
25 Jun 2014 16:46:25,138 ERROR DialogErrorHandler,http-bio-8080-exec-3:68 - Failed to execute query: {0}.
org.openvpms.component.business.service.archetype.ArchetypeServiceException: Failed to execute query: {0}.
        at org.openvpms.component.business.service.archetype.ArchetypeService.getObjects(ArchetypeService.java:394)
        at sun.reflect.GeneratedMethodAccessor150.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:606)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
        at org.springframework.security.access.intercept.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:67)
        at org.openvpms.component.business.service.security.OpenVPMSMethodSecurityInterceptor.invoke(OpenVPMSMethodSecurityInterceptor.java:50)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
        at com.sun.proxy.$Proxy4.getObjects(Unknown Source)
        at org.openvpms.component.business.service.archetype.rule.ArchetypeRuleService.getObjects(ArchetypeRuleService.java:397)
        at org.openvpms.web.component.im.query.ObjectSetQueryExecutor.query(ObjectSetQueryExecutor.java:45)
        at org.openvpms.web.component.im.query.AbstractArchetypeServiceResultSet.query(AbstractArchetypeServiceResultSet.java:251)
        at org.openvpms.web.component.im.query.AbstractCachingResultSet.query(AbstractCachingResultSet.java:186)
        at org.openvpms.web.component.im.query.AbstractCachingResultSet.get(AbstractCachingResultSet.java:163)
        at org.openvpms.web.component.im.query.AbstractResultSet.getPage(AbstractResultSet.java:89)
        at org.openvpms.web.component.im.query.TableBrowser.hasResults(TableBrowser.java:232)
        at org.openvpms.web.component.im.query.TableBrowser.query(TableBrowser.java:142)
        at org.openvpms.web.component.im.query.AbstractQueryBrowser.onQuery(AbstractQueryBrowser.java:189)
        at org.openvpms.web.component.im.query.AbstractQueryBrowser.access$000(AbstractQueryBrowser.java:39)
        at org.openvpms.web.component.im.query.AbstractQueryBrowser$2.onAction(AbstractQueryBrowser.java:151)
        at org.openvpms.web.echo.event.ActionListener.actionPerformed(ActionListener.java:40)
        at nextapp.echo2.app.button.AbstractButton.fireActionPerformed(AbstractButton.java:135)
        at echopointng.ButtonEx$1.actionPerformed(ButtonEx.java:120)
        at nextapp.echo2.app.button.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:70)
        at echopointng.model.DefaultButtonModelEx.doAction(DefaultButtonModelEx.java:51)
        at echopointng.ButtonEx.processInput(ButtonEx.java:202)
        at nextapp.echo2.app.update.ClientUpdateManager.process(ClientUpdateManager.java:116)
        at nextapp.echo2.app.update.UpdateManager.processClientUpdates(UpdateManager.java:89)
        at nextapp.echo2.webcontainer.ContainerSynchronizeService.renderUpdate(ContainerSynchronizeService.java:471)
        at nextapp.echo2.webrender.service.SynchronizeService.service(SynchronizeService.java:279)
        at nextapp.echo2.webrender.WebRenderServlet.process(WebRenderServlet.java:273)
        at org.openvpms.web.echo.servlet.SpringWebContainerServlet.process(SpringWebContainerServlet.java:174)
        at nextapp.echo2.webrender.WebRenderServlet.doPost(WebRenderServlet.java:189)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:647)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:343)
        at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109)
        at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)
        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:355)
        at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:78)
        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:355)
        at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:187)
        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:355)
        at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:97)
        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:355)
        at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:79)
        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:355)
        at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:149)
        at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:237)
        at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)
        at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
        at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1041)
        at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:603)
        at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
        at java.lang.Thread.run(Thread.java:744)
Caused by: org.openvpms.component.business.dao.im.common.IMObjectDAOException: Failed to execute the query: select customer from org.openvpms.component.business.dao.hibernate.im.party.PartyDO as customer where (customer.archetypeId.shortName = :shortName0 and customer.active = :active0) order by customer.name asc, customer.id asc.
        at org.openvpms.component.business.dao.hibernate.im.IMObjectDAOHibernate.get(IMObjectDAOHibernate.java:303)
        at org.openvpms.component.business.dao.hibernate.im.IMObjectDAOHibernate$DefaultQueryDelegator.get(IMObjectDAOHibernate.java:1195)
        at org.openvpms.component.business.dao.hibernate.im.IMObjectDAOHibernate$DefaultQueryDelegator.getObjects(IMObjectDAOHibernate.java:1178)
        at org.openvpms.component.business.dao.hibernate.im.IMObjectDAOHibernate.getObjects(IMObjectDAOHibernate.java:262)
        at org.openvpms.component.business.service.archetype.ArchetypeService.getObjects(ArchetypeService.java:392)
        ... 70 more
Caused by: org.springframework.dao.TransientDataAccessResourceException: Hibernate operation: could not initialize a collection batch: [org.openvpms.component.business.dao.hibernate.im.entity.EntityDOImpl.sourceEntityRelationships#<274, 168, 3578, 3080, 4515, 21, 3383, 1201, 703, 701, 3143, 700, 3077, 3916, 167, 1308, 294, 1003, 1317, 4901, 708, 3144, 705, 1314, 2537, 1310, 170, 3078, 2544, 704, 2540, 1313, 3145, 4613, 710, 804, 4545, 712, 709, 698, 4001, 711, 4819, 1309, 2532, 23, 4308, 1167, 2268, 4564>]; SQL [select sourceenti0_.source_id as source11_1_, sourceenti0_.entity_relationship_id as entity1_1_, sourceenti0_.entity_relationship_id as entity1_25_0_, sourceenti0_.version as version25_0_, sourceenti0_.linkId as linkId25_0_, sourceenti0_.arch_short_name as arch4_25_0_, sourceenti0_.arch_version as arch5_25_0_, sourceenti0_.name as name25_0_, sourceenti0_.description as descript7_25_0_, sourceenti0_.active_start_time as active8_25_0_, sourceenti0_.active_end_time as active9_25_0_, sourceenti0_.sequence as sequence25_0_, sourceenti0_.source_id as source11_25_0_, sourceenti0_.target_id as target12_25_0_, sourceenti0_.identity_id as identity13_25_0_ from entity_relationships sourceenti0_ where sourceenti0_.source_id in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; Cannot convert value '0000-00-00 00:00:00' from column 10 to TIMESTAMP.; nested exception is java.sql.SQLException: Cannot convert value '0000-00-00 00:00:00' from column 10 to TIMESTAMP.
        at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:107)
        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
        at org.springframework.orm.hibernate3.HibernateAccessor.convertJdbcAccessException(HibernateAccessor.java:424)
        at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:410)
        at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:411)
        at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:339)
        at org.openvpms.component.business.dao.hibernate.im.IMObjectDAOHibernate.execute(IMObjectDAOHibernate.java:1115)
        at org.openvpms.component.business.dao.hibernate.im.IMObjectDAOHibernate.executeQuery(IMObjectDAOHibernate.java:609)
        at org.openvpms.component.business.dao.hibernate.im.IMObjectDAOHibernate.get(IMObjectDAOHibernate.java:299)
        ... 74 more
Caused by: java.sql.SQLException: Cannot convert value '0000-00-00 00:00:00' from column 10 to TIMESTAMP.
        at com.mysql.jdbc.ResultSetRow.getTimestampFast(ResultSetRow.java:1298)
        at com.mysql.jdbc.ByteArrayRow.getTimestampFast(ByteArrayRow.java:124)
        at com.mysql.jdbc.ResultSetImpl.getTimestampInternal(ResultSetImpl.java:6610)
        at com.mysql.jdbc.ResultSetImpl.getTimestamp(ResultSetImpl.java:5928)
        at com.mysql.jdbc.ResultSetImpl.getTimestamp(ResultSetImpl.java:5966)
        at org.apache.commons.dbcp.DelegatingResultSet.getTimestamp(DelegatingResultSet.java:261)
        at org.hibernate.type.TimestampType.get(TimestampType.java:53)
        at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:184)
        at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:173)
        at org.hibernate.type.AbstractType.hydrate(AbstractType.java:105)
        at org.hibernate.persister.entity.AbstractEntityPersister.hydrate(AbstractEntityPersister.java:2114)
        at org.hibernate.loader.Loader.loadFromResultSet(Loader.java:1404)
        at org.hibernate.loader.Loader.instanceNotYetLoaded(Loader.java:1332)
        at org.hibernate.loader.Loader.getRow(Loader.java:1230)
        at org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:603)
        at org.hibernate.loader.Loader.doQuery(Loader.java:724)
        at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259)
        at org.hibernate.loader.Loader.loadCollectionBatch(Loader.java:2057)
        at org.hibernate.loader.collection.BatchingCollectionInitializer.initialize(BatchingCollectionInitializer.java:70)
        at org.hibernate.persister.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:587)
        at org.hibernate.event.def.DefaultInitializeCollectionEventListener.onInitializeCollection(DefaultInitializeCollectionEventListener.java:83)
        at org.hibernate.impl.SessionImpl.initializeCollection(SessionImpl.java:1744)
        at org.hibernate.collection.AbstractPersistentCollection.initialize(AbstractPersistentCollection.java:366)
        at org.hibernate.collection.AbstractPersistentCollection.read(AbstractPersistentCollection.java:108)
        at org.hibernate.collection.AbstractPersistentCollection.readSize(AbstractPersistentCollection.java:131)
        at org.hibernate.collection.PersistentSet.isEmpty(PersistentSet.java:169)
        at org.openvpms.component.business.dao.hibernate.im.common.SetAssembler.assembleObject(SetAssembler.java:161)
        at org.openvpms.component.business.dao.hibernate.im.entity.EntityAssembler.assembleObject(EntityAssembler.java:123)
        at org.openvpms.component.business.dao.hibernate.im.party.PartyAssembler.assembleObject(PartyAssembler.java:77)
        at org.openvpms.component.business.dao.hibernate.im.party.PartyAssembler.assembleObject(PartyAssembler.java:36)
        at org.openvpms.component.business.dao.hibernate.im.common.IMObjectAssembler.assemble(IMObjectAssembler.java:178)
        at org.openvpms.component.business.dao.hibernate.im.common.CompoundAssembler.assemble(CompoundAssembler.java:118)
        at org.openvpms.component.business.dao.hibernate.im.entity.ObjectSetResultCollector.assemble(ObjectSetResultCollector.java:159)
        at org.openvpms.component.business.dao.hibernate.im.entity.ObjectSetResultCollector.collect(ObjectSetResultCollector.java:141)
        at org.openvpms.component.business.dao.hibernate.im.IMObjectDAOHibernate$6.doInHibernate(IMObjectDAOHibernate.java:655)
        at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:406)
        ... 78 more
25 Jun 2014 16:46:25,302  WARN JDBCExceptionReporter,http-bio-8080-exec-3:100 - SQL Error: 0, SQLState: S1009
25 Jun 2014 16:46:25,303 ERROR JDBCExceptionReporter,http-bio-8080-exec-3:101 - Cannot convert value '0000-00-00 00:00:00' from column 10 to TIMESTAMP.
25 Jun 2014 16:46:25,305  WARN LoadContexts,http-bio-8080-exec-3:132 - fail-safe cleanup (collections) : org.hibernate.engine.loading.CollectionLoadContext@7da623d1<rs=org.apache.commons.dbcp.DelegatingResultSet@4781e378>
25 Jun 2014 16:46:25,306  WARN CollectionLoadContext,http-bio-8080-exec-3:348 - On CollectionLoadContext#cleanup, localLoadingCollectionKeys contained [50] entries
25 Jun 2014 16:46:25,307 ERROR ErrorHelper,http-bio-8080-exec-3:147 - Failed to execute query: {0}.
org.openvpms.component.business.service.archetype.ArchetypeServiceException: Failed to execute query: {0}.
        at org.openvpms.component.business.service.archetype.ArchetypeService.getObjects(ArchetypeService.java:394)
        at sun.reflect.GeneratedMethodAccessor150.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:606)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
        at org.springframework.security.access.intercept.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:67)
        at org.openvpms.component.business.service.security.OpenVPMSMethodSecurityInterceptor.invoke(OpenVPMSMethodSecurityInterceptor.java:50)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
        at com.sun.proxy.$Proxy4.getObjects(Unknown Source)
        at org.openvpms.component.business.service.archetype.rule.ArchetypeRuleService.getObjects(ArchetypeRuleService.java:397)
        at org.openvpms.web.component.im.query.ObjectSetQueryExecutor.query(ObjectSetQueryExecutor.java:45)
        at org.openvpms.web.component.im.query.AbstractArchetypeServiceResultSet.query(AbstractArchetypeServiceResultSet.java:251)
        at org.openvpms.web.component.im.query.AbstractCachingResultSet.query(AbstractCachingResultSet.java:186)
        at org.openvpms.web.component.im.query.AbstractCachingResultSet.get(AbstractCachingResultSet.java:163)
        at org.openvpms.web.component.im.query.AbstractResultSet.getPage(AbstractResultSet.java:89)
        at org.openvpms.web.component.im.table.PagedIMTableModel.setPage(PagedIMTableModel.java:144)
        at org.openvpms.web.component.im.table.PagedIMTableModel.setResultSet(PagedIMTableModel.java:109)
        at org.openvpms.web.component.im.table.PagedIMTable.setResultSet(PagedIMTable.java:88)
        at org.openvpms.web.component.im.query.TableBrowser.query(TableBrowser.java:149)
        at org.openvpms.web.component.im.query.AbstractQueryBrowser.onQuery(AbstractQueryBrowser.java:189)
        at org.openvpms.web.component.im.query.AbstractQueryBrowser.access$000(AbstractQueryBrowser.java:39)
        at org.openvpms.web.component.im.query.AbstractQueryBrowser$2.onAction(AbstractQueryBrowser.java:151)
        at org.openvpms.web.echo.event.ActionListener.actionPerformed(ActionListener.java:40)
        at nextapp.echo2.app.button.AbstractButton.fireActionPerformed(AbstractButton.java:135)
        at echopointng.ButtonEx$1.actionPerformed(ButtonEx.java:120)
        at nextapp.echo2.app.button.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:70)
        at echopointng.model.DefaultButtonModelEx.doAction(DefaultButtonModelEx.java:51)
        at echopointng.ButtonEx.processInput(ButtonEx.java:202)
        at nextapp.echo2.app.update.ClientUpdateManager.process(ClientUpdateManager.java:116)
        at nextapp.echo2.app.update.UpdateManager.processClientUpdates(UpdateManager.java:89)
        at nextapp.echo2.webcontainer.ContainerSynchronizeService.renderUpdate(ContainerSynchronizeService.java:471)
        at nextapp.echo2.webrender.service.SynchronizeService.service(SynchronizeService.java:279)
        at nextapp.echo2.webrender.WebRenderServlet.process(WebRenderServlet.java:273)
        at org.openvpms.web.echo.servlet.SpringWebContainerServlet.process(SpringWebContainerServlet.java:174)
        at nextapp.echo2.webrender.WebRenderServlet.doPost(WebRenderServlet.java:189)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:647)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:343)
        at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109)
        at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)
        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:355)
        at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:78)
        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:355)
        at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:187)
        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:355)
        at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:97)
        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:355)
        at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:79)
        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:355)
        at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:149)
        at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:237)
        at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)
        at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
        at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1041)
        at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:603)
        at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
        at java.lang.Thread.run(Thread.java:744)
Caused by: org.openvpms.component.business.dao.im.common.IMObjectDAOException: Failed to execute the query: select customer from org.openvpms.component.business.dao.hibernate.im.party.PartyDO as customer where (customer.archetypeId.shortName = :shortName0 and customer.active = :active0) order by customer.name asc, customer.id asc.
        at org.openvpms.component.business.dao.hibernate.im.IMObjectDAOHibernate.get(IMObjectDAOHibernate.java:303)
        at org.openvpms.component.business.dao.hibernate.im.IMObjectDAOHibernate$DefaultQueryDelegator.get(IMObjectDAOHibernate.java:1195)
        at org.openvpms.component.business.dao.hibernate.im.IMObjectDAOHibernate$DefaultQueryDelegator.getObjects(IMObjectDAOHibernate.java:1178)
        at org.openvpms.component.business.dao.hibernate.im.IMObjectDAOHibernate.getObjects(IMObjectDAOHibernate.java:262)
        at org.openvpms.component.business.service.archetype.ArchetypeService.getObjects(ArchetypeService.java:392)
        ... 72 more
Caused by: org.springframework.dao.TransientDataAccessResourceException: Hibernate operation: could not initialize a collection batch: [org.openvpms.component.business.dao.hibernate.im.entity.EntityDOImpl.sourceEntityRelationships#<274, 1310, 3060, 1317, 4397, 703, 1309, 1003, 1313, 804, 3077, 708, 704, 3884, 2540, 964, 4515, 2539, 3161, 713, 4819, 1315, 173, 2551, 3078, 2544, 3080, 3143, 3144, 3383, 4760, 2542, 4613, 4863, 4813, 4918, 2545, 3916, 3448, 705, 700, 706, 23, 294, 4132, 1167, 2543, 2537, 698, 4545>]; SQL [select sourceenti0_.source_id as source11_1_, sourceenti0_.entity_relationship_id as entity1_1_, sourceenti0_.entity_relationship_id as entity1_25_0_, sourceenti0_.version as version25_0_, sourceenti0_.linkId as linkId25_0_, sourceenti0_.arch_short_name as arch4_25_0_, sourceenti0_.arch_version as arch5_25_0_, sourceenti0_.name as name25_0_, sourceenti0_.description as descript7_25_0_, sourceenti0_.active_start_time as active8_25_0_, sourceenti0_.active_end_time as active9_25_0_, sourceenti0_.sequence as sequence25_0_, sourceenti0_.source_id as source11_25_0_, sourceenti0_.target_id as target12_25_0_, sourceenti0_.identity_id as identity13_25_0_ from entity_relationships sourceenti0_ where sourceenti0_.source_id in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; Cannot convert value '0000-00-00 00:00:00' from column 10 to TIMESTAMP.; nested exception is java.sql.SQLException: Cannot convert value '0000-00-00 00:00:00' from column 10 to TIMESTAMP.
        at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:107)
        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
        at org.springframework.orm.hibernate3.HibernateAccessor.convertJdbcAccessException(HibernateAccessor.java:424)
        at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:410)
        at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:411)
        at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:339)
        at org.openvpms.component.business.dao.hibernate.im.IMObjectDAOHibernate.execute(IMObjectDAOHibernate.java:1115)
        at org.openvpms.component.business.dao.hibernate.im.IMObjectDAOHibernate.executeQuery(IMObjectDAOHibernate.java:609)
        at org.openvpms.component.business.dao.hibernate.im.IMObjectDAOHibernate.get(IMObjectDAOHibernate.java:299)
        ... 76 more
Caused by: java.sql.SQLException: Cannot convert value '0000-00-00 00:00:00' from column 10 to TIMESTAMP.
        at com.mysql.jdbc.ResultSetRow.getTimestampFast(ResultSetRow.java:1298)
        at com.mysql.jdbc.ByteArrayRow.getTimestampFast(ByteArrayRow.java:124)
        at com.mysql.jdbc.ResultSetImpl.getTimestampInternal(ResultSetImpl.java:6610)
        at com.mysql.jdbc.ResultSetImpl.getTimestamp(ResultSetImpl.java:5928)
        at com.mysql.jdbc.ResultSetImpl.getTimestamp(ResultSetImpl.java:5966)
        at org.apache.commons.dbcp.DelegatingResultSet.getTimestamp(DelegatingResultSet.java:261)
        at org.hibernate.type.TimestampType.get(TimestampType.java:53)
        at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:184)
        at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:173)
        at org.hibernate.type.AbstractType.hydrate(AbstractType.java:105)
        at org.hibernate.persister.entity.AbstractEntityPersister.hydrate(AbstractEntityPersister.java:2114)
        at org.hibernate.loader.Loader.loadFromResultSet(Loader.java:1404)
        at org.hibernate.loader.Loader.instanceNotYetLoaded(Loader.java:1332)
        at org.hibernate.loader.Loader.getRow(Loader.java:1230)
        at org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:603)
        at org.hibernate.loader.Loader.doQuery(Loader.java:724)
        at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259)
        at org.hibernate.loader.Loader.loadCollectionBatch(Loader.java:2057)
        at org.hibernate.loader.collection.BatchingCollectionInitializer.initialize(BatchingCollectionInitializer.java:70)
        at org.hibernate.persister.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:587)
        at org.hibernate.event.def.DefaultInitializeCollectionEventListener.onInitializeCollection(DefaultInitializeCollectionEventListener.java:83)
        at org.hibernate.impl.SessionImpl.initializeCollection(SessionImpl.java:1744)
        at org.hibernate.collection.AbstractPersistentCollection.initialize(AbstractPersistentCollection.java:366)
        at org.hibernate.collection.AbstractPersistentCollection.read(AbstractPersistentCollection.java:108)
        at org.hibernate.collection.AbstractPersistentCollection.readSize(AbstractPersistentCollection.java:131)
        at org.hibernate.collection.PersistentSet.isEmpty(PersistentSet.java:169)
        at org.openvpms.component.business.dao.hibernate.im.common.SetAssembler.assembleObject(SetAssembler.java:161)
        at org.openvpms.component.business.dao.hibernate.im.entity.EntityAssembler.assembleObject(EntityAssembler.java:123)
        at org.openvpms.component.business.dao.hibernate.im.party.PartyAssembler.assembleObject(PartyAssembler.java:77)
        at org.openvpms.component.business.dao.hibernate.im.party.PartyAssembler.assembleObject(PartyAssembler.java:36)
        at org.openvpms.component.business.dao.hibernate.im.common.IMObjectAssembler.assemble(IMObjectAssembler.java:178)
        at org.openvpms.component.business.dao.hibernate.im.common.CompoundAssembler.assemble(CompoundAssembler.java:118)
        at org.openvpms.component.business.dao.hibernate.im.entity.ObjectSetResultCollector.assemble(ObjectSetResultCollector.java:159)
        at org.openvpms.component.business.dao.hibernate.im.entity.ObjectSetResultCollector.collect(ObjectSetResultCollector.java:141)
        at org.openvpms.component.business.dao.hibernate.im.IMObjectDAOHibernate$6.doInHibernate(IMObjectDAOHibernate.java:655)
        at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:406)
        ... 80 more
25 Jun 2014 16:46:25,312 ERROR DialogErrorHandler,http-bio-8080-exec-3:68 - Failed to execute query: {0}.
org.openvpms.component.business.service.archetype.ArchetypeServiceException: Failed to execute query: {0}.
        at org.openvpms.component.business.service.archetype.ArchetypeService.getObjects(ArchetypeService.java:394)
        at sun.reflect.GeneratedMethodAccessor150.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:606)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
        at org.springframework.security.access.intercept.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:67)
        at org.openvpms.component.business.service.security.OpenVPMSMethodSecurityInterceptor.invoke(OpenVPMSMethodSecurityInterceptor.java:50)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
        at com.sun.proxy.$Proxy4.getObjects(Unknown Source)
        at org.openvpms.component.business.service.archetype.rule.ArchetypeRuleService.getObjects(ArchetypeRuleService.java:397)
        at org.openvpms.web.component.im.query.ObjectSetQueryExecutor.query(ObjectSetQueryExecutor.java:45)
        at org.openvpms.web.component.im.query.AbstractArchetypeServiceResultSet.query(AbstractArchetypeServiceResultSet.java:251)
        at org.openvpms.web.component.im.query.AbstractCachingResultSet.query(AbstractCachingResultSet.java:186)
        at org.openvpms.web.component.im.query.AbstractCachingResultSet.get(AbstractCachingResultSet.java:163)
        at org.openvpms.web.component.im.query.AbstractResultSet.getPage(AbstractResultSet.java:89)
        at org.openvpms.web.component.im.table.PagedIMTableModel.setPage(PagedIMTableModel.java:144)
        at org.openvpms.web.component.im.table.PagedIMTableModel.setResultSet(PagedIMTableModel.java:109)
        at org.openvpms.web.component.im.table.PagedIMTable.setResultSet(PagedIMTable.java:88)
        at org.openvpms.web.component.im.query.TableBrowser.query(TableBrowser.java:149)
        at org.openvpms.web.component.im.query.AbstractQueryBrowser.onQuery(AbstractQueryBrowser.java:189)
        at org.openvpms.web.component.im.query.AbstractQueryBrowser.access$000(AbstractQueryBrowser.java:39)
        at org.openvpms.web.component.im.query.AbstractQueryBrowser$2.onAction(AbstractQueryBrowser.java:151)
        at org.openvpms.web.echo.event.ActionListener.actionPerformed(ActionListener.java:40)
        at nextapp.echo2.app.button.AbstractButton.fireActionPerformed(AbstractButton.java:135)
        at echopointng.ButtonEx$1.actionPerformed(ButtonEx.java:120)
        at nextapp.echo2.app.button.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:70)
        at echopointng.model.DefaultButtonModelEx.doAction(DefaultButtonModelEx.java:51)
        at echopointng.ButtonEx.processInput(ButtonEx.java:202)
        at nextapp.echo2.app.update.ClientUpdateManager.process(ClientUpdateManager.java:116)
        at nextapp.echo2.app.update.UpdateManager.processClientUpdates(UpdateManager.java:89)
        at nextapp.echo2.webcontainer.ContainerSynchronizeService.renderUpdate(ContainerSynchronizeService.java:471)
        at nextapp.echo2.webrender.service.SynchronizeService.service(SynchronizeService.java:279)
        at nextapp.echo2.webrender.WebRenderServlet.process(WebRenderServlet.java:273)
        at org.openvpms.web.echo.servlet.SpringWebContainerServlet.process(SpringWebContainerServlet.java:174)
        at nextapp.echo2.webrender.WebRenderServlet.doPost(WebRenderServlet.java:189)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:647)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:343)
        at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109)
        at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)
        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:355)
        at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:78)
        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:355)
        at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:187)
        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:355)
        at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:97)
        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:355)
        at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:79)
        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:355)
        at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:149)
        at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:237)
        at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)
        at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
        at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1041)
        at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:603)
        at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
        at java.lang.Thread.run(Thread.java:744)
Caused by: org.openvpms.component.business.dao.im.common.IMObjectDAOException: Failed to execute the query: select customer from org.openvpms.component.business.dao.hibernate.im.party.PartyDO as customer where (customer.archetypeId.shortName = :shortName0 and customer.active = :active0) order by customer.name asc, customer.id asc.
        at org.openvpms.component.business.dao.hibernate.im.IMObjectDAOHibernate.get(IMObjectDAOHibernate.java:303)
        at org.openvpms.component.business.dao.hibernate.im.IMObjectDAOHibernate$DefaultQueryDelegator.get(IMObjectDAOHibernate.java:1195)
        at org.openvpms.component.business.dao.hibernate.im.IMObjectDAOHibernate$DefaultQueryDelegator.getObjects(IMObjectDAOHibernate.java:1178)
        at org.openvpms.component.business.dao.hibernate.im.IMObjectDAOHibernate.getObjects(IMObjectDAOHibernate.java:262)
        at org.openvpms.component.business.service.archetype.ArchetypeService.getObjects(ArchetypeService.java:392)
        ... 72 more
Caused by: org.springframework.dao.TransientDataAccessResourceException: Hibernate operation: could not initialize a collection batch: [org.openvpms.component.business.dao.hibernate.im.entity.EntityDOImpl.sourceEntityRelationships#<274, 1310, 3060, 1317, 4397, 703, 1309, 1003, 1313, 804, 3077, 708, 704, 3884, 2540, 964, 4515, 2539, 3161, 713, 4819, 1315, 173, 2551, 3078, 2544, 3080, 3143, 3144, 3383, 4760, 2542, 4613, 4863, 4813, 4918, 2545, 3916, 3448, 705, 700, 706, 23, 294, 4132, 1167, 2543, 2537, 698, 4545>]; SQL [select sourceenti0_.source_id as source11_1_, sourceenti0_.entity_relationship_id as entity1_1_, sourceenti0_.entity_relationship_id as entity1_25_0_, sourceenti0_.version as version25_0_, sourceenti0_.linkId as linkId25_0_, sourceenti0_.arch_short_name as arch4_25_0_, sourceenti0_.arch_version as arch5_25_0_, sourceenti0_.name as name25_0_, sourceenti0_.description as descript7_25_0_, sourceenti0_.active_start_time as active8_25_0_, sourceenti0_.active_end_time as active9_25_0_, sourceenti0_.sequence as sequence25_0_, sourceenti0_.source_id as source11_25_0_, sourceenti0_.target_id as target12_25_0_, sourceenti0_.identity_id as identity13_25_0_ from entity_relationships sourceenti0_ where sourceenti0_.source_id in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; Cannot convert value '0000-00-00 00:00:00' from column 10 to TIMESTAMP.; nested exception is java.sql.SQLException: Cannot convert value '0000-00-00 00:00:00' from column 10 to TIMESTAMP.
        at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:107)
        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
        at org.springframework.orm.hibernate3.HibernateAccessor.convertJdbcAccessException(HibernateAccessor.java:424)
        at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:410)
        at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:411)
        at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:339)
        at org.openvpms.component.business.dao.hibernate.im.IMObjectDAOHibernate.execute(IMObjectDAOHibernate.java:1115)
        at org.openvpms.component.business.dao.hibernate.im.IMObjectDAOHibernate.executeQuery(IMObjectDAOHibernate.java:609)
        at org.openvpms.component.business.dao.hibernate.im.IMObjectDAOHibernate.get(IMObjectDAOHibernate.java:299)
        ... 76 more
Caused by: java.sql.SQLException: Cannot convert value '0000-00-00 00:00:00' from column 10 to TIMESTAMP.
        at com.mysql.jdbc.ResultSetRow.getTimestampFast(ResultSetRow.java:1298)
        at com.mysql.jdbc.ByteArrayRow.getTimestampFast(ByteArrayRow.java:124)
        at com.mysql.jdbc.ResultSetImpl.getTimestampInternal(ResultSetImpl.java:6610)
        at com.mysql.jdbc.ResultSetImpl.getTimestamp(ResultSetImpl.java:5928)
        at com.mysql.jdbc.ResultSetImpl.getTimestamp(ResultSetImpl.java:5966)
        at org.apache.commons.dbcp.DelegatingResultSet.getTimestamp(DelegatingResultSet.java:261)
        at org.hibernate.type.TimestampType.get(TimestampType.java:53)
        at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:184)
        at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:173)
        at org.hibernate.type.AbstractType.hydrate(AbstractType.java:105)
        at org.hibernate.persister.entity.AbstractEntityPersister.hydrate(AbstractEntityPersister.java:2114)
        at org.hibernate.loader.Loader.loadFromResultSet(Loader.java:1404)
        at org.hibernate.loader.Loader.instanceNotYetLoaded(Loader.java:1332)
        at org.hibernate.loader.Loader.getRow(Loader.java:1230)
        at org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:603)
        at org.hibernate.loader.Loader.doQuery(Loader.java:724)
        at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259)
        at org.hibernate.loader.Loader.loadCollectionBatch(Loader.java:2057)
        at org.hibernate.loader.collection.BatchingCollectionInitializer.initialize(BatchingCollectionInitializer.java:70)
        at org.hibernate.persister.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:587)
        at org.hibernate.event.def.DefaultInitializeCollectionEventListener.onInitializeCollection(DefaultInitializeCollectionEventListener.java:83)
        at org.hibernate.impl.SessionImpl.initializeCollection(SessionImpl.java:1744)
        at org.hibernate.collection.AbstractPersistentCollection.initialize(AbstractPersistentCollection.java:366)
        at org.hibernate.collection.AbstractPersistentCollection.read(AbstractPersistentCollection.java:108)
        at org.hibernate.collection.AbstractPersistentCollection.readSize(AbstractPersistentCollection.java:131)
        at org.hibernate.collection.PersistentSet.isEmpty(PersistentSet.java:169)
        at org.openvpms.component.business.dao.hibernate.im.common.SetAssembler.assembleObject(SetAssembler.java:161)
        at org.openvpms.component.business.dao.hibernate.im.entity.EntityAssembler.assembleObject(EntityAssembler.java:123)
        at org.openvpms.component.business.dao.hibernate.im.party.PartyAssembler.assembleObject(PartyAssembler.java:77)
        at org.openvpms.component.business.dao.hibernate.im.party.PartyAssembler.assembleObject(PartyAssembler.java:36)
        at org.openvpms.component.business.dao.hibernate.im.common.IMObjectAssembler.assemble(IMObjectAssembler.java:178)
        at org.openvpms.component.business.dao.hibernate.im.common.CompoundAssembler.assemble(CompoundAssembler.java:118)
        at org.openvpms.component.business.dao.hibernate.im.entity.ObjectSetResultCollector.assemble(ObjectSetResultCollector.java:159)
        at org.openvpms.component.business.dao.hibernate.im.entity.ObjectSetResultCollector.collect(ObjectSetResultCollector.java:141)
        at org.openvpms.component.business.dao.hibernate.im.IMObjectDAOHibernate$6.doInHibernate(IMObjectDAOHibernate.java:655)
        at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:406)
        ... 80 more
^C