Hi,
Please post submit_sm_resp PDU and its corresponding deliver_sm (DLR).
ts is the forreign (SMSc) message-id. In SMPP it is a unique id. In other
protocols (EMI, CIMD) this is just an actual timestamp, which creates
matching problems when you get a lot of SMS/s. ts was initially used as a
timestamp and when SMPP came with a more accurate spec, it is used as
message-id.
BR,
Nikos
----- Original Message -----
From: hafez ahmad
To: [email protected]
Sent: Thursday, September 30, 2010 4:43 PM
Subject: DLR Problem
Hi All,
I have problem with the DLR that DLR row not found, I use msg-id-type=0X02 ,
but I still have the problem, please note also that this problem not always
happened, sometimes the kannel finds the DLR row in the database.
Also I have note the following the TS field in the DLR table mean reference
to the Manual
field-timestamp = ts
"
field-timestamp (m)stringThe table field that is used for the timestamp data
"
but as we see in the below log:
2010-09-30 16:12:01 [23945] [15] DEBUG: sql: SELECT mask, service, url,
source, destination, boxc FROM dlr WHERE smsc='MYSMPP' AND ts='1657099323';
but the ts here is the message id not the Timestamp , do you have any ideas
about that ?
2010-09-30 16:12:01 [23945] [15] DEBUG: len: 120
2010-09-30 16:12:01 [23945] [15] DEBUG: size: 121
2010-09-30 16:12:01 [23945] [15] DEBUG: immutable: 0
2010-09-30 16:12:01 [23945] [15] DEBUG: data: 69 64 3a 36 32 43 35 35
34 33 42 20 73 75 62 3a id:62C5543B sub:
2010-09-30 16:12:01 [23945] [15] DEBUG: data: 30 30 31 20 64 6c 76 72
64 3a 30 30 31 20 73 75 001 dlvrd:001 su
2010-09-30 16:12:01 [23945] [15] DEBUG: data: 62 6d 69 74 20 64 61 74
65 3a 31 30 30 39 33 30 bmit date:100930
2010-09-30 16:12:01 [23945] [15] DEBUG: data: 31 36 31 32 20 64 6f 6e
65 20 64 61 74 65 3a 31 1612 done date:1
2010-09-30 16:12:01 [23945] [15] DEBUG: data: 30 30 39 33 30 31 36 31
32 20 73 74 61 74 3a 52 009301612 stat:R
2010-09-30 16:12:01 [23945] [15] DEBUG: data: 45 4a 45 43 54 44 20 65
72 72 3a 30 30 30 20 74 EJECTD err:000 t
2010-09-30 16:12:01 [23945] [15] DEBUG: data: 65 78 74 3a 20 20 20 20
20 20 20 20 20 20 20 20 ext:
2010-09-30 16:12:01 [23945] [15] DEBUG: data: 20 20 20 20 20 20 20 20
2010-09-30 16:12:01 [23945] [15] DEBUG: Octet string dump ends.
2010-09-30 16:12:01 [23945] [15] DEBUG: SMPP PDU dump ends.
2010-09-30 16:12:01 [23945] [15] DEBUG: SMPP[MYSMPP] handle_pdu, got DLR
2010-09-30 16:12:01 [23945] [15] DEBUG: DLR[mysql]: Looking for DLR
smsc=MYSMPP, ts=1657099323, dst=9XXXXXXXXXX, type=2
2010-09-30 16:12:01 [23945] [15] DEBUG: sql: SELECT mask, service, url,
source, destination, boxc FROM dlr WHERE smsc='MYSMPP' AND ts='1657099323';
2010-09-30 16:12:01 [23945] [15] DEBUG: no rows found
2010-09-30 16:12:01 [23945] [15] WARNING: DLR[mysql]: DLR from SMSC<MYSMPP>
for DST<9XXXXXXXXXX> not found.
Regards and very thanks
Hafez
