dhis2-devs team mailing list archive
-
dhis2-devs team
-
Mailing list archive
-
Message #35499
Re: [Dhis2-users] SMS not Receiving
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
References