dhis2-devs team mailing list archive

["jason.p.pickering" <758768@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

Steps to reproduce.

1) Enter data into a dataset. 
2) Delete the data values. Values are persisted in the datavalue table with null "value" attribute. 
3) Drill down through organisation unit mode in the data browser to reach the raw data of the data you just entered.
4) Data browser throws..
 INFO  15:32:05,414 Lifecycle: server started (TrayApp.java [Thread-3])
 INFO  15:32:25,662 User login success: 'admin' (DefaultUserAuditService.java [
0269696@qtp-13288040-0])
 ERROR 15:32:55,728 Error while executing action (ExceptionInterceptor.java [32
0097@qtp-13288040-2])
ava.lang.RuntimeException: Oops. Somthing else went wrong
       at org.hisp.dhis.databrowser.util.DataBrowserUtils.fillUpDataAdvance(Dat
BrowserUtils.java:197)
       at org.hisp.dhis.databrowser.jdbc.JDBCDataBrowserStore.setRawDataElement
ForOrgUnitBetweenPeriods(JDBCDataBrowserStore.java:310)
       at org.hisp.dhis.databrowser.DefaultDataBrowserGridService.getRawDataEle
entsForOrgUnitInPeriod(DefaultDataBrowserGridService.java:203)
       at org.hisp.dhis.dataadmin.action.databrowser.DataBrowserAction.execute(
ataBrowserAction.java:149)
       at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
       at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
       at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
       at java.lang.reflect.Method.invoke(Unknown Source)
       at com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultA
tionInvocation.java:441)
       at com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(Defa
ltActionInvocation.java:280)
       at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
vocation.java:243)
       at org.hisp.dhis.webportal.interceptor.XWorkPortalUserInterceptor.interc
pt(XWorkPortalUserInterceptor.java:82)
       at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
vocation.java:237)
       at org.hisp.dhis.webportal.interceptor.XWorkPortalModuleInterceptor.inte
cept(XWorkPortalModuleInterceptor.java:85)
       at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
vocation.java:237)
       at org.hisp.dhis.webportal.interceptor.XWorkPortalMenuInterceptor.interc
pt(XWorkPortalMenuInterceptor.java:91)
       at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
vocation.java:237)
       at org.hisp.dhis.webportal.interceptor.XWorkPortalParamsInterceptor.inte
cept(XWorkPortalParamsInterceptor.java:117)
       at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
vocation.java:237)
       at org.hisp.dhis.interceptor.ContextInterceptor.intercept(ContextInterce
tor.java:73)
       at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
vocation.java:237)
       at org.hisp.dhis.interceptor.StyleInterceptor.intercept(StyleInterceptor
java:107)
       at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
vocation.java:237)

** Affects: dhis2
     Importance: Undecided
     Assignee: jason.p.pickering (jason-p-pickering)
         Status: Fix Committed

** Changed in: dhis2
       Status: New => Fix Committed

** Changed in: dhis2
     Assignee: (unassigned) => jason.p.pickering (jason-p-pickering)

-- 
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/758768

Title:
  null-values-datavalue-table-causes-exception-data-browser

Status in DHIS 2 - District Health Information Software:
  Fix Committed

Bug description:
  Steps to reproduce.

  1) Enter data into a dataset. 
  2) Delete the data values. Values are persisted in the datavalue table with null "value" attribute. 
  3) Drill down through organisation unit mode in the data browser to reach the raw data of the data you just entered.
  4) Data browser throws..
   INFO  15:32:05,414 Lifecycle: server started (TrayApp.java [Thread-3])
   INFO  15:32:25,662 User login success: 'admin' (DefaultUserAuditService.java [
  0269696@qtp-13288040-0])
   ERROR 15:32:55,728 Error while executing action (ExceptionInterceptor.java [32
  0097@qtp-13288040-2])
  ava.lang.RuntimeException: Oops. Somthing else went wrong
         at org.hisp.dhis.databrowser.util.DataBrowserUtils.fillUpDataAdvance(Dat
  BrowserUtils.java:197)
         at org.hisp.dhis.databrowser.jdbc.JDBCDataBrowserStore.setRawDataElement
  ForOrgUnitBetweenPeriods(JDBCDataBrowserStore.java:310)
         at org.hisp.dhis.databrowser.DefaultDataBrowserGridService.getRawDataEle
  entsForOrgUnitInPeriod(DefaultDataBrowserGridService.java:203)
         at org.hisp.dhis.dataadmin.action.databrowser.DataBrowserAction.execute(
  ataBrowserAction.java:149)
         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
         at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
         at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
         at java.lang.reflect.Method.invoke(Unknown Source)
         at com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultA
  tionInvocation.java:441)
         at com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(Defa
  ltActionInvocation.java:280)
         at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
  vocation.java:243)
         at org.hisp.dhis.webportal.interceptor.XWorkPortalUserInterceptor.interc
  pt(XWorkPortalUserInterceptor.java:82)
         at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
  vocation.java:237)
         at org.hisp.dhis.webportal.interceptor.XWorkPortalModuleInterceptor.inte
  cept(XWorkPortalModuleInterceptor.java:85)
         at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
  vocation.java:237)
         at org.hisp.dhis.webportal.interceptor.XWorkPortalMenuInterceptor.interc
  pt(XWorkPortalMenuInterceptor.java:91)
         at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
  vocation.java:237)
         at org.hisp.dhis.webportal.interceptor.XWorkPortalParamsInterceptor.inte
  cept(XWorkPortalParamsInterceptor.java:117)
         at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
  vocation.java:237)
         at org.hisp.dhis.interceptor.ContextInterceptor.intercept(ContextInterce
  tor.java:73)
         at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
  vocation.java:237)
         at org.hisp.dhis.interceptor.StyleInterceptor.intercept(StyleInterceptor
  java:107)
         at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
  vocation.java:237)