PageGate Failing

[wiklej]

I had an issue this morning with PageGate not sending messages. The user would go to the webpage, ready their message and click Send. They get a confirmation that the message was accepted. The message is never sent.

I have a custom ASP I wrote to help them track their messages. It simply runs a SELECT on the messages table in the database based on their username and displays From, To, ScheduledTime, TriedTime, message, and Yes/No for Scheduled, Sent and Error.

Their message never showed on this tracking page.

I checked that all of the services were running and they were. I checked the event log. There was nothing odd. I checked the IIS logs to see that webgate.exe was actually called and reported a 200. It was and did.

I made a copy of the database and opened it in Access. I went to the messages table and could not find their message. I stopped the PageGate services using the Tray Icon. They stopped successfully, but the pagegate.ldb lock file still existed. I tried to delete it, but it was still in use. I stopped IIS and the LDB file was still in use. I viewed my running processes and found PGWEB


The properties on pagegate.exe show File Version-4.0.0.96 and Product Version 4.00.0096 with a Date Modified of 1/24/2007 4:31PM.

[wiklej]

Sorry..hit Enter by accident.

I found PGWEB.exe running. When I killed that process, I could then delete the LDB file. Then, when I restarted the PageGate services and IIS, all of the messages that had been queued were sent.

My questions are:
1) Where were these messages being stored before they were sent?
2) How can I monitor for this type of thing to find out quickly if it happens again? I already monitor the services thru SNMP and get notified if they fail. I would like to monitor the "Queued-but-not-secheduled-and-not-sent" queue.

Thanks for your help.

Jeff