dhis2-users team mailing list archive

[Guy Ekani <constyekani@xxxxxxxx>]

Hi, 
Now dhis received sms, but don't proceed it and return me this SMS in my phone : "DHIS: No user associated with this phone number. Please contact your supervisor". as yous can see in file attached
I think there is another problem with NOT NULL in columns sendate and receiveddate of table incomingsms
Version:2.18Build revision:18136Build date:2015-02-03 05:49Tomcat/PostGreSQL in Windows 7
Sincerely, =========================EKANI Guy 

* INFO  23:24:49,389 Received SMS: POP ho100 fe200 en500 (SmsPublisher.java [Thread-23])

* WARN  23:24:49,415 Cannot get users with disjoint roles as user does not have any user roles (DefaultUserService.java [Thread-23])

* ERROR 23:24:49,416 org.hisp.dhis.sms.parse.SMSParserException: No user associated with this phone number. Please contact your supervisor. (SmsPublisher.java [Thread-23])

* INFO  23:24:49,433 Sending message OutboundSMS [recipients=23769XXXXXX, message=DHIS: No user associated with this phone number. Please contact your supervisor.] (DefaultOutboundSmsTransportService.java [Thread-23])

* ERROR 23:14:15,899 Error while executing action (ExceptionInterceptor.java [4577075@qtp-11297322-12])

org.springframework.dao.DataIntegrityViolationException: could not execute statement; SQL [n/a]; constraint [null]; nested exception is org.hibernate.exception.ConstraintViolationException: could not execute statement


 
$incomingSms.sentDate.toLocaleString()


 
Caused by: org.postgresql.util.PSQLException: ERREUR: une valeur NULL viole la contrainte NOT NULL de la colonne « sentdate »

  Détail : La ligne en échec contient (8528, , 0, null, null, 00 - Succesful Delivery., Huawei, 4, f, imported)

                at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198)

                at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927)

                at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)

                at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:561)

                at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:419)

                at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:365)

                at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)

                at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:133)

                ... 122 more


     Le Mardi 3 février 2015 17h57, Guy Ekani <constyekani@xxxxxxxx> a écrit :
   

 

Thank you Long, i will try it this night ! ========================= EKANI Guy 


  

     Le Mardi 3 février 2015 8h47, Long Ngo Thanh <long.hispvietnam@xxxxxxxxx> a écrit :
   

 Hi Guy,

The bug has been fixed. You can download the latest 2.18 from: https://apps.dhis2.org/ci/job/dhis-2.18/lastSuccessfulBuild/artifact/dhis-2/dhis-web/dhis-web-portal/target/dhis.war
Long
On Mon Feb 02 2015 at 4:36:23 PM Guy Ekani <constyekani@xxxxxxxx> wrote:

Thank u sir, let me show you my configuration :
Gateway Configuration Management
Gateway Type--------------------Type : Modem Gateway

Gateway Configuration-------------------Gateway Name: HuaweiPort *: COM25BaudRate *: 460800 Polling interval in seconds: *: 10Manufacturer: HuaweiModel: E173PIN: 0000Inbound: Yes Outbound: Yes ========================= EKANI Guy 


  

     Le Lundi 2 février 2015 10h26, Long Ngo Thanh <long.hispvietnam@xxxxxxxxx> a écrit :
   

 Hi Guy,

This issue should be fixed long time ago but let me check it from the code.
Long
On Mon Feb 02 2015 at 4:21:36 PM Guy Ekani <constyekani@xxxxxxxx> wrote:

Hello Everyone,
I use a Modem Gateway,
I'm able to send SMS in DHIS, but DHIS don't receive the SMS I sent. I have the following error  when i click on "view received SMS":
Version:
   
      - 2.18
   - Build revision:
      - 18100
   - Build date:
      - 2015-01-22 04:08


HTTP ERROR 404
Problemaccessing /dhis-web-maintenance-mobile/show_receive_sms_form.action. Reason:    There is no Action mapped for namespace [/dhis-web-maintenance-mobile] and action name [show_receive_sms_form] associated with context path [].Powered by Jetty://* INFO  11:20:33,944 [Level: INFO, category: SENDING_SMS,time: Sun Feb 01 11:20:33 WAT 2015, message: Sending SMS](InMemoryNotifier.java [taskScheduler-1])* INFO  11:20:33,959 Sending message OutboundSMS[recipients=237699******, message=admin: tata](DefaultOutboundSmsTransportService.java [taskScheduler-1])* WARN  11:20:33,960 Message not sent(DefaultOutboundSmsTransportService.java [taskScheduler-1])* INFO  11:20:33,991 [Level: INFO, category:SENDING_SMS, time: Sun Feb 01 11:20:33 WAT 2015, message: All Message Sent](InMemoryNotifier.java [taskScheduler-1])
* WARN  10:37:33,928 Unable to load gateway Huawei(DefaultOutboundSmsTransportService.java [22821551@qtp-14938154-32])org.smslib.GatewayException:Cannot add gateways while Service is running!
 ========================= EKANI Guy 



 _______________________________________________
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



 


    
_______________________________________________
Mailing list: https://launchpad.net/~dhis2-users
Post to    : dhis2-users@xxxxxxxxxxxxxxxxxxx
Unsubscribe : https://launchpad.net/~dhis2-users
More help  : https://help.launchpad.net/ListHelp

Attachment: PB_Sms.zip
Description: Binary data