dhis2-devs team mailing list archive

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

Public bug reported:

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)

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

Title:
  long-comments-cause-exception

Status in DHIS 2 - District Health Information Software:
  New

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)