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
