| View previous topic :: View next topic |
| Author |
Message |
rockien
Joined: 16 Jan 2004
Posts: 21
|
 Posted: Mon May 23, 2011 12:43 pm Post subject: 3219 Invalid operation. in Procedure: trim_log |
 |
|
My pagegate server is not processing any web, email, or snpp pages this morning. I get 2 different errors.
1. When trying to load PGAdmin I get a message;
PG Admin Fatal Error
Error # 94 Invalid operation. In Procedure: about_form load
Pagegate log is clean and module starts without errors, but give the following error in PGSched.
2. PGSched:
5/20/2011 Initiating cleanup routines
5/20/2011 Module Stopped
5/20/2011 12:00:02 AM Module Started
5/20/2011 12:00:04 AM Running cleanup routine
5/20/2011 12:00:04 AM Waiting for server module to pause
5/20/2011 12:00:09 AM Server module paused
5/20/2011 12:00:09 AM Waiting for connectors to pause
5/20/2011 12:00:13 AM Connectors paused
5/20/2011 12:00:13 AM Waiting for interfaces to pause
5/20/2011 12:00:13 AM Interfaces paused
5/20/2011 12:00:13 AM Attempting to compact database
5/20/2011 12:00:20 AM Database compacted
5/20/2011 12:00:20 AM Trimming log files
5/20/2011 12:00:20 AM Program Halted. Database error: 3219 Invalid operation. in Procedure: trim_log
Please help me fix this or lead in in the right direction.
Thanks, Rockie
|
|
| Back to top |
|
Tech Support
Joined: 25 Aug 2003
Posts: 4382
|
| Posted: Mon May 23, 2011 1:11 pm Post subject: |
|
|
| Well, I think fixing the first error should fix the second. The Error #94 usually means that something went wrong in the database and now there is a NULL value somewhere. So, has anyone recently gone in to the database in Access and tinkered around? Also, please email the database to support at notepage dot com so I can fix it and get it back to you. |
|
| Back to top |
|
rockien
Joined: 16 Jan 2004
Posts: 21
|
| Posted: Mon May 23, 2011 3:06 pm Post subject: |
|
|
| No one that I know of has done anything with the database. It looks like it quit on Friday night looking at the logs. It did have a message on the server when I logged in that the OS needed activated, so I activated it so maybe that messed it up somehow. I sent an email with the database. Thanks for the help!
|
|
| Back to top |
|
Tech Support
Joined: 25 Aug 2003
Posts: 4382
|
| Posted: Mon May 23, 2011 3:08 pm Post subject: |
|
|
| I just replied with the repaired database. Let us know if it that works, please. |
|
| Back to top |
|
rockien
Joined: 16 Jan 2004
Posts: 21
|
| Posted: Mon May 23, 2011 3:47 pm Post subject: |
|
|
| I uploaded the DB you sent me and it is working now. Not sure how dupicate entries in the settings table were created, but thank you for helping to get this going right away. Rockie
|
|
| Back to top |
|
|
