NotePage, Inc. Forum Index

PG Admin - Error#35602 Invalid Operation

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



Joined: 20 Aug 2024
Posts: 1
Location: North Carolina, USA

PostPosted: Tue Aug 20, 2024 8:34 pm    Post subject: PG Admin - Error#35602 Invalid Operation Reply with quote

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



Joined: 25 Aug 2003
Posts: 4370

PostPosted: Wed Aug 21, 2024 8:21 am    Post subject: Reply with quote

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.



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



Joined: 25 Aug 2003
Posts: 4370

PostPosted: Wed Aug 21, 2024 8:22 am    Post subject: Reply with quote

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.



_________________
Tech Support
support@notepage.com
http://www.notepage.net
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