cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
530
Views
0
Helpful
1
Replies

cannot delete user

astectelecom
Level 2
Level 2

Unity VM only 4.0.3ex2000 CM 3.3.3 TSP 7.04b

Hi

I have a user stuck in unity that i am unable to delete. When the user goes to pick up messages she hears the message"this system is temporarily unavailable to complete your call". I have tried the Delete Subscribers Properties tool and the query builder in Cudle but the user remains stubornly attached to the unity database. in cuddle when i run the query DELETE FROM Subscriber WHERE Alias='alias' a message pops up that it cannot find the RID for that account. however this process did delete my test account. I can see the user in the subscriber table of SQL

any help appreciated

jim

1 Reply 1

lindborg
Cisco Employee
Cisco Employee

Ok, back up. So presumably you first tried to delete the user properly through the SA and what happened? Were they removed and came back? was there an error?

So you can see a record in the Subscriber table (not the global subscriber table) and you can see the alias string and it tells you it can't find the record? That's pretty suprising... your DB is deeply damaged if that report is accurate. If SQL is not obeying standard query requests we've got problems.

As a test, I'd select the row in the subscriber table you can see, right click on the SubscriberObjectId column for that row, select "copy" in the pop up menu and then construct a query "DELETE FROM Subscriber WHERE SubscriberObjectID='(objectid)' where, of course, the (objectid) string is replaced with what you copied. The ObjectID value is the unique identifier for all rows in all tables so this is the definitive way to select any row in any table for an action.

If that does not remove the row then some trigger is preventing it's removal in the background (i.e. it attempts to remove the call handler associated with the user and such and it's failing so the record removal itself fails). Frankly, I've never seen this in real life on a 4.x system but technically it's possible.