You need to get counts before you start database.
Tried that, still get Resultcode = 0xdb000004 ResultDescription = The name was not found in the database.
first thing is to turn your nameindex off and then restart your server - try to login now.
if it does not work then something has renamed the users - you need to work out what happened (perhaps a rogue admin?)
you can check the ACTUAL name of the user by probing the actual files of the db. the *1.dat file is the name file - just open it in notepad. You'll of course need to know the ID of the user to test this though - I always start at user 1 because that's the one created when the db was initialized.
If you are going to clear the index, you need to delete all the names.dat files - don't leave any behind.
Finally, make sure you only have ONE connection to the files of the database - one instance of sbdbserver etc. There's never a good reason to have multiple things accessing the db at once.
Truning off nameindex allowed me to login. I only have one instance of the DB server.
So now that I know logins succeed with nameindex disabled, what can i do to get indexing to working again?
turn it back on in the ini file and then wait - watch to see if a name index gets created. This would mean you have something connecting directly to the files of the DB. You need to stop this bad behaviour.
If the name index does not rebuild, restart your sbdbserver - it should rebuild the index. This may take some time. After the index has been rebuilt you should be able to log in fine.
If not, then you have a corrupt object somewhere which is polluting the index - you'll have to run with it disabled. It's probably then a good time to think about upgrading to a current release - 5.2.3 is pretty old.
Ok, so went ahead and turned indexing back on for the test machine, deleted all name.* files (including names.dat) then ran getcounts. Took about 20 minutes to complete. I then started the DB server and was able to login to EEM. So i think the problem was that I wasn't deleting the name.dat file for machines and users. I'm in the process of doing the same thing in production. Hopefully it will work there as well. Will follow-up shortly with the results.
Life is good again! Indexing is working in production. Thanks for all the help!!