← Back to team overview

dhis2-devs team mailing list archive

Re: Character limit on incoming SMS message

 

Hi Zubair,

Yes that's right, we're running 2.22 here.

Thanks in advance!

- Jasper

On Fri, Nov 4, 2016 at 3:41 PM, Zubair Asghar Raja <zubair@xxxxxxxxx> wrote:

> Hi Jasper,
>
> Yes it is doable.  You are using 2.22 right ?
>
>
> Zubair
>
>
>
>
> On 04. nov. 2016 16:20, Jasper Timm wrote:
>
> Hi DHIS2 Devs,
>
> I'm encountering an error when attempting to send a long incoming SMS
> message to the DHIS2 (v2.22) API - /api/sms/incoming
>
> The message is 809 characters, which the phone, telco and SMS gateway all
> seem to be fine with, presumably via a concatenated SMS, but DHIS2 seems to
> respond with a 500 Internal Server Error.
>
> Looking at the catalina logs, it appears one of the SQL fields is limited
> to a 255 VARCHAR:
>
> * ERROR 2016-11-04 09:24:46,236 ERROR: value too long for type character varying(255) (SqlExceptionHelper.java [http-apr-8080-exec-9])
>
>
> Would it be possible to expand that to something bigger? Say around 2000?
>
> Thanks,
>
> - Jasper
>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>
> --
> Zubair Asghar
> Software Developer, DHIS2
> University of Oslowww.dhis2.org
>
>

References