NotePage, Inc. Forum Index

Database error 3144

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



Joined: 06 Oct 2008
Posts: 18
PostPosted: Wed Jul 01, 2009 5:06 am    Post subject: Database error 3144 Reply with quote
Hello,

I have Pagegate running but yesterday our server rebooted and now pagegate keeps giving the error "Halted: Database error: 3144 Syntax error in UPDATE statement. in Procedure: Send GSM"

This happens everythime the server reboots without stopping the Pagegate services. Does anybody know why this happens and is there someway to stop it from happening again if the server reboots without stopping th epagegate services?

Thanks for you help.
Back to top
View user's profile
Tech Support



Joined: 25 Aug 2003
Posts: 4382
PostPosted: Wed Jul 01, 2009 7:22 am    Post subject: Reply with quote
It was the way PageGate version 5 handles/handled COM ports and port requests. This shouldn't be an issue in version 5.1, which is currently being tested.



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



Joined: 06 Oct 2008
Posts: 18
PostPosted: Wed Jul 01, 2009 7:46 am    Post subject: Reply with quote
How do I fix this issue. it is not working now

thanks
Back to top
View user's profile
Tech Support



Joined: 25 Aug 2003
Posts: 4382
PostPosted: Wed Jul 01, 2009 8:06 am    Post subject: Reply with quote
Ah, I thought that it had started working again after you stopped and started the PageGate Services after the reboot.

This may sound a bit random but try re-installed the Connectivity cable drivers and make sure no other modem softwre is installed on the same box. The only other time I've seen the 3144 error in the same circumstance is explained and answered in this thread: http://www.notepage.net/forum/viewtopic.php?t=7568368&highlight=3144



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



Joined: 22 Oct 2003
Posts: 1122
Location: US
PostPosted: Wed Jul 01, 2009 8:13 am    Post subject: Reply with quote
The underlying issue is the USB to Serial COM port driver issue with your device and operating system. We have been able to defeat this issue by installing a RS232 Serial connected Industrial GSM modem.

FULL DISCLOSURE: We are resellers for the modem manufactoror and NotePage, Inc products



_________________
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
mickm3



Joined: 06 Oct 2008
Posts: 18
PostPosted: Wed Jul 01, 2009 9:12 am    Post subject: Reply with quote
Its working now. There is another modem connected to the server. When I removed this it worked. I have reconnected the other modem to the server and it is still working. When will version 5.1 be available?

Thanks for your help.
Back to top
View user's profile
Display posts from previous:   
Post new topic   Reply to topic    NotePage, Inc. Forum Index -> PageGate 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