Upgrade the Work Tasks Extension and Connector for MES

When upgrading Work Tasks or MES, you must also upgrade the Work Tasks Extension and Connector for MES. Each version of the Extension and Connector is tied to a specific Work Tasks and MES version.

Upgrade the Work Tasks Extension and Connector for MES

Important: After upgrading, clear your browser cache to prevent display errors.

1. If the system is using MES Events (whether through a workflow triggered by an event or through a Wait for MES Event activity), then extract the event configuration information from the MWDBMappingsCustom xml file before updating the MES install. If this step is forgotten, then after upgrade, run the Event Creator to reconfigure all the MES Events.

2. Ensure that the compatible versions of Work Tasks and MES for this upgrade are installed.

3. Uninstall the current versions of the MES Extension and the MES Connector.

   See Uninstall the Work Tasks Extension and Connector for MES.

4. Install the new version of MES Extension.

   See Install the Work Tasks Extension for MES.

5. Install the new version of MES Connector and reconfigure.

   See Install the Work Tasks Connector for MES.

   Note: The previous version of the Connector changed the password encryption mechanism. When upgrading from version 6.x or earlier, use the Connector Configuration utility to reconfigure all the repositories before starting the Connector service. If multiple connections exist, all repositories need to be reconfigured (or deleted) before the Connector service will start.

Extract MES Event Configuration data from the MWDBMappingsCustom xml file

6. On the MES Middleware machine, open the MWDBMappingsCustom file located in the middleware directory.

7. At the end of the file, copy the entire section for the XML tag ext_hooks_objects. It will begin with <ext_hooks_objects> and end with </ext_hooks_objects>.

8. After the MES product is upgraded, open the new MWDBMappingsCustom xml file and replace the ext_hooks_objects XML tag with the original data.

Update the MES Event form and list items

After upgrading, follow these steps to update the MES Events form and list items.

Note: This procedure must be performed by a SQL Server administrator.

9. In Enterprise console, select Menu, select Tools, and then select Manage Lists.

   The Manage List page opens.

10. Select the MES Events list.

11. Select Edit.

    The Edit window appears.

12. In the Edit window, select Save & Continue.

    The List Designer appears.

13. Select Submit.

    The Form Settings dialog appears.

14. Select Yes, Regenerate Default Form, and then select OK.

    The regenerated form opens in the Form Designer.

15. Select Import.

    The Import window appears.

16. Import the MES Events form XML document from the MES Connector installer path C:\Program Files\AVEVA\Work Tasks\IntegrationScripts\MES\Forms.

17. Select Publish to publish the imported MES Events form.

18. Update the Operations column of the SKEListDefinition table for MES Events as follows:

    1. Open SQL Server Management Studio (SSMS), select the appropriate SQL Server instance, and sign in.

    2. In the View menu, select Object Explorer to open the Object Explorer window.

    3. Navigate to the Database node for the SQL Server instance, right-click on the database name to be updated, and select New Query.

       A new Query tab opens.

    4. In the Query window, select Open from the File menu.

    5. Navigate to the MES Extension and Connector install directory, select the NewOperationDEF.sql script, and then select Open.

       By default, the install directory is: C:\Program Files (x86)\Wonderware\MES\Workflow

       The script appears in the Query window.

    6. For each of your configured repository data source databases, update the placeholder database name <MyDataSrcDB> in the script with the name of your configured database and select Execute to run the script.

    7. After successfully executing the script on each one of your repository data source databases, close SSMS.

19. Perform an IIS reset (IISRESET) to apply the updates.

Update XML Command configuration

Work Tasks Extension for MES 2023 R2 (v7.1) has changed the MES XML Commands handling of floating point values specifically for regions not using the period (".") separator. After upgrading from a version prior to version 7.1 or importing a workflow from a prior release, you must update any workflows that use XML Command activities with floating-point variables. Follow these steps to update affected workflows:

20. Open the workflow in the editor.

21. Regenerate XML Command activities as follows:

    1. Right-click on the XML Command activity to be updated.

       

    2. Select Activity Properties from the shortcut menu.

       

       An Activity Properties toolbar opens and displays a Generate Command field.

    3. In the Generate Command field, select the button.

       

       The Generate Command dialog opens.

    4. Select Generate XML Variables to regenerate the variables, and then select Close to exit the dialog.

       

    5. From the Activity Properties tool bar, select Save.

       

22. Save the workflow.

Note: In addition, forms that populate floating-point (double) variables at run time must use numeric controls only when the decimal separator is other than a period ("."). Text controls are not supported for floating-point input. For more information, refer to the Work Tasks Connector for MES Implementation Guide.