dhis2-devs team mailing list archive

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

Public bug reported:

Perhaps this is a lack of understanding how this particular module works, but two issues. It would seem that targets are yearly? Is this correct. Not a big deal I think, but it would be nice to be able to choose the period type (e.g. Financial Year)
Looks like the periodid  I selected (2011) did not get inserted. 

Here is the bug anyway..
Caused by: java.sql.BatchUpdateException: Batch entry 0 insert into detargetdata
value (value, storedby, lastupdated, detargetid, dataelementid, categoryoptionco
mboid, sourceid, periodid) values ('56', 'admin', '2011-02-26 +02:00:00', '11192
', '11059', '10966', '2513', NULL) was aborted.  Call getNextException to see th
e cause.
        at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handle
Error(AbstractJdbc2Statement.java:2598)
        at org.postgresql.core.v3.QueryExecutorImpl$1.handleError(QueryExecutorI
mpl.java:459)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutor
Impl.java:1836)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.ja
va:407)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc
2Statement.java:2737)
        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewPr
oxyPreparedStatement.java:1723)
        at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.jav
a:70)
        at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:
268)
        ... 90 more
null

** Affects: dhis2
     Importance: Undecided
         Status: New

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

Title:
  data-element-target-cannot-insert-target

Status in DHIS 2 - District Health Information Software:
  New

Bug description:
  Perhaps this is a lack of understanding how this particular module works, but two issues. It would seem that targets are yearly? Is this correct. Not a big deal I think, but it would be nice to be able to choose the period type (e.g. Financial Year)
  Looks like the periodid  I selected (2011) did not get inserted. 

  Here is the bug anyway..
  Caused by: java.sql.BatchUpdateException: Batch entry 0 insert into detargetdata
  value (value, storedby, lastupdated, detargetid, dataelementid, categoryoptionco
  mboid, sourceid, periodid) values ('56', 'admin', '2011-02-26 +02:00:00', '11192
  ', '11059', '10966', '2513', NULL) was aborted.  Call getNextException to see th
  e cause.
          at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handle
  Error(AbstractJdbc2Statement.java:2598)
          at org.postgresql.core.v3.QueryExecutorImpl$1.handleError(QueryExecutorI
  mpl.java:459)
          at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutor
  Impl.java:1836)
          at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.ja
  va:407)
          at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc
  2Statement.java:2737)
          at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewPr
  oxyPreparedStatement.java:1723)
          at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.jav
  a:70)
          at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:
  268)
          ... 90 more
  null