dhis2-devs team mailing list archive

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

Public bug reported:

If data values have been stored in the database for some reason, like
'' (blanks but not null) , the following error is thrown in the Light
aggregate reporting data entry page.

Caused by: org.postgresql.util.PSQLException: ERROR: invalid input
syntax for type double precision: ""

Upon executing this command on the DB

DELETE * FROM datavalue where value = '';

to remove all of these values, this error is not encountered when trying
to enter data again.

Versions: 2.10 and trunk.

** 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/1102291

Title:
  light-aggregate-data-entry-throws-exception-with-blank-data-values

Status in DHIS 2 - District Health Information Software:
  New

Bug description:
  If data values have been stored in the database for some reason, like
  '' (blanks but not null) , the following error is thrown in the Light
  aggregate reporting data entry page.

  Caused by: org.postgresql.util.PSQLException: ERROR: invalid input
  syntax for type double precision: ""

  Upon executing this command on the DB

  DELETE * FROM datavalue where value = '';

  to remove all of these values, this error is not encountered when
  trying to enter data again.

  Versions: 2.10 and trunk.

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1102291/+subscriptions