NotePage, Inc. Forum Index

3219 Invalid operation

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



Joined: 21 Sep 2010
Posts: 9

PostPosted: Mon May 09, 2011 9:53 am    Post subject: 3219 Invalid operation Reply with quote

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



Joined: 25 Aug 2003
Posts: 4351

PostPosted: Mon May 09, 2011 10:05 am    Post subject: Reply with quote

Jim,

The fact that the Scheduler is stopping and starting each time you insert a record in the messages table usually means one or more of the field values you're inserting are incorrect or Null values. If you would, please contact me at support at notepage dot com so we can go over the specifics of your SQL integration and each item in the messages table.



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



Joined: 21 Sep 2010
Posts: 9

PostPosted: Mon May 09, 2011 12:38 pm    Post subject: Reply with quote

Thanks!! That was the clue I needed...

I used the documentation at http://www.notepage.net/download/pgintegration.txt and I ignored the fields labeled "not used" ... I've gone back to my schema and set default values to 0 for numeric fields and ('') for strings.

New test has it processed in 5 seconds! (the scheduler Poling Interval)
5/9/2011 1:31:26 PM PGSched Message scheduled. Recipient: ########## from: TRIGGER

5/9/2011 1:31:31 PM PGDial1 SUCCESSFUL Stn:123 To:########## Frm:TRIGGER Msg:test 2


thanks again
jim sloan



_________________
jim sloan
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