A strange bug

Hi,

We saw this in our Nigeria training. The exception text was sent to the user over SMS!

Any idea on what this could be?

* INFO 2014-02-10 15:34:11,541 Login success for user: 'smsgw', ip: '127.0.0.1' (DefaultUserAuditService.java [tomcat-http-10])
* INFO 2014-02-10 15:34:13,558 Received SMS: STCK s211.n.s213.n.s214.y.s215.n.s516.n.s217.n.s218.n.s219.n.s220.n.s221.n.s222.y.s223.y.s224.y.s225.y.s226.y.s227.y.s228.y.s229.n.s230.y.s231.n.s232.y.s233.y. (SmsPublisher.java [Thread-14])
* INFO 2014-02-10 15:34:13,725 Sending message OutboundSMS [recipients=2347035331647, message=Thank you! Values entered: s209=No s210=Yes s211=No s212=Yes s213=No s214=Yes s215=No s217=No s218=No s219=No s220=No s221=No s222=Yes s223=Yes s224=Yes s225=Yes s226=Yes s227=Yes s228=Yes s229=No s230=Yes s231=No s232=Yes s233=Yes Missing values for: s216] (DefaultOutboundSmsTransportService.java [Thread-14])
* INFO 2014-02-10 15:34:13,726 RequestURL: http://v2nportal.com/sms/gateway/httpsend.php?D=2347035331647&M=Thank+you!+Values+entered%3A+s209%3DNo+s210%3DYes+s211%3DNo+s212%3DYes+s213%3DNo+s214%3DYes+s215%3DNo+s217%3DNo+s218%3DNo+s219%3DNo+s220%3DNo+s221%3DNo+s222%3DYes+s223%3DYes+s224%3DYes+s225%3DYes+s226%3DYes+s227%3DYes+s228%3DYes+s229%3DNo+s230%3DYes+s231%3DNo+s232%3DYes+s233%3DYes+Missing+values+for%3A+s216&T=1&U=HISPN&P=Fri_536!&S=38120 VAS2NETS (SimplisticHttpGetGateWay.java [Thread-14])
* WARN 2014-02-10 15:34:13,799 SQL Error: 0, SQLState: 22001 (SqlExceptionHelper.java [Thread-14])
* ERROR 2014-02-10 15:34:13,799 ERROR: value too long for type character varying(255) (SqlExceptionHelper.java [Thread-14])
* ERROR 2014-02-10 15:34:13,800 org.springframework.dao.DataIntegrityViolationException: could not execute statement; SQL [n/a]; nested exception is org.hibernate.exception.DataException: could not execute statement (SmsPublisher.java [Thread-14])
* INFO 2014-02-10 15:34:13,801 Sending message OutboundSMS [recipients=+2347035331647, message=could not execute statement; SQL [n/a]; nested exception is org.hibernate.exception.DataException: could not execute statement] (DefaultOutboundSmsTransportService.java [Thread-14])
* INFO 2014-02-10 15:34:13,801 RequestURL: http://v2nportal.com/sms/gateway/httpsend.php?D=%2B2347035331647&M=could+not+execute+statement%3B+SQL+[n%2Fa]%3B+nested+exception+is+org.hibernate.exception.DataException%3A+could+not+execute+statement&T=1&U=HISPN&P=Fri_536!&S=38120 VAS2NETS (SimplisticHttpGetGateWay.java [Thread-14])
* INFO 2014-02-10 15:34:13,849 Queue Size: null (SmsPublisher.java [Thread-14])
* INFO 2014-02-10 15:34:58,081 'Tarkaamobile' update org.hisp.dhis.user.User, name: Geoffrey Iortyom, uid: SGPmwxLE5zc (AuditLogUtil.java [tomcat-http-1])
* INFO 2014-02-10 15:34:58,081 'Tarkaamobile' update org.hisp.dhis.user.User, name: Geoffrey Iortyom, uid: SGPmwxLE5zc (AuditLogUtil.java [tomcat-http-1])
andreasn@li700-129:~$ sudo cat /var/lib/dhis2/lmis/logs/catalina.out | grep 15\:34
* INFO 2014-02-10 15:34:11,541 Login success for user: 'smsgw', ip: '127.0.0.1' (DefaultUserAuditService.java [tomcat-http-10])
* INFO 2014-02-10 15:34:13,558 Received SMS: STCK s211.n.s213.n.s214.y.s215.n.s516.n.s217.n.s218.n.s219.n.s220.n.s221.n.s222.y.s223.y.s224.y.s225.y.s226.y.s227.y.s228.y.s229.n.s230.y.s231.n.s232.y.s233.y. (SmsPublisher.java [Thread-14])
* INFO 2014-02-10 15:34:13,725 Sending message OutboundSMS [recipients=2347035331647, message=Thank you! Values entered: s209=No s210=Yes s211=No s212=Yes s213=No s214=Yes s215=No s217=No s218=No s219=No s220=No s221=No s222=Yes s223=Yes s224=Yes s225=Yes s226=Yes s227=Yes s228=Yes s229=No s230=Yes s231=No s232=Yes s233=Yes Missing values for: s216] (DefaultOutboundSmsTransportService.java [Thread-14])
* INFO 2014-02-10 15:34:13,726 RequestURL: http://v2nportal.com/sms/gateway/httpsend.php?D=2347035331647&M=Thank+you!+Values+entered%3A+s209%3DNo+s210%3DYes+s211%3DNo+s212%3DYes+s213%3DNo+s214%3DYes+s215%3DNo+s217%3DNo+s218%3DNo+s219%3DNo+s220%3DNo+s221%3DNo+s222%3DYes+s223%3DYes+s224%3DYes+s225%3DYes+s226%3DYes+s227%3DYes+s228%3DYes+s229%3DNo+s230%3DYes+s231%3DNo+s232%3DYes+s233%3DYes+Missing+values+for%3A+s216&T=1&U=HISPN&P=Fri_536!&S=38120 VAS2NETS (SimplisticHttpGetGateWay.java [Thread-14])
* WARN 2014-02-10 15:34:13,799 SQL Error: 0, SQLState: 22001 (SqlExceptionHelper.java [Thread-14])
* ERROR 2014-02-10 15:34:13,799 ERROR: value too long for type character varying(255) (SqlExceptionHelper.java [Thread-14])
* ERROR 2014-02-10 15:34:13,800 org.springframework.dao.DataIntegrityViolationException: could not execute statement; SQL [n/a]; nested exception is org.hibernate.exception.DataException: could not execute statement (SmsPublisher.java [Thread-14])
* INFO 2014-02-10 15:34:13,801 Sending message OutboundSMS [recipients=+2347035331647, message=could not execute statement; SQL [n/a]; nested exception is org.hibernate.exception.DataException: could not execute statement] (DefaultOutboundSmsTransportService.java [Thread-14])
* INFO 2014-02-10 15:34:13,801 RequestURL: http://v2nportal.com/sms/gateway/httpsend.php?D=%2B2347035331647&M=could+not+execute+statement%3B+SQL+[n%2Fa]%3B+nested+exception+is+org.hibernate.exception.DataException%3A+could+not+execute+statement&T=1&U=HISPN&P=Fri_536!&S=38120 VAS2NETS (SimplisticHttpGetGateWay.java [Thread-14])
* INFO 2014-02-10 15:34:13,849 Queue Size: null (SmsPublisher.java [Thread-14])

Br,

_Andreas_

···

--
Peder Andreas Nergaard, Mobile Coordinator
HISP/DHIS2, Department of Informatics, University of Oslo

p: +47 922 47 500 - s: peder.andreas.nergaard - e: andreasn@ifi.uio.no

Seems like you are trying to save a value longer than 255 characters in a column with max 255 limit.

ERROR: value too long for type character varying(255)

If that is allowed we need to change the OutboundSms.message field to type text.

Lars

···

On Mon, Feb 10, 2014 at 5:04 PM, Peder Andreas Nergaard andreasn@ifi.uio.no wrote:

Hi,

We saw this in our Nigeria training. The exception text was sent to the user over SMS!

Any idea on what this could be?

andreasn@li700-129:~$ sudo cat /var/lib/dhis2/lmis/logs/catalina.out | grep 15:34

Br,

Andreas

Peder Andreas Nergaard, Mobile Coordinator

HISP/DHIS2, Department of Informatics, University of Oslo

http://www.dhis2.org/

p: +47 922 47 500 - s: peder.andreas.nergaard - e: andreasn@ifi.uio.no


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

OK, thanks.

Yes, we are likely to need to send very large text messages.

_Andreas_
···

On 10. feb. 2014 18:02, Lars Helge
Øverland wrote:

    Seems like you are trying to save a value longer

than 255 characters in a column with max 255 limit.

        ERROR:

value too long for type character varying(255)

        If

that is allowed we need to change the OutboundSms.message field to type
text.

Lars

On Mon, Feb 10, 2014 at 5:04 PM, Peder Andreas Nergaard andreasn@ifi.uio.no
wrote:

Hi,

        We saw this in our Nigeria training. The exception text was

sent to the user over SMS!

        Any idea on what this could be?



        * INFO  2014-02-10 15:34:11,541 Login success for user:

‘smsgw’, ip: ‘127.0.0.1’ (DefaultUserAuditService.java
[tomcat-http-10])

        * INFO  2014-02-10 15:34:13,558 Received SMS: STCK

s211.n.s213.n.s214.y.s215.n.s516.n.s217.n.s218.n.s219.n.s220.n.s221.n.s222.y.s223.y.s224.y.s225.y.s226.y.s227.y.s228.y.s229.n.s230.y.s231.n.s232.y.s233.y.
(SmsPublisher.java [Thread-14])

        * INFO  2014-02-10 15:34:13,725 Sending message OutboundSMS

[recipients=2347035331647, message=Thank you! Values
entered: s209=No s210=Yes s211=No s212=Yes s213=No s214=Yes
s215=No s217=No s218=No s219=No s220=No s221=No s222=Yes
s223=Yes s224=Yes s225=Yes s226=Yes s227=Yes s228=Yes
s229=No s230=Yes s231=No s232=Yes s233=Yes Missing values
for: s216] (DefaultOutboundSmsTransportService.java
[Thread-14])

        * INFO  2014-02-10 15:34:13,726 RequestURL: [http://v2nportal.com/sms/gateway/httpsend.php?D=2347035331647&M=Thank+you%21+Values+entered%3A+s209%3DNo+s210%3DYes+s211%3DNo+s212%3DYes+s213%3DNo+s214%3DYes+s215%3DNo+s217%3DNo+s218%3DNo+s219%3DNo+s220%3DNo+s221%3DNo+s222%3DYes+s223%3DYes+s224%3DYes+s225%3DYes+s226%3DYes+s227%3DYes+s228%3DYes+s229%3DNo+s230%3DYes+s231%3DNo+s232%3DYes+s233%3DYes+Missing+values+for%3A+s216&T=1&U=HISPN&P=Fri_536!&S=38120](http://v2nportal.com/sms/gateway/httpsend.php?D=2347035331647&M=Thank+you%21+Values+entered%3A+s209%3DNo+s210%3DYes+s211%3DNo+s212%3DYes+s213%3DNo+s214%3DYes+s215%3DNo+s217%3DNo+s218%3DNo+s219%3DNo+s220%3DNo+s221%3DNo+s222%3DYes+s223%3DYes+s224%3DYes+s225%3DYes+s226%3DYes+s227%3DYes+s228%3DYes+s229%3DNo+s230%3DYes+s231%3DNo+s232%3DYes+s233%3DYes+Missing+values+for%3A+s216&T=1&U=HISPN&P=Fri_536%21&S=38120)
        VAS2NETS (SimplisticHttpGetGateWay.java [Thread-14])

        * WARN  2014-02-10 15:34:13,799 SQL Error: 0, SQLState:

22001 (SqlExceptionHelper.java [Thread-14])

        * ERROR 2014-02-10 15:34:13,799 ERROR: value too long for

type character varying(255) (SqlExceptionHelper.java
[Thread-14])

        * ERROR 2014-02-10 15:34:13,800 org.springframework.dao.DataIntegrityViolationException:

could not execute statement; SQL [n/a]; nested exception is
org.hibernate.exception.DataException: could not execute
statement (SmsPublisher.java [Thread-14])

        * INFO  2014-02-10 15:34:13,801 Sending message OutboundSMS

[recipients=+2347035331647 , message=could not
execute statement; SQL [n/a]; nested exception is
org.hibernate.exception.DataException: could not execute
statement] (DefaultOutboundSmsTransportService.java
[Thread-14])

        * INFO  2014-02-10 15:34:13,801 RequestURL: [http://v2nportal.com/sms/gateway/httpsend.php?D=%2B2347035331647&M=could+not+execute+statement%3B+SQL+%5Bn%2Fa%5D%3B+nested+exception+is+org.hibernate.exception.DataException%3A+could+not+execute+statement&T=1&U=HISPN&P=Fri_536!&S=38120](http://v2nportal.com/sms/gateway/httpsend.php?D=%2B2347035331647&M=could+not+execute+statement%3B+SQL+%5Bn%2Fa%5D%3B+nested+exception+is+org.hibernate.exception.DataException%3A+could+not+execute+statement&T=1&U=HISPN&P=Fri_536%21&S=38120)
        VAS2NETS (SimplisticHttpGetGateWay.java [Thread-14])

        * INFO  2014-02-10 15:34:13,849 Queue Size: null

(SmsPublisher.java [Thread-14])

        * INFO  2014-02-10 15:34:58,081 'Tarkaamobile' update

org.hisp.dhis.user.User, name: Geoffrey Iortyom, uid:
SGPmwxLE5zc (AuditLogUtil.java [tomcat-http-1])

        * INFO  2014-02-10 15:34:58,081 'Tarkaamobile' update

org.hisp.dhis.user.User, name: Geoffrey Iortyom, uid:
SGPmwxLE5zc (AuditLogUtil.java [tomcat-http-1])

        andreasn@li700-129:~$ sudo cat /var/lib/dhis2/lmis/logs/catalina.out

| grep 15:34

        * INFO  2014-02-10 15:34:11,541 Login success for user:

‘smsgw’, ip: ‘127.0.0.1’ (DefaultUserAuditService.java
[tomcat-http-10])

        * INFO  2014-02-10 15:34:13,558 Received SMS: STCK

s211.n.s213.n.s214.y.s215.n.s516.n.s217.n.s218.n.s219.n.s220.n.s221.n.s222.y.s223.y.s224.y.s225.y.s226.y.s227.y.s228.y.s229.n.s230.y.s231.n.s232.y.s233.y.
(SmsPublisher.java [Thread-14])

        * INFO  2014-02-10 15:34:13,725 Sending message OutboundSMS

[recipients=2347035331647, message=Thank you! Values
entered: s209=No s210=Yes s211=No s212=Yes s213=No s214=Yes
s215=No s217=No s218=No s219=No s220=No s221=No s222=Yes
s223=Yes s224=Yes s225=Yes s226=Yes s227=Yes s228=Yes
s229=No s230=Yes s231=No s232=Yes s233=Yes Missing values
for: s216] (DefaultOutboundSmsTransportService.java
[Thread-14])

        * INFO  2014-02-10 15:34:13,726 RequestURL: [http://v2nportal.com/sms/gateway/httpsend.php?D=2347035331647&M=Thank+you%21+Values+entered%3A+s209%3DNo+s210%3DYes+s211%3DNo+s212%3DYes+s213%3DNo+s214%3DYes+s215%3DNo+s217%3DNo+s218%3DNo+s219%3DNo+s220%3DNo+s221%3DNo+s222%3DYes+s223%3DYes+s224%3DYes+s225%3DYes+s226%3DYes+s227%3DYes+s228%3DYes+s229%3DNo+s230%3DYes+s231%3DNo+s232%3DYes+s233%3DYes+Missing+values+for%3A+s216&T=1&U=HISPN&P=Fri_536!&S=38120](http://v2nportal.com/sms/gateway/httpsend.php?D=2347035331647&M=Thank+you%21+Values+entered%3A+s209%3DNo+s210%3DYes+s211%3DNo+s212%3DYes+s213%3DNo+s214%3DYes+s215%3DNo+s217%3DNo+s218%3DNo+s219%3DNo+s220%3DNo+s221%3DNo+s222%3DYes+s223%3DYes+s224%3DYes+s225%3DYes+s226%3DYes+s227%3DYes+s228%3DYes+s229%3DNo+s230%3DYes+s231%3DNo+s232%3DYes+s233%3DYes+Missing+values+for%3A+s216&T=1&U=HISPN&P=Fri_536%21&S=38120)
        VAS2NETS (SimplisticHttpGetGateWay.java [Thread-14])

        * WARN  2014-02-10 15:34:13,799 SQL Error: 0, SQLState:

22001 (SqlExceptionHelper.java [Thread-14])

        * ERROR 2014-02-10 15:34:13,799 ERROR: value too long for

type character varying(255) (SqlExceptionHelper.java
[Thread-14])

        * ERROR 2014-02-10 15:34:13,800 org.springframework.dao.DataIntegrityViolationException:

could not execute statement; SQL [n/a]; nested exception is
org.hibernate.exception.DataException: could not execute
statement (SmsPublisher.java [Thread-14])

        * INFO  2014-02-10 15:34:13,801 Sending message OutboundSMS

[recipients=+2347035331647 , message=could not
execute statement; SQL [n/a]; nested exception is
org.hibernate.exception.DataException: could not execute
statement] (DefaultOutboundSmsTransportService.java
[Thread-14])

        * INFO  2014-02-10 15:34:13,801 RequestURL: [http://v2nportal.com/sms/gateway/httpsend.php?D=%2B2347035331647&M=could+not+execute+statement%3B+SQL+%5Bn%2Fa%5D%3B+nested+exception+is+org.hibernate.exception.DataException%3A+could+not+execute+statement&T=1&U=HISPN&P=Fri_536!&S=38120](http://v2nportal.com/sms/gateway/httpsend.php?D=%2B2347035331647&M=could+not+execute+statement%3B+SQL+%5Bn%2Fa%5D%3B+nested+exception+is+org.hibernate.exception.DataException%3A+could+not+execute+statement&T=1&U=HISPN&P=Fri_536%21&S=38120)
        VAS2NETS (SimplisticHttpGetGateWay.java [Thread-14])

        * INFO  2014-02-10 15:34:13,849 Queue Size: null

(SmsPublisher.java [Thread-14])

        Br,



        _Andreas_



            --

            Peder Andreas Nergaard, Mobile Coordinator

            HISP/DHIS2, Department of Informatics, University of

Oslo

            [http://www.dhis2.org/](http://www.dhis2.org/)

            p: +47 922 47 500 - s:

peder.andreas.nergaard - e: andreasn@ifi.uio.no

            _______________________________________________

            Mailing list: [https://launchpad.net/~dhis2-devs](https://launchpad.net/%7Edhis2-devs)

            Post to     : dhis2-devs@lists.launchpad.net

            Unsubscribe : [https://launchpad.net/~dhis2-devs](https://launchpad.net/%7Edhis2-devs)

            More help   : [https://help.launchpad.net/ListHelp](https://help.launchpad.net/ListHelp)

-- Peder Andreas Nergaard, Mobile Coordinator
HISP/DHIS2, Department of Informatics, University of Oslo
p: +47 922 47 500 - s: peder.andreas.nergaard - e:

http://www.dhis2.org/andreasn@ifi.uio.no