Hi Thanasis,
I guess ,
Some thing wrong with out table data .
I am sending a row .
Can you plz go through it .
-----------------------------------------------------------------------------
Insert into SMSSERVER_OUT
(ID, TYPE, RECIPIENT, TEXT, WAP_URL,
WAP_EXPIRY_DATE, WAP_SIGNAL, CREATE_DATE, ORIGINATOR, ENCODING,
STATUS_REPORT, FLASH_SMS, SRC_PORT, DST_PORT, SENT_DATE,
REF_NO, PRIORITY, STATUS, ERRORS, GATEWAY_ID)
Values
(92, 'O', '+919811488535', 'HI7', NULL,
NULL, NULL, NULL, NULL, '7',
1, NULL, NULL, NULL, TO_TIMESTAMP('4/16/2009 3:39:18.671000
PM','fmMMfm/fmDDfm/YYYY fmHH12fm:MI:SS.FF AM'),
'208', 1, 'U', NULL, 'modem1');
--------------------------------------------------------------------------------------------
urs,
Vivek
On Fri, Jul 17, 2009 at 9:49 AM, Vivek <[email protected]> wrote:
> Hi Thanasis ,
>
> In errors field is having > 0 value.
> What does it mean ?
> Is there any problem in configurations.
>
>
> urs,
> Vivek
>
>
>
>
> On Thu, Jul 16, 2009 at 10:36 PM, Thanasis <[email protected]> wrote:
>
>>
>> Sorry, I cannot reproduce this.
>>
>> I work with MS Sql Server, and "*" as the gateway in the database -
>> but I don't think it makes any difference.
>> Check your database for correct structure. Also check to see if the
>> "errors" field has any >0 value - this would indicate failed attempts
>> to send the messages.
>>
>> On Jul 16, 1:05 pm, Vivek <[email protected]> wrote:
>> > I done out table data as u mentioned .
>> > Still not yet solved that problem
>> >
>> > urs,
>> > nandu
>> >
>> >
>> >
>> > On Thu, Jul 16, 2009 at 2:42 PM, Vivek <[email protected]> wrote:
>> > > Hi
>> >
>> > > I am sending in table record.
>> >
>> > >
>> ---------------------------------------------------------------------------
>> ---------------
>> > > Insert into SMSSERVER_IN
>> > > (ID, PROCESS, ORIGINATOR, TYPE, ENCODING,
>> > > MESSAGE_DATE, RECEIVE_DATE, TEXT, ORIGINAL_REF_NO,
>> > > ORIGINAL_RECEIVE_DATE,
>> > > GATEWAY_ID)
>> > > Values
>> > > (93, 0, '919811488535', 'I', '7',
>> > > TO_TIMESTAMP('7/16/2009 12:36:45.750000 PM','fmMMfm/fmDDfm/YYYY
>> > > fmHH12fm:MI:SS.FF AM'), TO_TIMESTAMP('4/16/2009 2:34:10.968000
>> > > PM','fmMMfm/fmDDfm/YYYY fmHH12fm:MI:SS.FF AM'), '1', NULL, NULL,
>> > > 'modem1');
>> >
>> > >
>> ---------------------------------------------------------------------------
>> -----------------
>> > > In this table gateway_id stored as modem1.
>> >
>> > > I changed modem1 to SerialModem in out table.
>> > > then also i am having same problem
>> > > urs,
>> > > nandu
>> >
>> > > On Thu, Jul 16, 2009 at 2:22 PM, Thanasis <[email protected]>
>> wrote:
>> >
>> > >> There is a discrepancy here:
>> >
>> > >> In your config file, you name your modem gateway as "SerialModem".
>> >
>> > >> But the row you've created sets the gateway_id field to "modem1".
>> This
>> > >> message will never leave! Set the gateway_id field to "*" or at least
>> > >> to "SerialModem" (in order to match with your gateway).
>> >
>> > >> On Jul 16, 11:45 am, Vivek <[email protected]> wrote:
>> > >> > One row from out table
>> > >> > Insert into SMSSERVER_OUT
>> > >> > (ID, TYPE, RECIPIENT, TEXT, WAP_URL,
>> > >> > WAP_EXPIRY_DATE, WAP_SIGNAL, CREATE_DATE, ORIGINATOR, ENCODING,
>> > >> > STATUS_REPORT, FLASH_SMS, SRC_PORT, DST_PORT, SENT_DATE,
>> > >> > REF_NO, PRIORITY, STATUS, ERRORS, GATEWAY_ID)
>> > >> > Values
>> > >> > (68, 'O', '+919871515064', 'HI', NULL,
>> > >> > NULL, NULL, NULL, NULL, '7',
>> > >> > 1, NULL, NULL, NULL, NULL,
>> > >> > NULL, 1, 'U', 1, 'modem1');
>> >
>> > >> > urs,
>> > >> > Vivek
>> >>
>>
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"SMSLib User Group" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/SMSLib?hl=en
-~----------~----~----~----~------~----~------~--~---
