03-16-2017 08:24 AM
We recently lost an employee, and I am having trouble deleting the user out of the database. What we are trying to do is re-assign all of his records to a different user before he gets deleted. After i choose what user and click next the Working scroll bar pops up, and i see The delete user window behind go to not responding. It sits like this for about 20 minutes, and then brings up the confirmation to delete user. When i select yes it gives me an error message
"Failed to log into the database. The SQL Database Command timed out."
I have tried messing with the timeout values in actdiag that some of the kb's mentioned, but that did not solve the issue. It also only seems to happen for this user. We had a user last week that we needed to remove, and that user had a lot more records than this one. He deleted without any issue.
I also tried creating a new user-re-assigning to that new user during delete, and was then going to try deleting the temp user and re-assigning to the correct person and that also failed. Did this to narrow down if it is the removed user, or the user that will be getting all of the records.
We run weekly maintenance, and i have done manual maintenance since this issue presented which did not help.
Anyone run into this issue and have any suggestions?
03-20-2017 07:29 AM
03-20-2017 07:59 AM
Before i answer your questions I did manage to get this taken care of, but i would like this here for anyone else that may come into this issue.
I changed the timeout values from 90 to 900
can't really tell when it fails as its frozen until i receive the error message part. Can say it didn't re-assign any records.
This came to my attention when 1 of the end users was having trouble trying this from a client machine. I have been trying it 100% from the server.
What i ended up doing to actually resolve the issue is created a custom lookup for any contact record with the user as the record manager. I then selected edit -> replace value. I chose the user they are getting re-assigned to. I did this in batches of about 500. I then repeated this for companies, and opportunities.
After i finished this i went to delete the user and still chose to re-assign records in case i missed anything. This time i completed in about 5 minutes, and was able to delete the user.