| View previous topic :: View next topic |
| Author |
Message |
orbit
Joined: 29 Mar 2012
Posts: 4
Location: Bahrain
|
 Posted: Thu Mar 29, 2012 3:22 am Post subject: program halted database error:3061 too few parameters.expect |
 |
|
Hi all,
i am using notepager pro as part of network monitoring and using it to send alerts over the gsm to mobile phones.
it was all working fine and now i am getting this error while trying to send sms "program halted:database error:3061:too few parameters.expected 1.in procedure:sendGSM"
no idea whats wrong but the mesgs trying to send is being shown in send messages but none of them is delivered to phones.
sim card and the modem works fine.
can somebody tell me wats wrong and whats the sol for this.
on the receipients alpha is ticked and tried unchecking it also not use.
its bit critical for me so please help.
thanks
Manek
|
|
| Back to top |
|
Tech Support
Joined: 25 Aug 2003
Posts: 4368
|
| Posted: Thu Mar 29, 2012 8:03 am Post subject: |
|
|
Manek,
If you would, please go to View - Dialer Log and left click on the Clipboard button. Then paste the log in to a reply post so we can see the error in context, please. |
|
| Back to top |
|
orbit
Joined: 29 Mar 2012
Posts: 4
Location: Bahrain
|
| Posted: Thu Mar 29, 2012 11:19 am Post subject: |
|
|
dear support,
please find the log as asked for.
3/29/2012 10:51:40 AM ------------------------------------------------
3/29/2012 10:51:40 AM Working on message to: Manek from:
3/29/2012 10:51:40 AM Formatting message
3/29/2012 10:51:40 AM Message contained in a single packet
3/29/2012 10:51:40 AM Sending packet
3/29/2012 10:51:41 AM Sent:AT+CMGS=""<CR>
3/29/2012 10:51:41 AM Received:<CR><LF>>
3/29/2012 10:51:41 AM Sent:HI<SUB>
3/29/2012 10:51:44 AM Received:<CR><LF>+CMGS: 203<CR><LF><CR><LF>OK<CR><LF>
3/29/2012 10:51:44 AM Packet sent successfully
3/29/2012 10:51:44 AM SUCCESSFUL To:Manek Msg:HI
3/29/2012 10:51:44 AM Program Halted. Database error: 3061 Too few parameters. Expected 1. in Procedure: SendGSM
3/29/2012 10:51:46 AM Dialer Started
3/29/2012 10:51:48 AM ====================================
3/29/2012 10:51:48 AM Start connection to carrier: Batelco
3/29/2012 10:51:48 AM Connect using GSMAT protocol
3/29/2012 10:51:48 AM Setting communication parameters
3/29/2012 10:51:48 AM Attempting to reset modem
3/29/2012 10:51:50 AM Sent:AT<CR>
3/29/2012 10:51:51 AM Received:<CR><LF>OK<CR><LF>
3/29/2012 10:51:51 AM Modem reset
3/29/2012 10:51:51 AM Attempting to send carrier init string
3/29/2012 10:51:51 AM Sent:AT&FQ0V1X4&D2N0S37=9\N0%C0<CR>
3/29/2012 10:51:52 AM Received:<CR><LF>OK<CR><LF>
3/29/2012 10:51:52 AM Carrier init string sent
3/29/2012 10:51:53 AM Sent:AT+CMGF=1<CR>
3/29/2012 10:51:53 AM Received:<CR><LF>OK<CR><LF>
3/29/2012 10:51:53 AM Text delivery mode entered
3/29/2012 10:51:53 AM ------------------------------------------------
3/29/2012 10:51:53 AM Working on message to: from:
3/29/2012 10:51:53 AM Formatting message
3/29/2012 10:51:53 AM Message contained in a single packet
3/29/2012 10:51:53 AM Sending packet
3/29/2012 10:51:53 AM Sent:AT+CMGS=""<CR>
3/29/2012 10:51:54 AM Received:<CR><LF>>
3/29/2012 10:51:54 AM Sent:HI<SUB>
3/29/2012 10:51:56 AM Received:<CR><LF>+CMGS: 204<CR><LF><CR><LF>OK<CR><LF>
3/29/2012 10:51:56 AM Packet sent successfully
3/29/2012 10:51:56 AM SUCCESSFUL To:Msg:HI
3/29/2012 10:51:56 AM Program Halted. Database error: 3061 Too few parameters. Expected 1. in Procedure: SendGSM
3/29/2012 10:51:57 AM Dialer Started
3/29/2012 10:51:58 AM ====================================
3/29/2012 10:51:58 AM Start connection to carrier: Batelco
3/29/2012 10:51:58 AM Connect using GSMAT protocol
3/29/2012 10:51:58 AM Setting communication parameters
3/29/2012 10:51:59 AM Attempting to reset modem
3/29/2012 10:52:01 AM Sent:AT<CR>
3/29/2012 10:52:01 AM Received:<CR><LF>OK<CR><LF>
3/29/2012 10:52:02 AM Modem reset
3/29/2012 10:52:02 AM Attempting to send carrier init string
3/29/2012 10:52:02 AM Sent:AT&FQ0V1X4&D2N0S37=9\N0%C0<CR>
3/29/2012 10:52:02 AM Received:<CR><LF>OK<CR><LF>
3/29/2012 10:52:03 AM Carrier init string sent
3/29/2012 10:52:03 AM Sent:AT+CMGF=1<CR>
3/29/2012 10:52:03 AM Received:<CR><LF>OK<CR><LF>
3/29/2012 10:52:03 AM Text delivery mode entered
3/29/2012 10:52:03 AM ------------------------------------------------
3/29/2012 10:52:03 AM Working on message to: Manek from:
3/29/2012 10:52:03 AM Formatting message
3/29/2012 10:52:03 AM Message contained in a single packet
3/29/2012 10:52:03 AM Sending packet
3/29/2012 10:52:04 AM Sent:AT+CMGS=""<CR>
3/29/2012 10:52:04 AM Received:<CR><LF>>
3/29/2012 10:52:04 AM Sent:HI<SUB>
3/29/2012 10:52:07 AM Received:<CR><LF>+CMGS: 205<CR><LF><CR><LF>OK<CR><LF>
3/29/2012 10:52:07 AM Packet sent successfully
3/29/2012 10:52:07 AM SUCCESSFUL To:Manek Msg:HI
3/29/2012 10:52:07 AM Program Halted. Database error: 3061 Too few parameters. Expected 1. in Procedure: SendGSM
3/29/2012 10:52:07 AM Dialer Started
3/29/2012 10:55:44 AM ====================================
3/29/2012 10:55:44 AM Start connection to carrier: Batelco
3/29/2012 10:55:44 AM Connect using GSMAT protocol
3/29/2012 10:55:44 AM Setting communication parameters
3/29/2012 10:55:45 AM Attempting to reset modem
3/29/2012 10:55:47 AM Sent:AT<CR>
3/29/2012 10:55:48 AM Received:<CR><LF>OK<CR><LF>
3/29/2012 10:55:48 AM Modem reset
3/29/2012 10:55:48 AM Attempting to send carrier init string
3/29/2012 10:55:48 AM Sent:AT&FQ0V1X4&D2N0S37=9\N0%C0<CR>
3/29/2012 10:55:49 AM Received:<CR><LF>OK<CR><LF>
3/29/2012 10:55:49 AM Carrier init string sent
3/29/2012 10:55:49 AM Sent:AT+CMGF=1<CR>
3/29/2012 10:55:50 AM Received:<CR><LF>OK<CR><LF>
3/29/2012 10:55:50 AM Text delivery mode entered
3/29/2012 10:55:50 AM ------------------------------------------------
3/29/2012 10:55:50 AM Working on message to: Manek from:
3/29/2012 10:55:50 AM Formatting message
3/29/2012 10:55:50 AM Message contained in a single packet
3/29/2012 10:55:50 AM Sending packet
3/29/2012 10:55:50 AM Sent:AT+CMGS=""<CR>
3/29/2012 10:55:51 AM Received:<CR><LF>>
3/29/2012 10:55:51 AM Sent:<SUB>
3/29/2012 10:55:53 AM Received:<CR><LF>+CMGS: 206<CR><LF><CR><LF>OK<CR><LF>
3/29/2012 10:55:53 AM Packet sent successfully
3/29/2012 10:55:53 AM SUCCESSFUL To:Manek Msg:HI
3/29/2012 10:55:53 AM Program Halted. Database error: 3061 Too few parameters. Expected 1. in Procedure: SendGSM
3/29/2012 10:55:54 AM Dialer Started
3/29/2012 10:56:52 AM ====================================
3/29/2012 10:56:52 AM Start connection to carrier: Batelco
3/29/2012 10:56:52 AM Connect using GSMAT protocol
3/29/2012 10:56:52 AM Setting communication parameters
3/29/2012 10:56:53 AM Attempting to reset modem
3/29/2012 10:56:55 AM Sent:AT<CR>
3/29/2012 10:56:55 AM Received:<CR><LF>OK<CR><LF>
3/29/2012 10:56:56 AM Modem reset
3/29/2012 10:56:56 AM Attempting to send carrier init string
3/29/2012 10:56:56 AM Sent:AT&FQ0V1X4&D2N0S37=9\N0%C0<CR>
3/29/2012 10:56:56 AM Received:<CR><LF>OK<CR><LF>
3/29/2012 10:56:57 AM Carrier init string sent
3/29/2012 10:56:57 AM Sent:AT+CMGF=1<CR>
3/29/2012 10:56:57 AM Received:<CR><LF>OK<CR><LF>
3/29/2012 10:56:57 AM Text delivery mode entered
3/29/2012 10:56:57 AM ------------------------------------------------
3/29/2012 10:56:57 AM Working on message to: Manek from:
3/29/2012 10:56:57 AM Formatting message
3/29/2012 10:56:57 AM Message contained in a single packet
3/29/2012 10:56:57 AM Sending packet
3/29/2012 10:56:58 AM Sent:AT+CMGS=""<CR>
3/29/2012 10:56:58 AM Received:<CR><LF>>
3/29/2012 10:56:58 AM Sent:HI<SUB>
3/29/2012 10:57:01 AM Received:<CR><LF>+CMGS: 207<CR><LF><CR><LF>OK<CR><LF>
3/29/2012 10:57:01 AM Packet sent successfully
3/29/2012 10:57:01 AM SUCCESSFUL To:Manek Msg:HI
3/29/2012 10:57:01 AM Program Halted. Database error: 3061 Too few parameters. Expected 1. in Procedure: SendGSM
3/29/2012 10:57:01 AM Dialer Started
3/29/2012 11:50:55 AM Dialer Stopped
3/29/2012 11:50:57 AM Dialer Started
3/29/2012 11:53:25 AM Dialer Started
3/29/2012 5:35:01 PM Dialer Stopped
3/29/2012 7:10:41 PM Dialer Started
please suggest a workout for this
thanks
manek
|
|
| Back to top |
|
OzCom
Joined: 22 Oct 2003
Posts: 1122
Location: US
|
| Posted: Thu Mar 29, 2012 11:59 am Post subject: |
|
|
Couple things:
RE: This line: "3/29/2012 10:55:50 AM Sent:AT+CMGS=""<CR> "
The destination cellular number MUST be in the quotations - you are sending a blank line. This is the ID field of the recipient
RE: This Line: "3/29/2012 10:55:48 AM Sent:AT&FQ0V1X4&D2N0S37=9\N0%C0<CR>"
The Initialization string should be: AT+CSQ
3/29/2012 10:55:44 AM ====================================
3/29/2012 10:55:44 AM Start connection to carrier: Batelco
3/29/2012 10:55:44 AM Connect using GSMAT protocol
3/29/2012 10:55:44 AM Setting communication parameters
3/29/2012 10:55:45 AM Attempting to reset modem
3/29/2012 10:55:47 AM Sent:AT<CR>
3/29/2012 10:55:48 AM Received:<CR><LF>OK<CR><LF>
3/29/2012 10:55:48 AM Modem reset
3/29/2012 10:55:48 AM Attempting to send carrier init string
3/29/2012 10:55:48 AM Sent:AT&FQ0V1X4&D2N0S37=9\N0%C0<CR>
3/29/2012 10:55:49 AM Received:<CR><LF>OK<CR><LF>
3/29/2012 10:55:49 AM Carrier init string sent
3/29/2012 10:55:49 AM Sent:AT+CMGF=1<CR>
3/29/2012 10:55:50 AM Received:<CR><LF>OK<CR><LF>
3/29/2012 10:55:50 AM Text delivery mode entered
3/29/2012 10:55:50 AM ------------------------------------------------
3/29/2012 10:55:50 AM Working on message to: Manek from:
3/29/2012 10:55:50 AM Formatting message
3/29/2012 10:55:50 AM Message contained in a single packet
3/29/2012 10:55:50 AM Sending packet
3/29/2012 10:55:50 AM Sent:AT+CMGS=""<CR>
3/29/2012 10:55:51 AM Received:<CR><LF>>
3/29/2012 10:55:51 AM Sent:<SUB>
3/29/2012 10:55:53 AM Received:<CR><LF>+CMGS: 206<CR><LF><CR><LF>OK<CR><LF>
3/29/2012 10:55:53 AM Packet sent successfully
3/29/2012 10:55:53 AM SUCCESSFUL To:Manek Msg:HI
3/29/2012 10:55:53 AM Program Halted. Database error: 3061 Too few parameters. Expected 1. in Procedure: SendGSM
3/29/2012 10:55:54 AM Dialer Started_________________ Aaron D. Osgood
Streamline Communications, LLC
* Authorized Notepage, Inc. Development Partner and Re-seller
TEL: 207-518-8455
AOsgood@streamline-solutions.net
Creators of AutoPage Spillman CAD interface for PageGate |
|
| Back to top |
|
orbit
Joined: 29 Mar 2012
Posts: 4
Location: Bahrain
|
| Posted: Thu Mar 29, 2012 12:06 pm Post subject: |
|
|
hi aaron,
THE celular nos i removed them manually from the logs so its fine.
how should i change the initialization string to AT+CSQ and from where i can change this.please help
thanks
manek
|
|
| Back to top |
|
Tech Support
Joined: 25 Aug 2003
Posts: 4368
|
| Posted: Thu Mar 29, 2012 12:55 pm Post subject: |
|
|
| Also, just to verify, if you browse in to the NotePager Pro program directory and go in to the Properties of the npp.exe file, what File Version does it say you're using? |
|
| Back to top |
|
orbit
Joined: 29 Mar 2012
Posts: 4
Location: Bahrain
|
| Posted: Sun Apr 01, 2012 1:55 am Post subject: |
|
|
dear support,
the version is 3.0.0.5
thanks
manek
|
|
| Back to top |
|
Tech Support
Joined: 25 Aug 2003
Posts: 4368
|
|
| Back to top |
|
|
