/
EAP Expert V3 Update Guide

EAP Expert V3 Update Guide

Owned by Service Desk Team
Last updated: Sept 05, 2024 by Alexander Halim
4 min read

This is for the IT staff of customers with on-premises installs already working. For first time installation, please refer to Installation Guide instead.

Please refer to the Release Notes to see what's new in this release of EAP Expert V3.

We strongly recommend you first install this update into a UAT (User Acceptance Testing and Training) environment, prior to deploying it to your production environment. See Setting up a UAT for details. This allows users to become familiar with changes prior to deploying the changes to production, as well as allowing the user to check for issues that might affect productivity. 

If you need assistance for the installation, please let us know in advance, via Service Desk to book a time for us to standby during your installation at least 1 business day in advance. Typically we will be available to assist 10 PM to 5 AM EST.

STEP 1: Run the Installation Program

There are 2 type of installation media: .msi and .exe (self extracting zip). Both are exclusive to each other. You will only need to follow one of these methods to complete installation.

Either method will need a copy of “EAPExpert.Win.exe.config” file to be backed up somewhere safe, and copied over to the application folder once the installation completed

Type 1: EAP Expert v#.#.msi

This is the EAP Expert Version 3 Installer. Use this for most updates and when a completely fresh install is required. 

  1. Uninstall the existing application via the Start Menu, or through "Add/Remove Programs" in Control Panel

  2. Navigate to the application directory (typically C:\Program Files\EAP Expert Inc\EAP Expert 3) and ensure that it has removed this folder, or manually remove all files within the folder

  3. Run the file to install "EAP Expert V3"

  4. Ensure that the user has full control permissions to the installation directory (default directory is C:\Program Files\EAP Expert Inc\EAP Expert 3). Being part of an administrator group does not work due to Window's User Access Control.

  5. Restore (copy and paste) the backed up “EAPExpert.Win.exe.config” to this application folder folder (overwrite existing file)

Type 2: EAP Expert Update v#.#.exe

Use the .exe installation for updating the application files.

  1. Copy the update file into the application directory (typically located at: C:\Program Files\EAP Expert Inc\EAP Expert 3)

  2. Delete all files in the application directory except for the Update file and the existing EAPExpert.Win.exe.config file (this ensures any old files are removed so that they won’t cause issues).

  3. Run the update file, and leave it at the default extract location. It will extract the needed files into the application directory.

STEP 2: Optional Step Based on Build Date

Based on prior application build date, please follow the applicable steps only. If nothing applicable, skip to Step 3 (Complete the Installation)

  1. If your current build is prior to May 17, 2016 you will have been provided with a Before.sql script. Run this against your database

  2. If your current build is prior to April 23, 2018 a message will come up that your license file is corrupt

    1. Click OK on this message

    2. It will then prompt you to upload a new license file, and bring up the file selection window

    3. You will have been given a new license file, or you can request a new one by submitting a ticket to https://support.eapexpert.com

    4. Select the new license file

    5. It will give you one more message that the license is corrupted, click OK

    6. You should then get a message that the license file was uploaded

  3. If your current build is prior to August 23, 2018, you will be provided with an After.sql SQL script. Run this after step 3 (Complete the installation)

  4. If your current build is between December 14, 2021 to October 18, 2022, please run the following SQL query in Expert database:

    • ALTER TABLE [dbo].[LifeBalanceAuthorization] DROP CONSTRAINT [FK_LifeBalanceAuthorization_LifeBalanceProvider]

  5. If your current build is before 1 February 2024, the application folder if using Type 1 (EAP Expert v#.#.msi) installer, then the application folder will change from "C:\Program Files (x86)\EAP Expert Inc" to "C:\Program Files\EAP Expert Inc". If applicable, please update the Parallels / Citrix / RDS shortcut to point to the new path

STEP 3: Complete the Installation

  1. Launch "EAP Expert V3"

  2. Log in using an Administrator account (or any account with "Is Administrator" enabled in EAP Expert)

  3. You will be prompted to update the database, click Yes

  4. You will then be prompted to update the Reports, click No.  Generally this is not necessary as it simply refreshes the included reports in the software. You will be notified if this is required


COMMON ISSUES

Database Version Error

When logging on to the application, with the correct password, the following error message appears:

"An error with number 1111 has occurred.
Error message: The database version is greater than the application version. The application needs to be updated. Please contact your system administrator or download a new version."

Most of the time, this is because not all of the EAP Expert instances, that point to the same database, have the same version (e.g. user machine A has version 1 and user machine B has version 2).

To resolve this, please run the following SQL query in Expert database:

DELETE FROM ModuleInfo

 

Cannot Compile the Generated Code

When opening the application, the following message appears:

Cannot compile the generated code. Please inspect the generated code via this exception's SourceCode property. The following errors occurred:

(0, 0): The predefined type 'System.Runtime.CompilerServices.ExtensionAttribute' is defined in multiple assemblies in the global alias; using definition from 'c:\Windows\Microsoft.NET\Framework64\v4.0.30319\mscorlib.dll'

(0, 0): Error generating Win32 resource: Access is denied.

(0, 0): Unable to delete temporary file 'c:\Program Files (x86)\EAP Expert Inc\EAP Expert 3\CSC1A98DD5C83DF41CC8AA947885E5FE92.TMP' used for default Win32 resource – The system cannot find the file specified.

This is because of the folder permission. Please grant “Modify” or “Full Control” permission to the user that is running the application as.

 

If issue still persist, please submit a ticket to https://support.eapexpert.com with "User Log File" attached.

Related content