Character limit on incoming SMS message

Support - Assistance technique
1

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
2

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: Post to : Unsubscribe : More help :

-- Zubair Asghar Software Developer, DHIS2 University of Oslo

https://launchpad.net/~dhis2-devsdhis2-devs@lists.launchpad.nethttps://launchpad.net/~dhis2-devshttps://help.launchpad.net/ListHelpwww.dhis2.org

3

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@dhis2.org 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](https://launchpad.net/~dhis2-devs)
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : [https://launchpad.net/~dhis2-devs](https://launchpad.net/~dhis2-devs)
More help : [https://help.launchpad.net/ListHelp](https://help.launchpad.net/ListHelp)


-- Zubair Asghar Software Developer, DHIS2 University of Oslo [www.dhis2.org](http://www.dhis2.org)