I am receiving a “Locked Users Table is Missing” error and am unable to log into GP. How can I resolve this?
This issue has been resolved in build 6 for GP 9.0, and build 12 for GP 10, and later builds. Please download the latest build if possible. If that is not an option, the workaround is as follows:
1. Copy the Omni Tools .cnk file from where you have it stored, into the GP Application folder.
2. Log in to GP as ‘sa’ or ‘DYNSA’.
3. Go to Tools>>Setup>>Omni Tools>>Omni Password, click the checkbox for “Lockout users after three failed password attempts”.
4. In the Options window under Locked Users table location where you entered the UNC path name, add a backslash character (\) to the end of the path, if one does not already exist, then tab off the field.
5. Click Ok, then OK again to close out of Omni Tools Password windows.
This is the pathname of the table that stores the Users that have been locked out. This table is a Ctree table, not a SQL table. That means instead of creating the table on the SQL Server with the other tables in the system, Omni Tools will create two files called RSOT001.dat and RSOT001.idx in the location you enter.
We recommend that it be a UNC pathname because if it is just a mapped drive, then every User would have to have that very same drive letter mapped exactly the same way in order for it to work. UNC doesn’t require a drive letter.
If you are not able to log into GP at all:
- Make a backup of your dex.ini file
- Open the Dex.ini file and delete the WDC_Auto_Login line and then save the changes
- Try logging into GP again