Auditing May Not Function Correctly for Sessions Where Users Must Change an Expired Password to Log In.

March 26, 2007 | KB: 1011781
Laserfiche Server - Team (MSDE) 7.2, Laserfiche Server - United (MS SQL) 7.2, Laserfiche Server - United (Oracle) 7.2, Audit Trail 7.2

Summary

When a user's Laserfiche password has expired, the user will be prompted to specify a new password in order to log in to the repository. After they specify a new password, they are automatically logged in to the repository. However, Laserfiche Auditing does not correctly account for this initial change and is unable to audit the first session that is created immediately after the user specifies a new password. If the user logs out and logs back in, Audit Trail functions as normal.

Each audit event in this initial session will log a message similar to the following in your repository's error.log file.

    [7050] Error in audit (event code=83): The INSERT statement conflicted with the FOREIGN KEY constraint "FK_AuditEvent". The conflict occurred in database "YourSQLDatabase", table "dbo.AuditSession", column 'SessionId'.

Resolution

There is a hotfix available for Laserfiche Server 7.2.1. The fix is an updated version of LFEng.dll (version 7.2.1.430). Laserfiche will now properly audit these types of sessions.

Important: LFEng.dll (version 7.2.1.430) includes changes made in previous LFEng.dll hotfixes (7.2.1.410 and 7.2.1.425). If you wish to directly update the release version of LFEng.dll (7.2.1.407) to LFEng.dll (7.2.1.430), you must also perform the necessary updates to your SQL database table structure and delete your repository's SEARCH folder and re-index your repository. Please see Knowledge Base articles 1011713 and 1011769

To update Laserfiche Server

  1. Click the following link to download a zip file containing the updated version of LFEng.dll.
    Hotfix_SCR29620
  2. Stop the Laserfiche Server service.
    1. Click Start and then click Control Panel.
    2. Double-click Administrative Tools.
    3. Double-click Services.
    4. Select Laserfiche Server 7.2.
    5. From the Action menu, point to All Tasks and select Stop.
  3. Replace your existing version of LFEng.dll located in your Laserfiche Server installation with the updated version contained in the zip file. By default, Laserfiche Server is installed at "C:\Program Files\Laserfiche\Server."
  4. Restart the Laserfiche Server service.
    1. Click Start and then click Control Panel.
    2. Double-click Administrative Tools.
    3. Double-click Services.
    4. Select Laserfiche Server 7.2.
    5. From the Action menu, point to All Tasks and select Start.