| View previous topic :: View next topic |
| Author |
Message |
tecopager
Joined: 15 Mar 2005
Posts: 4
|
 Posted: Tue Mar 15, 2005 4:50 pm Post subject: Program Halted. Error# 94 Invalid use of Null in Procedure: |
 |
|
| Program Halted. Error# 94 Invalid use of Null in Procedure: SendSMTP is appearing in a dialer log - any advice?
|
|
| Back to top |
|
Tech Support
Joined: 25 Aug 2003
Posts: 4407
|
| Posted: Tue Mar 15, 2005 4:53 pm Post subject: |
|
|
| Can you copy and post the entire connection attempt (Starting with "Start Connection to Carrier") from the log, up to the error message?
|
|
| Back to top |
|
tecopager
Joined: 15 Mar 2005
Posts: 4
|
| Posted: Tue Mar 15, 2005 4:56 pm Post subject: |
|
|
3/15/2005 7:34:52 AM Start connection to carrier: VerizonEmail
3/15/2005 7:34:52 AM Sending via SMTP
3/15/2005 7:34:52 AM ----------------------------------------
3/15/2005 7:34:52 AM Working on message to: xxxxx from: xxxxxxxxxxxxx@xxxxxx.com
3/15/2005 7:34:52 AM Program Halted. Error# 94 Invalid use of Null in Procedure: SendSMTP
3/15/2005 7:34:52 AM Module Stopped
3/15/2005 7:34:53 AM Module Started
3/15/2005 7:34:57 AM Time synchronized with scheduler
|
|
| Back to top |
|
Tech Support
Joined: 25 Aug 2003
Posts: 4407
|
| Posted: Tue Mar 15, 2005 5:13 pm Post subject: |
|
|
Can you zip and send the database and ALL PageGate logs (*.log) to forumsupport@notepage.com?
Is the log time stamp correct, or is your system time off? Is this still happening?
You may need to cancel pending messages for this recipient (right click on recipient in PG Admin).
|
|
| Back to top |
|
tecopager
Joined: 15 Mar 2005
Posts: 4
|
| Posted: Tue Mar 15, 2005 5:57 pm Post subject: |
|
|
| I have sent the requested files
|
|
| Back to top |
|
Tech Support
Joined: 25 Aug 2003
Posts: 4407
|
| Posted: Wed Mar 16, 2005 7:04 am Post subject: |
|
|
| It looks like the error(s) was caused by NULL values being entered into the 'message' field in the messages table. We are looking at how that happened.
|
|
| Back to top |
|
sebrewer
Joined: 27 Apr 2005
Posts: 5
Location: Toledo, OH
|
| Posted: Thu Sep 15, 2005 2:08 pm Post subject: NULL Values in pages |
|
|
I encountered this issue as well. I guess I saw it about once every 2-3 months, and sometimes I'd get several occurrences at a time. I'd be interested to hear NotePage's take on it.
At the time, I was attributing the problem to the fact that the offending source e-mails were being generated by Visual Basic components in our world. I figured that the weakness was in the MS libraries, since I never saw the issue happen with pages sourced from any other system (and there were several of these, all non-Microsoft, with relatively high volumes).
Opening the pagegate.mdb in MS Access and deleting any rows containing null message fields fixes the problem immediately. If you have multiple dialers, pages will still continue to trickle through the bottleneck, but very, very slowly.
|
|
| Back to top |
|
|
