/
Installation, Configuration, and Upgrade Sierra SP1 HF29

Installation, Configuration, and Upgrade Sierra SP1 HF29

May 08, 2024

On this page: 

1 Important Notes About v4.1.4 Setup and Installation | 2 Patch Update for .NET Framework  | 3 SummitAI Upgrade Steps | 4 Installing PsExec Tool | 5 Post Installation Steps | 6 Oracle and IBM Client Configuration | 7 Online Help Upgrade | 8 BI Reports | 9 Maximum File Size for Attachments | 10 Reference Documents | 11 Support | 12 Online Help | Installation Guide | Other Documents

Installation, Configuration, and Upgrade

The following sections provide information related to installation, configuration, and upgrade of the SummitAI application:

Important Notes About v4.1.4 Setup and Installation

Points to be Noted During v4.1.4 Installation

  • While installing the v4.1.4 Web setup on the SummitAI Server, ensure to install English OS and English supported DB only. Furthermore, the SummitAI Proxy Data Collector service needs to be installed on the English OS Server.

  • The Web URL created on English OS Server can be accessed through the Client Machines, which have another language OS, such as English, Chinese, Japanese, and so on. This enables the end users to use the Web URL created in the English OS Server and access SummitAI Suite applications for inputting data in different languages. 

  • The SUMMIT Proxy can be installed on the Client Servers, which has other language OS, such as English, Chinese, Japanese, and so on.

Double-Byte Character Support for SummitAI IT Management Suite

To enable multi-language support for SummitAI IT Management Suite, a basic support for double-byte characters is activated. Now, the application accepts the inputs in any of the language it is typed in and stores it in the same language in the database tables. Whenever required, the data is retrieved and displayed in the respective languages on the GUI.

In the v4.1.4 release, the SummitAI application Graphical User Interface (GUI) is displayed in English. However, the end users can enter the input data or text in any of the languages, such as English, Chinese, Japanese, and so on in the text editable fields.

Note:

In v4.1.4 release, entering text in the E-mail Address and Password fields are supported only in English language. Hence, it is highly recommended to enter the data in the E-mail Address and Password fields on any of the pages for the application in English language only. While logging into the application or configuring the user details, or in any other pages within the application, wherever there is a need to enter the e-mail address and password details, ensure to enter the text in English language. If you enter the details in any other language, the Application throws an error.

Patch Update for .NET Framework 

For .NET Framework 3.5 software, Microsoft has released a patch. It is recommended to apply the .NET Framework 3.5 Service Pack 1 (MS KB 958481, 958483, 958484 patches) after the successful installation of v4.1.4 SummitAI IT Management Suite setup on the SummitAI Server. This helps to avoid occurring of unforeseen errors in the application. You can download the patch from the http://support.microsoft.com/kb/959209 link.

Note:

After the successful deployment of the patches mentioned above, please restart the IIS on SummitAI Server.

SummitAI Upgrade Steps

To upgrade the database of the SummitAI Suite from the prior version v4.1.4 hotfix to Sierra SP1 HF14, do the following:

Assumptions

Before executing the database upgrade scripts, it is assumed that you have successfully installed the SummitAI Suite base version 4.1.4 hotfix or above.

Pre Upgrade Steps

Before you start with the database upgrade of SummitAI, we recommend that you perform the following:

  1. On the SummitAI Database Server, open the Microsoft SQL Server Management Studio tool.  Connect to the SummitAI database Instance. Take the backup of the complete SummitAI database.

  2. On the SummitAI Server, ensure that you take a backup of the folders where the attachment files are saved. In general, the attachment files are saved in the application root directory.

Application Root Directory: \\SummitWeb\<databasename>-ModuleCode-Attachments.

Example of the Attachment Files folder name is ‘summitDB-im-attachments’, where summitDB is the database name, im is the module code for Incident Management and attachments is the folder name.

Database Upgrade from v4.1.4 Hotfix To v5.7 SP5

To perform the database upgrade from v4.1.4 hotfix to v5.7 SP5, do the following:

Schema Version

Upgrade Script

Upgraded Schema Version

Schema Version

Upgrade Script

Upgraded Schema Version

v4.1.4 HF

Please download the scripts from below path which having the
upgrade scripts rom v4.1.4 HF to v5.7SP5

https://summitbuild.blob.core.windows.net/common/SummitUpgradescripts_v4.1.4HF_to_v5.7SP5_B005_02Jan2019.zip

v5.7 SP5

Database Upgrade from v5.7 SP5 to Alps

To perform the database upgrade from v5.7 SP5 to Alps, do the following:

Schema Version

Upgrade Script

Upgraded Schema Version

Schema Version

Upgrade Script

Upgraded Schema Version

V5.7 SP5

1.Summitupgrade_v5.7SP5_B005_02Jan2019_to_Alps_01Apr2019.sql

Note:

  • The upgrade steps of v5.7 SP5 HF01 and v5.7 SP6 are merged with this script.

  • The above upgrade step is applicable only for the SummitAI application instances that are not enabled for GDPR. These steps are already available in the migration tool for the SummitAI application instances, which are enabled for GDPR.

Alps

All the upgrade script files are available along with SummitAI installer files.

Upgrade Folder Path: <Summit installer CD>\Summit<version no>\UpgradeScripts\

Example: ..\\SummitAIALPSUpgradeScripts\

Database Upgrade from ALPS to ALPS HF01

To perform the database upgrade from Alps to Alps HF01, do the following:

Schema Version

Upgrade Script

Upgraded Schema Version

Schema Version

Upgrade Script

Upgraded Schema Version

Alps

2.Summitupgrade_ALPS_01Apr2019_to_ALPS_HF01_B006_06thMay2019.sql

Alps HF01

All the upgrade script files are available along with SummitAI installer files.

Upgrade Folder Path: <Summit installer CD>\Summit<version no>\UpgradeScripts\

Example: ..\\SummitvALPSUpgradeScripts\

Database Upgrade from ALPS HF01 to ALPS SP1

To perform the database upgrade from Alps HF01 to Alps SP1, do the following:

Schema Version

Upgrade Script

Upgraded Schema Version

Alps HF01

3.Summitupgrade_ALPS_HF01_B006_06thMay2019_to_ALPS_SP1_B006_4thJune2019.sql

Alps SP1

All the upgrade script files are available along with SummitAI installer files.

Upgrade Folder Path: <Summit installer CD>\Summit<version no>\UpgradeScripts\

Example: ..\\SummitvALPSUpgradeScripts\

Database Upgrade from Alps SP1 to Sierra

To perform the database upgrade from Alps SP1 to Sierra, do the following: 

Schema Version

Upgrade Script

Upgraded Schema Version

Alps Sp1

4.Summitupgrade_ALPS_SP1_B006_4thJune2019_to_Sierra_26thAugust2019.sql

Note:

  • The upgrade steps of ALPS SP1 HF01 B004 is merged with this script.

  • The above upgrade step is applicable only for the SummitAI application instances that are not enabled for GDPR. These steps are already available in the migration tool for the SummitAI application instances, which are enabled for GDPR.

Sierra

All the upgrade script files are available along with SummitAI installer files.

Upgrade Folder Path: <Summit installer CD>\Summit<version no>\UpgradeScripts\

Example: ..\\SummitAISIERRAUpgradeScripts\

Database Upgrade from Sierra to Sierra HF01

To perform the database upgrade from Sierra to Sierra HF01, do the following: 

Schema Version

Upgrade Script

Upgraded Schema Version

Sierra

5.Summitupgrade_Sierra_26thAug2019_to_Sierra_HF01_B002_11thOct2019.sql

Note:

  • The upgrade steps of ALPS SP1 HF01 B004 is merged with this script.

  • The above upgrade step is applicable only for the SummitAI application instances that are not enabled for GDPR. These steps are already available in the migration tool for the SummitAI application instances, which are enabled for GDPR.

Sierra HF01

All the upgrade script files are available along with SummitAI installer files.

Upgrade Folder Path: <Summit installer CD>\Summit<version no>\UpgradeScripts\

Example: ..\\SummitAISIERRAUpgradeScripts\

Database Upgrade from Sierra HF01 to Sierra SP1

To perform the database upgrade from Sierra HF01 to Sierra SP1, do the following: 

Schema Version

Upgrade Script

Upgraded Schema Version

Sierra

6.Summitupgrade_Sierra_HF01_B002_11thOct2019_to_Sierra_SP1_B014_12thNov2019.sql

Note:

  • The upgrade steps of 5.6SP2 HF18, 5.7SP5 HF08, 5.7SP6 HF05, and ALPS SP1 HF04 are merged with this script.

  • The above upgrade step is applicable only for the SummitAI application instances that are not enabled for GDPR. These steps are already available in the migration tool for the SummitAI application instances, which are enabled for GDPR.

Sierra SP1

All the upgrade script files are available along with SummitAI installer files.

Upgrade Folder Path: <Summit installer CD>\Summit<version no>\UpgradeScripts\

Example: ..\\SummitAISIERRAUpgradeScripts\

Database Upgrade from Sierra SP1 to Sierra SP1 HF01

To perform the database upgrade from Sierra SP1 to Sierra SP1 HF01, do the following: 

Schema Version

Upgrade Script

Upgraded Schema Version

Sierra SP1

7.Summitupgrade_Sierra_SP1_B014_12thNov2019_to_Sierra_SP1_HF01_B008_10thDec2019.sql

Note:

  • The above upgrade step is applicable only for the SummitAI application instances that are not enabled for GDPR. These steps are already available in the migration tool for the SummitAI application instances, which are enabled for GDPR.

Sierra SP1 HF01

All the upgrade script files are available along with SummitAI installer files.

Upgrade Folder Path: <Summit installer CD>\Summit<version no>\UpgradeScripts\

Example: ..\\SummitAISIERRAUpgradeScripts\

Database Upgrade from Sierra SP1 HF01 to Sierra SP1 HF02

To perform the database upgrade from Sierra SP1 HF01 to Sierra SP1 HF02, do the following: 

Schema Version

Upgrade Script

Upgraded Schema Version

Sierra SP1 HF01

8.Summitupgrade_Sierra_SP1_HF01_B008_10thDec2019_to_Sierra_SP1_HF02_B004_30thDec2019.sql

Note:

  • The above upgrade step is applicable only for the SummitAI application instances that are not enabled for GDPR. These steps are already available in the migration tool for the SummitAI application instances, which are enabled for GDPR.

Sierra SP1 HF02

All the upgrade script files are available along with SummitAI installer files.

Upgrade Folder Path: <Summit installer CD>\Summit<version no>\UpgradeScripts\

Example: ..\\SummitAISIERRAUpgradeScripts\

Database Upgrade from Sierra SP1 HF02 to Sierra SP1 HF03

To perform the database upgrade from Sierra SP1 HF02 to Sierra SP1 HF03, do the following: 

Schema Version

Upgrade Script

Upgraded Schema Version

Sierra SP1 HF02

9.Summitupgrade_Sierra_SP1_HF02_B004_30thDec2019_to_Sierra_SP1_HF03_B004_19thFeb2020.sql

Note:

  • The above upgrade step is applicable only for the SummitAI application instances that are not enabled for GDPR. These steps are already available in the migration tool for the SummitAI application instances, which are enabled for GDPR.

Sierra SP1 HF03

All the upgrade script files are available along with SummitAI installer files.

Upgrade Folder Path: <Summit installer CD>\Summit<version no>\UpgradeScripts\

Example: ..\\SummitAISIERRAUpgradeScripts\

Database Upgrade from Sierra SP1 HF03 to Sierra SP1 HF04

To perform the database upgrade from Sierra SP1 HF03 to Sierra SP1 HF04, do the following: 

Schema Version

Upgrade Script

Upgraded Schema Version

Sierra SP1 HF03

10.Summitupgrade_Sierra_SP1_HF03_B004_19thFeb2020_to_Sierra_SP1_HF04_B008_30thApr2020.sql

Note:

  • The above upgrade step is applicable only for the SummitAI application instances that are not enabled for GDPR. These steps are already available in the migration tool for the SummitAI application instances, which are enabled for GDPR.

Sierra SP1 HF04

All the upgrade script files are available along with SummitAI installer files.

Upgrade Folder Path: <Summit installer CD>\Summit<version no>\UpgradeScripts\

Example: ..\\SummitAISIERRAUpgradeScripts\

Database Upgrade from Sierra SP1 HF04 to Sierra SP1 HF05

To perform the database upgrade from Sierra SP1 HF04 to Sierra SP1 HF05, do the following: 

Schema Version

Upgrade Script

Upgraded Schema Version

Sierra SP1 HF04

11.Summitupgrade_Sierra_SP1_HF04_B008_30thApr2020_to_Sierra_SP1_HF05_B006_31stMay2020.sql

Note:

  • The upgrade steps of v5.7 SP5 HF13 B002 and ALPS SP1 HF10 B004 are merged with this script.

  • The above upgrade step is applicable only for the SummitAI application instances that are not enabled for GDPR. These steps are already available in the migration tool for the SummitAI application instances, which are enabled for GDPR.

Sierra SP1 HF05

All the upgrade script files are available along with SummitAI installer files.

Upgrade Folder Path: <Summit installer CD>\Summit<version no>\UpgradeScripts\

Example: ..\\SummitAISIERRAUpgradeScripts\

Database Upgrade from Sierra SP1 HF05 to Sierra SP1 HF06

To perform the database upgrade from Sierra SP1 HF05 to Sierra SP1 HF06, do the following: 

Schema Version

Upgrade Script

Upgraded Schema Version

Sierra SP1 HF05

12.Summitupgrade_Sierra_SP1_HF05_B006_31stMay2020_to_Sierra_SP1_HF06_B004_30thJune2020.sql

Note:

  • The upgrade steps of v5.7 SP5 HF14 B002 and ALPS SP1 HF11 B005 are merged with this script

  • The above upgrade step is applicable only for the SummitAI application instances that are not enabled for GDPR. These steps are already available in the migration tool for the SummitAI application instances, which are enabled for GDPR.

Sierra SP1 HF06

All the upgrade script files are available along with SummitAI installer files.

Upgrade Folder Path: <Summit installer CD>\Summit<version no>\UpgradeScripts\

Example: ..\\SummitAISIERRAUpgradeScripts\

Database Upgrade from Sierra SP1 HF06 to Sierra SP1 HF07

To perform the database upgrade from Sierra SP1 HF06 to Sierra SP1 HF07, do the following: 

Schema Version

Upgrade Script

Upgraded Schema Version

Sierra SP1 HF06

13.Summitupgrade_Sierra_SP1_HF06_B004_30thJune2020_to_Sierra_SP1_HF07_B003_05thAug2020.sql

Note:

  • The upgrade steps of ALPS SP1 HF12 B003 are merged with this script.

  • The above upgrade step is applicable only for the SummitAI application instances that are not enabled for GDPR. These steps are already available in the migration tool for the SummitAI application instances, which are enabled for GDPR.

Sierra SP1 HF07

All the upgrade script files are available along with SummitAI installer files.

Upgrade Folder Path: <Summit installer CD>\Summit<version no>\UpgradeScripts\

Example: ..\\SummitAISIERRAUpgradeScripts\

Database Upgrade from Sierra SP1 HF07 to Sierra SP1 HF08

To perform the database upgrade from Sierra SP1 HF07 to Sierra SP1 HF08, do the following: 

Schema Version

Upgrade Script

Upgraded Schema Version

Sierra SP1 HF07

14.Summitupgrade_Sierra_SP1_HF07_B003_05thAug2020_to_Sierra_SP1_HF08_B005_1stSep2020.sql

Note:

  • The upgrade steps of ALPS SP1 HF13 B003 are merged with this script.

  • The above upgrade step is applicable only for the SummitAI application instances that are not enabled for GDPR. These steps are already available in the migration tool for the SummitAI application instances, which are enabled for GDPR.

Sierra SP1 HF08

All the upgrade script files are available along with SummitAI installer files.

Upgrade Folder Path: <Summit installer CD>\Summit<version no>\UpgradeScripts\

Example: ..\\SummitAISIERRAUpgradeScripts\

Database Upgrade from Sierra SP1 HF08 to Sierra SP1 HF09

To perform the database upgrade from Sierra SP1 HF08 to Sierra SP1 HF09, do the following: 

Schema Version

Upgrade Script

Upgraded Schema Version

Sierra SP1 HF08

15.Summitupgrade_Sierra_SP1_HF08_B005_1stSep2020_to_Sierra_SP1_HF09_B004_30thSep2020.sql

Note:

  • The upgrade steps of ALPS SP1 HF14 B006 are merged with this script.

  • The above upgrade step is applicable only for the SummitAI application instances that are not enabled for GDPR. These steps are already available in the migration tool for the SummitAI application instances, which are enabled for GDPR.