Overview

You have configured the passwords to expire after a certain number of days. However, they do not expire at the configured interval as would be expected.

Solution

Environment

This has been observed on Everest 6.40.9 on Windows Server 2008 R2.

How to identify

Examining the ACCOUNT_STATUS table in the Everest database, it seems to show the date and time that the person last logged in not the last time they changed their password.

To confirm, please follow the steps below:

1. Log-out from Everest and then log back in. Take note of the login time.
2. Open SQL Server Management Studio.
3. Run the following query on your company database:
   

   SELECT *
   FROM   account_status
   WHERE  personal_idno = '{your id}' 
   

4. Compare the value in the password_time column to the login time noted in Step 1.

If the two dates are similar (or identical), and you have not changed your password ad that time, please proceed with the steps below to solve the issue.

Resolution

Upgrade to the latest version of Everest, as this unwanted behavior has not been observed on version 8 and above. If that is not an option, please follow these steps:

1. Ensure that there are no triggers or dependencies for the table ACCOUNT_STATUS.
2. Ensure there are no scheduled jobs in the database that affect the table ACCOUNT_STATUS.
3. Create a scheduled job in the database, to force all passwords to expire after a set number of days:
   1. Open SQL Server Management Studio.
   2. In Object Explorer, connect to an instance of the SQL Server Database Engine, and then expand that instance.
   3. Expand SQL Server Agent, right-click on Jobs, and choose New Job.
   4. Open the General page and specify the job name.
   5. Open the Steps page, click New, name the step and enter the following query:
      

      UPDATE account_status
      SET    password_time = Getdate() - {number of days}
      WHERE  personal_idno NOT IN( '{id}' ) 
      

      Replace {number of days} with what's configured in your Everest instance plus one more day. You can find the configured value from the Everest main window, by navigating to File > Setup > Preferences > Flow Control > Passwords.
      Replace {id} with the id of any user account you may not want to have the password expire, such as the supervisor.
   6. Save the step by clicking OK.
   7. Select the Schedules page, and then click New.
   8. In the Name box, type a name for the new schedule.
   9. Clear the Enabled check box if you do not want the schedule to take effect immediately following its creation.
   10. For Schedule Type, click Recurring. Set the recurring schedule as per your requirements, by configuring the Frequency, Daily Frequency, and Duration groups on the dialog.
   11. Save the schedule by clicking OK.
   12. Save the job by clicking OK.