Upgrade Plant Applications from Version 6.2 Build 484 to Version 7.0 SP5 SIM4 Build 716

This topic describes how to upgrade Plant Applications from version 6.2 build 484 to version 7.0 SP5 SIM4 build 716 to work with Proficy MDC. This procedure is applicable to Proficy MDC installed on Windows 2012 Server Standard and using SQL Server 2012 SP2 Cumulative Update package 9.

Before you begin

  • Ensure that replication is turned on.
  • Ensure that incremental data is being ingested to the file system.
  • If a transaction log backup job is running, stop the job.

Procedure

  1. Access the AWS DMS console, and stop incremental task for the site. To do so, perform the following steps:
    1. Select the database, select the migration task, and then click on Actions.
    2. Select Stop.
  2. If you want to upgrade the database and the operating system, perform the steps in the Upgrade the Database and the Operating System topic, and then skip to step 7.
  3. In AWS DMS, configure the HandleSourceTableAltered action on the SRC group.
  4. Remove Workflow tables from the article list by running the script for version 6.2. When you run the script, ensure that SQL Server Management Studio points to the respective replicated database. If an error occurs while running the script, ignore it.
  5. Run the SQL scripts to decrypt stored procedures.
    Tip:
    • Contact the Support team for the SQL scripts.
    • Use the Scripts.exe file in the following folder to run the scripts: <Plant Applications installation folder>\Proficy\Proficy Server\Database
  6. Uninstall Plant Applications 6.2.
    Tip:
    For instructions, refer to the Plant Applications Getting Started Guide version 7.0 SP3, Appendix C. Perform only up to step 10.
  7. Install Plant Applications 7.0.
    Tip:
    For instructions, refer to the topics Installing the Proficy Application Server and Installing the Plant Applications Server in the Plant Applications Getting Started Guide.
  8. Execute the SQL scripts in the following folders in the <Plant Applications installation folder>\Proficy\Proficy Server\Database folder in the given sequence:
    1. Preconfigure
      Note:
      After executing the script in the Preconfigure folder, you must deploy the decrypted procedures. Contact the Support team for the script to deploy the decrypted procedures.
    2. VerifyDB
      Note:
      If an error occurs while running the script in the VerifyDB folder, ignore the error.
    3. PostConfigureMES
    4. StoredProcedures
    5. PostConfigure
      Note:
      An error occurs when you execute the script in the PostConfigure folder. To fix the error:
      1. Deploy the spSupport_CreateCalculatedColumn decrypted procedure.
      2. Execute the script for the spSupport_MultiLingual_Add procedure.
      Contact the Support team for the required scripts.
    Plant Applications 7.0 is now installed.
  9. Deploy the spDBR_Import_Database decrypted procedure.
    Note:
    Contact the Support team for the required script.
  10. Install the Plant Applications Report Server.
    Tip:
    For instructions, refer to the Plant Applications Getting Started Guide.
    Note:
    A few errors occur when you install the report server. To fix these errors:
    • Copy the file Substitutions.txt from <Plant Applications installation folder>\Proficy\Plant Applications Web Server\SetupLogs to <Plant Application installation folder>\Proficy\Plant Applications Web Server\Scripts.
    • In the Substitutions.txt file, if a domain name is specified, remove it.
    • Execute the scripts in the <Plant Application installation folder>\Proficy\Plant Applications Web Server\Scripts folder.
  11. Install the Plant Applications Client and Administrator.
    Tip:
    For instructions, refer to the Plant Applications Getting Started Guide.
  12. Ensure that the capture and integrate jobs are not running, and run the following files in the given order to install Plant Applications 7.0 build 179; these files are available in the Plant Applications installation folder.
    1. PA70ServerHotfixSetup
    2. PA70WebServerHotfixSetup
    3. PA70ClientHotfixSetup
    Tip:
    After you run the server set up files, you can verify that there are no errors by accessing the following log files:
    • <Plant Applications installation folder>\Proficy\PlantApplications\Server70Hotfix179\UpgradeScripts\ExecuteScript
    • <Plant Applications installation folder>\Proficy\PlantApplications\WebServer70HotFix179\UpgradeScripts\ExecuteScript
  13. Repeat the previous step to install Plant Applications 7.0 build 448.
    After you run the PA70ServerHotfixSetup file, an error occurs. To fix this error, run the following SQL scripts:
    • Script to create table types
    • Scripts in the 004_448_Hotfix_Working.zip file
      Tip:
      • Contact the Support team for the scripts.
      • Use the Scripts.exe file located in the following folder to run the scripts: <Plant Applications installation folder>\Proficy\Proficy Server\Database
      • You can access the ExecuteScript log file to verify that there are no errors.
  14. Repeat step 11 to install Plant Applications 7.0 build 716.
  15. Start the incremental task for the site. To do so, perform the following steps:
    1. Select the database, select the migration task, and then click on Actions.
    2. Select Start.

Results

Plant Applications is now upgraded to version 7.0 SP5 SIM4 build 716 to work with Proficy MDC.