dhis2-devs team mailing list archive

[Lars Helge Øverland <larshelge@xxxxxxxxx>]

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

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

Title:
  long-comments-cause-exception

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

Bug description:
  Steps to reproduce

  1) Open an orgunit to edit it
  2) Paste a large amount of text (> 360 characters) into the comment box
  3) Press save

  [+] Exception (org.springframework.dao.DataIntegrityViolationException): could not update: [org.hisp.dhis.organisationunit.OrganisationUnit#5515]; SQL [update organisationunit set uuid=?, name=?, parentid=?, shortname=?, code=?, openingdate=?, closeddate=?, active=?, comment=?, geoCode=?, featureType=?, coordinates=?, url=?, lastUpdated=?, contactPerson=?, address=?, email=?, phoneNumber=?, hasPatients=? where organisationunitid=?]; nested exception is org.hibernate.exception.DataException: could not update: [org.hisp.dhis.organisationunit.OrganisationUnit#5515]
  [+] Caused by (org.hibernate.exception.DataException): could not update: [org.hisp.dhis.organisationunit.OrganisationUnit#5515]
  [+] Caused by (org.postgresql.util.PSQLException): ERROR: value too long for type character varying(360)