← Back to team overview

dhis2-devs team mailing list archive

Re: [Bug 746213] [NEW] long-comments-cause-exception

 

Hi I have changed OrganisationUnit.comment field from varchar to text in the
hibernate (database) schema and included this update in the tablealteror
startup routine. Should be okay now.

On Thu, Mar 31, 2011 at 7:01 AM, jason.p.pickering <
746213@xxxxxxxxxxxxxxxxxx> wrote:

> 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
> coordinators, which is the registrant for 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)
>

-- 
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)



References