dhis2-users team mailing list archive

[Marko David Garcia <markodavidgm@xxxxxxxxx>]

Thanks for your answers.

This is the tomcat log:

* INFO  2015-02-27 12:09:05,390 Time: 1737988 micros: Tracked entity
instance qu
ery SQL: select tei.uid as instance, tei.created as created,
tei.lastupdated as
lastupdated, ou.uid as ou, te.uid as te, "eax4yJM6RvI".value as
"eax4yJM6RvI", "
ei9KJWCIVV6".value as "ei9KJWCIVV6", "hsqeqonqKxm".value as "hsqeqonqKxm",
"DbDO
GyMz2H8".value as "DbDOGyMz2H8" from trackedentityinstance tei inner join
tracke
dentity te on tei.trackedentityid = te.trackedentityid inner join
organisationun
it ou on tei.organisationunitid = ou.organisationunitid left join
trackedentitya
ttributevalue as "eax4yJM6RvI" on "eax4yJM6RvI".trackedentityinstanceid =
tei.tr
ackedentityinstanceid and "eax4yJM6RvI".trackedentityattributeid = 74099
left jo
in trackedentityattributevalue as "ei9KJWCIVV6" on
"ei9KJWCIVV6".trackedentityin
stanceid = tei.trackedentityinstanceid and
"ei9KJWCIVV6".trackedentityattributei
d = 83080 left join trackedentityattributevalue as "hsqeqonqKxm" on
"hsqeqonqKxm
".trackedentityinstanceid = tei.trackedentityinstanceid and
"hsqeqonqKxm".tracke
dentityattributeid = 74153 left join trackedentityattributevalue as
"DbDOGyMz2H8
" on "DbDOGyMz2H8".trackedentityinstanceid = tei.trackedentityinstanceid
and "Db
DOGyMz2H8".trackedentityattributeid = 74097 where tei.organisationunitid in
(73)
 and exists (select pi.trackedentityinstanceid from programinstance pi
where pi.
trackedentityinstanceid = tei.trackedentityinstanceid and pi.programid =
83981 )
 limit 50 offset 0 (Timer.java [http-apr-8080-exec-4])
* INFO  2015-02-27 12:09:07,328 Time: 1924658 micros: Tracked entity
instance co
unt SQL: select count(tei.uid) as instance from trackedentityinstance tei
inner
join trackedentity te on tei.trackedentityid = te.trackedentityid inner
join org
anisationunit ou on tei.organisationunitid = ou.organisationunitid left
join tra
ckedentityattributevalue as "eax4yJM6RvI" on
"eax4yJM6RvI".trackedentityinstance
id = tei.trackedentityinstanceid and "eax4yJM6RvI".trackedentityattributeid
= 74
099 left join trackedentityattributevalue as "ei9KJWCIVV6" on
"ei9KJWCIVV6".trac
kedentityinstanceid = tei.trackedentityinstanceid and
"ei9KJWCIVV6".trackedentit
yattributeid = 83080 left join trackedentityattributevalue as "hsqeqonqKxm"
on "
hsqeqonqKxm".trackedentityinstanceid = tei.trackedentityinstanceid and
"hsqeqonq
Kxm".trackedentityattributeid = 74153 left join trackedentityattributevalue
as "
DbDOGyMz2H8" on "DbDOGyMz2H8".trackedentityinstanceid =
tei.trackedentityinstanc
eid and "DbDOGyMz2H8".trackedentityattributeid = 74097 where
tei.organisationuni
tid in (73) and exists (select pi.trackedentityinstanceid from
programinstance p
i where pi.trackedentityinstanceid = tei.trackedentityinstanceid and
pi.programi
d = 83981 )  (Timer.java [http-apr-8080-exec-4])
* INFO  2015-02-27 12:13:38,234 'mgarcia' update
org.hisp.dhis.program.ProgramSt
age, name: Formato de Tutelas, uid: E7NfRfjBOrW (AuditLogUtil.java
[http-apr-808
0-exec-4])
* INFO  2015-02-27 12:14:07,171 'mgarcia' update
org.hisp.dhis.program.ProgramSt
ageSection, name: General, uid: TQsiWPi4o2s (AuditLogUtil.java
[http-apr-8080-ex
ec-9])
* INFO  2015-02-27 12:15:09,031 Time: 141921 micros: Tracked entity
instance que
ry SQL: select tei.uid as instance, tei.created as created, tei.lastupdated
as l
astupdated, ou.uid as ou, te.uid as te, "eax4yJM6RvI".value as
"eax4yJM6RvI", "e
i9KJWCIVV6".value as "ei9KJWCIVV6", "hsqeqonqKxm".value as "hsqeqonqKxm",
"DbDOG
yMz2H8".value as "DbDOGyMz2H8" from trackedentityinstance tei inner join
tracked
entity te on tei.trackedentityid = te.trackedentityid inner join
organisationuni
t ou on tei.organisationunitid = ou.organisationunitid left join
trackedentityat
tributevalue as "eax4yJM6RvI" on "eax4yJM6RvI".trackedentityinstanceid =
tei.tra
ckedentityinstanceid and "eax4yJM6RvI".trackedentityattributeid = 74099
left joi
n trackedentityattributevalue as "ei9KJWCIVV6" on
"ei9KJWCIVV6".trackedentityins
tanceid = tei.trackedentityinstanceid and
"ei9KJWCIVV6".trackedentityattributeid
 = 83080 left join trackedentityattributevalue as "hsqeqonqKxm" on
"hsqeqonqKxm"
.trackedentityinstanceid = tei.trackedentityinstanceid and
"hsqeqonqKxm".tracked
entityattributeid = 74153 left join trackedentityattributevalue as
"DbDOGyMz2H8"
 on "DbDOGyMz2H8".trackedentityinstanceid = tei.trackedentityinstanceid and
"DbD
OGyMz2H8".trackedentityattributeid = 74097 where tei.organisationunitid in
(74)
and exists (select pi.trackedentityinstanceid from programinstance pi where
pi.t
rackedentityinstanceid = tei.trackedentityinstanceid and pi.programid =
83981 )
limit 50 offset 0 (Timer.java [http-apr-8080-exec-5])
* INFO  2015-02-27 12:15:09,046 Time: 16891 micros: Tracked entity instance
coun
t SQL: select count(tei.uid) as instance from trackedentityinstance tei
inner jo
in trackedentity te on tei.trackedentityid = te.trackedentityid inner join
organ
isationunit ou on tei.organisationunitid = ou.organisationunitid left join
track
edentityattributevalue as "eax4yJM6RvI" on
"eax4yJM6RvI".trackedentityinstanceid
 = tei.trackedentityinstanceid and "eax4yJM6RvI".trackedentityattributeid =
7409
9 left join trackedentityattributevalue as "ei9KJWCIVV6" on
"ei9KJWCIVV6".tracke
dentityinstanceid = tei.trackedentityinstanceid and
"ei9KJWCIVV6".trackedentitya
ttributeid = 83080 left join trackedentityattributevalue as "hsqeqonqKxm"
on "hs
qeqonqKxm".trackedentityinstanceid = tei.trackedentityinstanceid and
"hsqeqonqKx
m".trackedentityattributeid = 74153 left join trackedentityattributevalue
as "Db
DOGyMz2H8" on "DbDOGyMz2H8".trackedentityinstanceid =
tei.trackedentityinstancei
d and "DbDOGyMz2H8".trackedentityattributeid = 74097 where
tei.organisationuniti
d in (74) and exists (select pi.trackedentityinstanceid from
programinstance pi
where pi.trackedentityinstanceid = tei.trackedentityinstanceid and
pi.programid
= 83981 )  (Timer.java [http-apr-8080-exec-5])
* ERROR 2015-02-27 12:15:12,765 Error while executing action
(ExceptionIntercept
or.java [http-apr-8080-exec-7])
java.lang.NullPointerException
        at java.lang.Integer.compareTo(Integer.java:1216)
        at
org.hisp.dhis.program.comparator.ProgramStageDataElementSortOrderComp
arator.compare(ProgramStageDataElementSortOrderComparator.java:46)
        at
org.hisp.dhis.program.comparator.ProgramStageDataElementSortOrderComp
arator.compare(ProgramStageDataElementSortOrderComparator.java:35)
        at java.util.TimSort.gallopLeft(TimSort.java:556)
        at java.util.TimSort.mergeHi(TimSort.java:868)
        at java.util.TimSort.mergeAt(TimSort.java:512)
        at java.util.TimSort.mergeForceCollapse(TimSort.java:453)
        at java.util.TimSort.sort(TimSort.java:250)
        at java.util.Arrays.sort(Arrays.java:1512)
        at java.util.ArrayList.sort(ArrayList.java:1454)
        at java.util.Collections.sort(Collections.java:175)
        at
org.hisp.dhis.caseentry.action.caseentry.LoadDataEntryAction.execute(
LoadDataEntryAction.java:292)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:62)
        at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:483)
        at
com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultA
ctionInvocation.java:450)
        at
com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(Defa
ultActionInvocation.java:289)
        at
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
nvocation.java:252)
        at
org.hisp.dhis.webportal.interceptor.XWorkPortalUserInterceptor.interc
ept(XWorkPortalUserInterceptor.java:88)
        at
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
nvocation.java:246)
        at
org.hisp.dhis.webportal.interceptor.XWorkPortalModuleInterceptor.inte
rcept(XWorkPortalModuleInterceptor.java:89)
        at
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
nvocation.java:246)
        at
org.hisp.dhis.webportal.interceptor.XWorkPortalMenuInterceptor.interc
ept(XWorkPortalMenuInterceptor.java:97)
        at
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
nvocation.java:246)
        at
org.hisp.dhis.webportal.interceptor.XWorkPortalParamsInterceptor.inte
rcept(XWorkPortalParamsInterceptor.java:147)
        at
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
nvocation.java:246)
        at
org.hisp.dhis.interceptor.ContextInterceptor.intercept(ContextInterce
ptor.java:83)
        at
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
nvocation.java:246)
        at
org.hisp.dhis.interceptor.UserSettingInterceptor.intercept(UserSettin
gInterceptor.java:81)
        at
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
nvocation.java:246)
        at
org.hisp.dhis.security.intercept.LoginInterceptor.intercept(LoginInte
rceptor.java:85)
        at
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
nvocation.java:246)
        at
org.hisp.dhis.security.intercept.XWorkSecurityInterceptor.intercept(X
WorkSecurityInterceptor.java:113)
        at
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
nvocation.java:246)
        at
org.hisp.dhis.interceptor.SystemSettingInterceptor.intercept(SystemSe
ttingInterceptor.java:130)
        at
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
nvocation.java:246)
        at
org.hisp.dhis.interceptor.I18nInterceptor.intercept(I18nInterceptor.j
ava:136)
        at
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
nvocation.java:246)
        at
com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept
(ParametersInterceptor.java:254)
        at
com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept
(MethodFilterInterceptor.java:98)
        at
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
nvocation.java:246)
        at
com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.inter
cept(StaticParametersInterceptor.java:191)
        at
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
nvocation.java:246)
        at
org.hisp.dhis.interceptor.ExceptionInterceptor.intercept(ExceptionInt
erceptor.java:110)
        at
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
nvocation.java:246)
        at
org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.j
ava:54)
        at
org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.jav
a:562)
        at
org.apache.struts2.dispatcher.ng.ExecuteOperations.executeAction(Exec
uteOperations.java:77)
        at
org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter
.doFilter(StrutsPrepareAndExecuteFilter.java:99)
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:241)
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:208)
        at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.
doFilter(FilterChainProxy.java:330)
        at
org.springframework.security.web.access.intercept.FilterSecurityInter
ceptor.invoke(FilterSecurityInterceptor.java:118)
        at
org.springframework.security.web.access.intercept.FilterSecurityInter
ceptor.doFilter(FilterSecurityInterceptor.java:84)
        at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.
doFilter(FilterChainProxy.java:342)
        at
org.springframework.security.web.access.ExceptionTranslationFilter.do
Filter(ExceptionTranslationFilter.java:113)
        at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.
doFilter(FilterChainProxy.java:342)
        at
org.springframework.security.web.session.SessionManagementFilter.doFi
lter(SessionManagementFilter.java:103)
        at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.
doFilter(FilterChainProxy.java:342)
        at
org.springframework.security.web.authentication.AnonymousAuthenticati
onFilter.doFilter(AnonymousAuthenticationFilter.java:113)
        at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.
doFilter(FilterChainProxy.java:342)
        at
org.springframework.security.web.servletapi.SecurityContextHolderAwar
eRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:154)
        at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.
doFilter(FilterChainProxy.java:342)
        at
org.springframework.security.web.savedrequest.RequestCacheAwareFilter
.doFilter(RequestCacheAwareFilter.java:45)
        at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.
doFilter(FilterChainProxy.java:342)
        at
org.springframework.security.web.authentication.www.BasicAuthenticati
onFilter.doFilter(BasicAuthenticationFilter.java:150)
        at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.
doFilter(FilterChainProxy.java:342)
        at
org.springframework.security.web.authentication.AbstractAuthenticatio
nProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:199)
        at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.
doFilter(FilterChainProxy.java:342)
        at
org.springframework.security.web.authentication.AbstractAuthenticatio
nProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:199)
        at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.
doFilter(FilterChainProxy.java:342)
        at
org.hisp.dhis.security.filter.CustomAuthenticationFilter.doFilter(Cus
tomAuthenticationFilter.java:64)
        at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.
doFilter(FilterChainProxy.java:342)
        at
org.springframework.security.web.authentication.logout.LogoutFilter.d
oFilter(LogoutFilter.java:110)
        at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.
doFilter(FilterChainProxy.java:342)
        at
org.hisp.dhis.security.filter.AutomaticAccessFilter.doFilter(Automati
cAccessFilter.java:113)
        at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.
doFilter(FilterChainProxy.java:342)
        at
org.springframework.security.web.context.request.async.WebAsyncManage
rIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:50)
        at
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerR
equestFilter.java:106)
        at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.
doFilter(FilterChainProxy.java:342)
        at
org.springframework.security.web.context.SecurityContextPersistenceFi
lter.doFilter(SecurityContextPersistenceFilter.java:87)
        at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.
doFilter(FilterChainProxy.java:342)
        at
org.springframework.security.web.FilterChainProxy.doFilterInternal(Fi
lterChainProxy.java:192)
        at
org.springframework.security.web.FilterChainProxy.doFilter(FilterChai
nProxy.java:160)
        at
org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(D
elegatingFilterProxy.java:343)
        at
org.springframework.web.filter.DelegatingFilterProxy.doFilter(Delegat
ingFilterProxy.java:260)
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:241)
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:208)
        at
org.springframework.orm.hibernate4.support.OpenSessionInViewFilter.do
FilterInternal(OpenSessionInViewFilter.java:151)
        at
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerR
equestFilter.java:106)
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:241)
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:208)
        at
org.springframework.web.filter.CharacterEncodingFilter.doFilterIntern
al(CharacterEncodingFilter.java:88)
        at
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerR
equestFilter.java:106)
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:241)
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:208)
        at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:220)
        at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:122)
        at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authentica
torBase.java:504)
        at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:170)
        at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:103)
        at
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:
950)
        at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:116)
        at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:421)
        at
org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp
11Processor.java:1074)
        at
org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(
AbstractProtocol.java:611)
        at
org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.doRun(AprEndpo
int.java:2466)
        at
org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoin
t.java:2455)
        at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.
java:1142)
        at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor
.java:617)
        at
org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskTh
read.java:61)
        at java.lang.Thread.run(Thread.java:745)


Cordialmente,


*Mag. (c). Marko David Garcia M.*
*Ingeniería Telemática*
*Universidad del Cauca*
*Skype: marko_david*

2015-02-26 22:36 GMT-05:00 Morten Olav Hansen <mortenoh@xxxxxxxxx>:

> Hi Marko
>
> Could you provide us with the full log output? Need to know a bit more
> information..
>
> --
> Morten
>
> On Fri, Feb 27, 2015 at 6:14 AM, Marko David Garcia <
> markodavidgm@xxxxxxxxx> wrote:
>
>> Hello friends.
>>
>> When adding a new data element in an existing program the following error
>> occurs:
>>
>> *"An exception Occurred*
>> *Sorry! The system failed to execute the operation. Usually, no data is
>> lost and you can continue working by going back to the previous page".*
>>
>> The Dhis2 version is: 2.16.
>>
>> Thank you very much.
>>
>>
>>
>>
>> Best regards,
>>
>>
>> *Marko David Garcia M.*
>>
>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>