NotePage, Inc. Forum Index

program halted database error:3061 too few parameters.expect

 
Post new topic   Reply to topic    NotePage, Inc. Forum Index -> NotePager Pro Support
View previous topic :: View next topic  
Author Message
orbit



Joined: 29 Mar 2012
Posts: 4
Location: Bahrain

PostPosted: Thu Mar 29, 2012 3:22 am    Post subject: program halted database error:3061 too few parameters.expect Reply with quote

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
View user's profile
Tech Support



Joined: 25 Aug 2003
Posts: 4351

PostPosted: Thu Mar 29, 2012 8:03 am    Post subject: Reply with quote

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.



_________________
Tech Support
support@notepage.com
http://www.notepage.net
Back to top
View user's profile
orbit



Joined: 29 Mar 2012
Posts: 4
Location: Bahrain

PostPosted: Thu Mar 29, 2012 11:19 am    Post subject: Reply with quote

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
View user's profile
OzCom



Joined: 22 Oct 2003
Posts: 1121
Location: US

PostPosted: Thu Mar 29, 2012 11:59 am    Post subject: Reply with quote

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
View user's profile Send e-mail Visit poster's website AIM Address Yahoo Messenger MSN Messenger
orbit



Joined: 29 Mar 2012
Posts: 4
Location: Bahrain

PostPosted: Thu Mar 29, 2012 12:06 pm    Post subject: Reply with quote

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
View user's profile
Tech Support



Joined: 25 Aug 2003
Posts: 4351

PostPosted: Thu Mar 29, 2012 12:55 pm    Post subject: Reply with quote

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?



_________________
Tech Support
support@notepage.com
http://www.notepage.net
Back to top
View user's profile
orbit



Joined: 29 Mar 2012
Posts: 4
Location: Bahrain

PostPosted: Sun Apr 01, 2012 1:55 am    Post subject: Reply with quote

dear support,

the version is 3.0.0.5


thanks
manek


Back to top
View user's profile
Tech Support



Joined: 25 Aug 2003
Posts: 4351

PostPosted: Mon Apr 02, 2012 8:20 am    Post subject: Reply with quote

Manek,

Run through these steps to update NotePager Pro to 3.0.0.6:

http://www.notepage.net/videos/updating-notepager-pro.htm



_________________
Tech Support
support@notepage.com
http://www.notepage.net
Back to top
View user's profile
Display posts from previous:   
Post new topic   Reply to topic    NotePage, Inc. Forum Index -> NotePager Pro Support All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2002 phpBB Group
Theme created by Vjacheslav Trushkin