dhis2-devs team mailing list archive
-
dhis2-devs team
-
Mailing list archive
-
Message #11437
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