I am using PageGate 5.094 license for 10000 with 4 connectors as a service on Windows 2003 all using the same domain account for Logon.
I have moved only the "message" table from the AccessDB to SQL server and I am inserting the message record for Ad-Hoc users. One is for American Messaging WCTP and the other is for SMTP.
Every inserted message is processed successfully but it takes approximately 60 seconds.
From the PageGate Log:
5/9/2011 10:14:02 AM PGSched Message scheduled. Recipient: ######### from: TRIGGER
5/9/2011 10:14:02 AM Asking PGSched service to start
5/9/2011 10:14:05 AM PGSched start detected
5/9/2011 10:14:08 AM Module paused
5/9/2011 10:14:08 AM Running cleanup routine
5/9/2011 10:14:20 AM Module resumed
5/9/2011 10:14:20 AM Time synchronized with scheduler
5/9/2011 10:14:20 AM Asking Connector1 service to start
5/9/2011 10:14:22 AM Asking Connector2 service to start
5/9/2011 10:14:23 AM Asking Connector3 service to start
5/9/2011 10:14:25 AM Asking Connector4 service to start
5/9/2011 10:14:29 AM Connector1 start detected
5/9/2011 10:14:29 AM Connector2 start detected
5/9/2011 10:14:29 AM Connector3 start detected
5/9/2011 10:14:29 AM Connector4 start detected
5/9/2011 10:14:54 AM PGDial1 SUCCESSFUL Stn:123 To:########## Frm:TRIGGER Msg:test
From PGSched log:
5/9/2011 10:14:02 AM Message scheduled. Recipient: ########## from: TRIGGER
5/9/2011 10:14:02 AM Program Halted. Database error: 3219 Invalid operation. in Procedure: sched_dialers
5/9/2011 10:14:02 AM Module Stopped
5/9/2011 10:14:03 AM Module Started
5/9/2011 10:14:04 AM Running cleanup routine
5/9/2011 10:14:04 AM Waiting for server module to pause
5/9/2011 10:14:08 AM Server module paused
5/9/2011 10:14:08 AM Waiting for connectors to pause
5/9/2011 10:14:14 AM Connectors paused
5/9/2011 10:14:14 AM Waiting for interfaces to pause
5/9/2011 10:14:14 AM Interfaces paused
5/9/2011 10:14:14 AM Attempting to compact database
5/9/2011 10:14:19 AM Database in use, unable to compact
5/9/2011 10:14:19 AM Trimming log files
5/9/2011 10:14:19 AM Removing old entries from audit log
5/9/2011 10:14:19 AM Checking database for null values
5/9/2011 10:14:19 AM Checking database for invalid group entries and dups
5/9/2011 10:14:19 AM Removing old messages from database
5/9/2011 10:14:19 AM Removing old files from badmsg folder
5/9/2011 10:14:19 AM Resetting database flags
5/9/2011 10:14:20 AM Module resumed
This is the pattern that appears on every test, using either WCTP, SMTP and both.
Any clues as to where I can start looking for a cause?
thanks
jim sloan
_________________
jim sloan