View previous topic :: View next topic |
Author |
Message |
xbaranich
Joined: 20 Aug 2024 Posts: 1 Location: North Carolina, USA
|
Posted: Tue Aug 20, 2024 8:34 pm Post subject: PG Admin - Error#35602 Invalid Operation |
|
|
Good evening,
We are looking for assistance in rectifying an issue that has cropped up within the last few days,
Version: 10.0
On launching PG Admin, we are getting the following errors:
Error adding duplicate object to tree: <user>
Error # 35602 Invalid Operation. in procedure: fill_tree
Where <user> is a user within our system, Once acknowledging the two errors, PG Admin force closes, and the issue repeats on each launch of PG Admin.
PageGate is still active and running as a service on our server, and is still interfacing with our CAD Paging Server; its just that we cannot access PG Admin, or make any changes due to the two errors above, which forces PG Admin to close on each launch.
Note: We have stopped the service, and restarted the OS/VM that Page Gate resides on, with no effect.
Thank you in advanced for any assistance,
Regards,
XBaranich
|
|
Back to top |
|
Tech Support
Joined: 25 Aug 2003 Posts: 4370
|
Posted: Wed Aug 21, 2024 8:21 am Post subject: |
|
|
Those errors indicate that, somehow, a duplicate entry has found its' way into the 'Users' table of the database and duplicates aren't allowed to exist there, which is what causes the 35602.
If you open PG Admin and go to the Program - Settings section, you'll see the 'Database Directory' and if you browse to that directory in Windows, you'll find a file named 'pagegate.mdb' - that's the program's primary database.
You'll either need to open the database in MS Access, go to the Users table, then find and delete the duplicate records or send a copy of the database to support at notepage dot com so we can do the same.
Naturally, you'll want to stop the services and make sure any instances of a PageGate related application are closed before trying to modify the database; don't try to do it live.
If you want to be on the super-safe side, you can make a copy of the active database, edit the copy, then shut the services and applications down and swap the live DB for the edited DB by renaming them. |
|
Back to top |
|
Tech Support
Joined: 25 Aug 2003 Posts: 4370
|
Posted: Wed Aug 21, 2024 8:22 am Post subject: |
|
|
I just realized you can't open PG Admin to verify the DB location, oops.
Open regedit on the server and browse to HKEY_LOCAL_MACHINE - Software - Wow6432Node - NotePage - PageGate and you should see the DB_Dir key's location there. |
|
Back to top |
|
|