dhis2-users team mailing list archive

[<duttas@xxxxxxxxxxxx>]

Dear all,

Sorry for all the questions lately. Thank you for your assistance with the program aggregation.

I have built some test data elements and stored some meaningless data values within them. In the user guide I see this warning:
"Simply press the delete button to delete a data element. Note that this operation is only possible if there is no
data attached to the data element itself."

Is there any way to overcome this and delete these elements that I only used for testing purposes? Thanks,

Nick

From: Jason Pickering [mailto:jason.p.pickering@xxxxxxxxx]
Sent: Monday, 17 December 2012 8:00 PM
To: Tran Chau
Cc: Dutta, Mr Shurajit Nicky (SOL); dhis2-users@xxxxxxxxxxxxxxxxxxx; Olav
Subject: Re: [Dhis2-users] Manipulating data entered through program modules

Hi there. Thanks for this. It seems to work now!

Best regards,
Jason


On Mon, Dec 17, 2012 at 9:38 AM, Tran Chau <tran.hispvietnam@xxxxxxxxx<mailto:tran.hispvietnam@xxxxxxxxx>> wrote:
Hi Jason,

If your formulas belong to the anonymous program ( single event without registration ), please use operator as Number of visits and re-test it again.

Thank you.

Best regards,
------------------------------------------------
Châu Thu Trân
HISP Viet Nam
Email: tran.hispvietnam@xxxxxxxxx<mailto:tran.hispvietnam@xxxxxxxxx>


On Mon, Dec 17, 2012 at 12:26 PM, Jason Pickering <jason.p.pickering@xxxxxxxxx<mailto:jason.p.pickering@xxxxxxxxx>> wrote:
I checked the server and saw this error. Not sure how to resolve it however it. The query passes the test, but this happens when trying to aggregate the data manually.

Best regards,
Jason


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. If you wish to report the incident, please save this page by choosing "File -> Save (page as)" in your browser and include the saved page in the report. The problem details are listed below.

[Go back]

[-] Exception (java.lang.IllegalArgumentException): entity for parameter binding cannot be null
·  org.hibernate.internal.AbstractQueryImpl.resolveEntityName(AbstractQueryImpl.java:587)
·  org.hibernate.internal.AbstractQueryImpl.setEntity(AbstractQueryImpl.java:645)
·  org.hisp.dhis.patientdatavalue.hibernate.HibernatePatientDataValueStore.get(HibernatePatientDataValueStore.java:112)
·  org.hisp.dhis.patientdatavalue.DefaultPatientDataValueService.getPatientDataValues(DefaultPatientDataValueService.java:125)
·  sun.reflect.NativeMethodAccessorImpl.invoke0(NativeMethodAccessorImpl.java:-2)
·  sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
·  sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
·  java.lang.reflect.Method.invoke(Method.java:616)
·  org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318)
·  org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
·  org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
·  org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
·  org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
·  org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:90)
·  org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
·  org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
·  $Proxy57.getPatientDataValues(Unknown source)
·  org.hisp.dhis.caseentry.action.caseaggregation.CaseAggregationResultDetailsAction.execute(CaseAggregationResultDetailsAction.java:200)
·  sun.reflect.NativeMethodAccessorImpl.invoke0(NativeMethodAccessorImpl.java:-2)
·  sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
·  sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
·  java.lang.reflect.Method.invoke(Method.java:616)
·  com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:453)
·  com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:292)
·  com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:255)
·  org.hisp.dhis.webportal.interceptor.XWorkPortalUserInterceptor.intercept(XWorkPortalUserInterceptor.java:87)
·  com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)
·  org.hisp.dhis.webportal.interceptor.XWorkPortalModuleInterceptor.intercept(XWorkPortalModuleInterceptor.java:90)
·  com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)
·  org.hisp.dhis.webportal.interceptor.XWorkPortalMenuInterceptor.intercept(XWorkPortalMenuInterceptor.java:96)
·  com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)
·  org.hisp.dhis.webportal.interceptor.XWorkPortalParamsInterceptor.intercept(XWorkPortalParamsInterceptor.java:118)
·  com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)
·  org.hisp.dhis.interceptor.ContextInterceptor.intercept(ContextInterceptor.java:81)
·  com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)
·  org.hisp.dhis.interceptor.UserSettingInterceptor.intercept(UserSettingInterceptor.java:80)
·  com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)
·  org.hisp.dhis.security.intercept.LoginInterceptor.intercept(LoginInterceptor.java:84)
·  com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)
·  org.hisp.dhis.security.intercept.XWorkSecurityInterceptor.intercept(XWorkSecurityInterceptor.java:103)
·  com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)
·  org.hisp.dhis.interceptor.SystemSettingInterceptor.intercept(SystemSettingInterceptor.java:98)
·  com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)
·  org.hisp.dhis.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:137)
·  com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)
·  com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:211)
·  com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
·  com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)
·  com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:190)
·  com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)
·  org.hisp.dhis.interceptor.ExceptionInterceptor.intercept(ExceptionInterceptor.java:100)
·  com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)
·  org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:54)
·  org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:510)
·  org.apache.struts2.dispatcher.FilterDispatcher.doFilter(FilterDispatcher.java:432)
·  org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
·  org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
·  org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:322)
·  org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:116)
·  org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)
·  org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
·  org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)
·  org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
·  org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:103)
·  org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
·  org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113)
·  org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
·  org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54)
·  org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
·  org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45)
·  org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
·  org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:150)
·  org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
·  org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:182)
·  org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
·  org.hisp.dhis.security.filter.CustomAuthenticationFilter.doFilter(CustomAuthenticationFilter.java:54)
·  org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
·  org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105)
·  org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
·  org.hisp.dhis.security.filter.AutomaticAccessFilter.doFilter(AutomaticAccessFilter.java:112)
·  org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
·  org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87)
·  org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
·  org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:184)
·  org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:155)
·  org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)
·  org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259)
·  org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
·  org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
·  org.springframework.orm.hibernate4.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:119)
·  org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
·  org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
·  org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
·  org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
·  org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
·  org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
·  org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
·  org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224)
·  org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169)
·  org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
·  org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
·  org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
·  org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927)
·  org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
·  org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
·  org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:987)
·  org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:579)
·  org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:307)
·  java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
·  java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
·  java.lang.Thread.run(Thread.jav

On Mon, Dec 17, 2012 at 4:37 AM, Tran Chau <tran.hispvietnam@xxxxxxxxx<mailto:tran.hispvietnam@xxxxxxxxx>> wrote:
Hi,

The formula should be: [DE:37948.37949.37952] = 'true' for data element with YES/NO type.

Best regards,
------------------------------------------------
Châu Thu Trân
HISP Viet Nam
Email: tran.hispvietnam@xxxxxxxxx<mailto:tran.hispvietnam@xxxxxxxxx>


On Mon, Dec 17, 2012 at 8:10 AM, <duttas@xxxxxxxxxxxx<mailto:duttas@xxxxxxxxxxxx>> wrote:
[DE:37948.37949.37952] = true


_______________________________________________
Mailing list: https://launchpad.net/~dhis2-users
Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx<mailto:dhis2-users@xxxxxxxxxxxxxxxxxxx>
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp







====================================================
This message was scanned for viruses with Trend Micro ScanMail, GFI MailSecurity and  GFI MailEssentials by the World Health Organization Regional Office for the Western Pacific.  However, the recipient is advised to scan this e-mail and any attached files for viruses.

Disclaimer:

This e-mail, together with any attachments, is intended for the named recipients only and is confidential. It may also be privileged or otherwise protected by law.

If you have received it in error, please notify the sender immediately by reply e-mail and delete it and any attachments from your system. You may not copy or disclose its contents to anyone.