The following information will show the client (VAR or Customer) how to bypass this security feature in the GP Toolbox. Confirm that the client is allowed to have this knowledge before proceeding. It is recommended to show this information only to the VAR, unless the customer is in an IT Administrative role.
Issue:
Receiving “Locked Users Table is missing” error when logging into GP, which causes users, including ‘sa’, to be locked out of GP, unless they remove the GP Toolbox product from the Dynamics.set file.
Recommendations:
1. Copy the Toolbox.cnk file into the GP Application folder. This will allow one login into GP.
2. Log into GP as ‘sa’ and go to Tools>>Setup>>Dynamics GP Toolbox>>System Settings.
3. Double-click on the User Lockout Tool.
4. Select the Lockout tab
5. Choose to Disable or Enable the User Lockout feature by checking the box accordingly.
a. If you choose to enable it, you will need to type a Locked Users table location pathname in the field, or use the folder icon to navigate to location. Once a pathname is established, the Toolbox will create two Ctree tables called RSTBLU1.dat and RSTBLU1.idx at the location specified.
This is the pathname of the tables that store the Users that have been locked out. Note that these tables are Ctree tables, not SQL tables.
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.
b. If a pathname already exists in the Locked Users table location field, then go to that pathname location via Windows Explorer and confirm the two Ctree tables exist.
c. If the two Ctree tables do not exist, then enter a new pathname on the Lockout Tab Locked Users table location field.
d. The Toolbox will alert you that you are changing locations. Follow the prompts, clicking Yes and Ok to change the location of the Locked Users table location.
e. Confirm the new path by launching SQL Enterprise Manager. Open the RSTB001 table and look at the Locked User Table location record. Ensure it reflects the correct c-tree table location path. If it does not, change it to match the path you entered on the Lockout Tab, in the Locked Users table location.
Script you can use to narrow down search for the Locked Users Pathname record.
Select * from RsTb001 where RSTB_System_setting_key like ‘LOCKOUT%’