dhis2-devs team mailing list archive

Thread
Date
Re: Fwd: Dhis 2.0

To: Knut Staring <knutst@xxxxxxxxx>
From: Jason Pickering <jason.p.pickering@xxxxxxxxx>
Date: Tue, 18 Aug 2009 19:16:57 +0200
Cc: DHIS 2 developers <dhis2-devs@xxxxxxxxxxxxxxxxxxx>
In-reply-to: <d7a073540908180300j460da184x33405c4244fbd102@mail.gmail.com>
Hi there. Are you doing an import from the  DHIS 1.4 database, or an
XML file?  Imports from 1.4 are tricky. You need to be sure that there
are no data integrity violations. Additionally, you need to make sure
that there are no values in the RoutineData table greater than 2^31.

You might need to increase the memory available to DHIS by altering
the JAVA_OPTS variable. Depending on your operating system, the
procedure varies but should be described on the Wiki.

Regards,
Jason


On 8/18/09, Knut Staring <knutst@xxxxxxxxx> wrote:
> ---------- Forwarded message ----------
> From: Limpopo EMS Information Management <limpopo.emsinfo@xxxxxxxxx>
> Date: Fri, Aug 14, 2009 at 6:56 PM
> Subject: RE: Dhis 2.0
> To: Knut Staring <knutst@xxxxxxxxx>
>
>
>  When importing data from DHIS 1.4 I get the following error :
>
>
> Exception (java.lang.reflect.InvocationTargetException): null
>
>    - sun.reflect.NativeMethodAccessorImpl.invoke0(Unknown source)
>    - sun.reflect.NativeMethodAccessorImpl.invoke(Unknown source)
>    - sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown source)
>    - java.lang.reflect.Method.invoke(Unknown source)
>    -
>
> com.opensymphony.xwork.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:358)
>    -
>
> com.opensymphony.xwork.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:218)
>    -
>
> com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:192)
>    -
>
> com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
>    -
>
> com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
>    -
>
> com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
>    -
>
> com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
>    -
>
> com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
>    -
>
> com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
>    -
>
> com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
>    -
>
> com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
>    -
>
> com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
>    -
>
> com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
>    -
>
> com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
>    -
>
> com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
>    -
>
> com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
>    -
>
> com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
>    -
>
> org.hisp.dhis.webwork.interceptor.WebWorkDisplayPropertyInterceptor.intercept(WebWorkDisplayPropertyInterceptor.java:90)
>    -
>
> com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
>    -
>
> org.hisp.dhis.webwork.interceptor.WebWorkSortOrderInterceptor.intercept(WebWorkSortOrderInterceptor.java:124)
>    -
>
> com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
>    -
>
> org.hisp.dhis.security.intercept.WebWorkSecurityInterceptor.intercept(WebWorkSecurityInterceptor.java:98)
>    -
>
> com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
>    -
>
> com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
>    -
>
> com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
>    -
>
> com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
>    -
>
> com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
>    -
>
> com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
>    -
>
> com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
>    -
>
> com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
>    -
>
> com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
>    -
>
> org.hisp.dhis.webwork.interceptor.WebWorkExceptionInterceptor.intercept(WebWorkExceptionInterceptor.java:89)
>    -
>
> com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
>    -
>
> com.opensymphony.xwork.DefaultActionProxy.execute(DefaultActionProxy.java:116)
>    -
>
> com.opensymphony.webwork.dispatcher.DispatcherUtils.serviceAction(DispatcherUtils.java:273)
>    -
>
> com.opensymphony.webwork.dispatcher.FilterDispatcher.doFilter(FilterDispatcher.java:202)
>    -
>
> org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1139)
>    -
>
> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:264)
>    -
>
> org.hisp.dhis.security.filter.RequiredLoginFilter.doFilter(RequiredLoginFilter.java:131)
>    -
>
> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
>    -
>
> org.hisp.dhis.security.filter.AutomaticAccessFilter.doFilter(AutomaticAccessFilter.java:107)
>    -
>
> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
>    -
>    org.acegisecurity.ui.logout.LogoutFilter.doFilter(LogoutFilter.java:108)
>    -
>
> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
>    -
>
> org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:217)
>    -
>
> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
>    -
>
> org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:193)
>    -
>
> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
>    -
>
> org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:148)
>    -
>
> org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98)
>    -
>
> org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1139)
>    -
>
> org.hisp.dhis.servlet.filter.OpenSessionInViewFilter.doFilter(OpenSessionInViewFilter.java:71)
>    -
>
> org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236)
>    -
>
> org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)
>    -
>
> org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1139)
>    -
>    org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:378)
>    -
>
> org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
>    -
>    org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)
>    -
>    org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765)
>    - org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:417)
>    -
>
> org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:230)
>    -
>    org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
>    - org.mortbay.jetty.Server.handle(Server.java:324)
>    - org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:535)
>    -
>
> org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:865)
>    - org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:539)
>    - org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:212)
>    - org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)
>    -
>
> org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:409)
>    -
>
> org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:520)
>
> [-] Caused by (java.lang.OutOfMemoryError): Java heap space
>
>    - java.io.BufferedReader.(Unknown source)
>    - java.io.BufferedReader.(Unknown source)
>    - org.h2.util.IOUtils.getReader(IOUtils.java:351)
>    - org.h2.value.ValueLob.getReader(ValueLob.java:633)
>    - org.h2.jdbc.JdbcResultSet.getCharacterStream(JdbcResultSet.java:1198)
>    -
>
> com.mchange.v2.c3p0.impl.NewProxyResultSet.getCharacterStream(NewProxyResultSet.java:623)
>    - org.hibernate.type.TextType.get(TextType.java:29)
>    - org.hibernate.type.NullableType.nullSafeGet(NullableType.java:163)
>    - org.hibernate.type.NullableType.nullSafeGet(NullableType.java:154)
>    - org.hibernate.type.AbstractType.hydrate(AbstractType.java:81)
>    -
>
> org.hibernate.persister.entity.AbstractEntityPersister.hydrate(AbstractEntityPersister.java:2101)
>    - org.hibernate.loader.Loader.loadFromResultSet(Loader.java:1380)
>    - org.hibernate.loader.Loader.instanceNotYetLoaded(Loader.java:1308)
>    - org.hibernate.loader.Loader.getRow(Loader.java:1206)
>    - org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:580)
>    - org.hibernate.loader.Loader.doQuery(Loader.java:701)
>    -
>
> org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
>    - org.hibernate.loader.Loader.doList(Loader.java:2213)
>    - org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
>    - org.hibernate.loader.Loader.list(Loader.java:2099)
>    -
>    org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:94)
>    - org.hibernate.impl.SessionImpl.list(SessionImpl.java:1569)
>    - org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:283)
>    -
>
> org.hisp.dhis.importexport.hibernate.HibernateImportDataValueStore.getImportDataValues(HibernateImportDataValueStore.java:79)
>    - sun.reflect.NativeMethodAccessorImpl.invoke0(Unknown source)
>    - sun.reflect.NativeMethodAccessorImpl.invoke(Unknown source)
>    - sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown source)
>    - java.lang.reflect.Method.invoke(Unknown source)
>    -
>
> org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
>    -
>
> org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
>    -
>
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
>    -
>
> org.hisp.dhis.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:75)
>
> I believe this error was looked at what was the solution for it.
>
>
>
>
>
> Ignac Mare
>
> Information Management
>
> Limpopo Emergency Medical Services
>
> Cell: 082 313 5588 / 083 635 0605
>
> Fax: 086 614 2028
>
> Skype: ignac.mare
>
>
>
>
> __________ Information from ESET Smart Security, version of virus signature
> database 4335 (20090814) __________
>
> The message was checked by ESET Smart Security.
>
> http://www.eset.com
>
>
>
> --
> Cheers,
> Knut Staring
>
References

Re: Dhis 2.0
From: Knut Staring, 2009-08-14
Fwd: Dhis 2.0
From: Knut Staring, 2009-08-18