Installation, Configuration, and Upgrade Denali HF08

Installation, Configuration, and Upgrade Denali HF08

On this page: 

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 Denali HF08, 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.

Scripting

There is no impact to the JavaScript codes written using the Scripting functionality when the SummitAI application is upgraded to a later version. However, if there are changes on the Application interface in the later version where the fields referred in the JavaScript code are modified (fields removed, data type changed, etc.), there will be an impact on such JavaScript codes. Such JavaScript codes need to be validated and modified (as required).

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.6

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

Schema Version

Upgrade Script

Upgraded Schema Version

v4.1.4 HF

1.Summitupgrade_v4.1.4HF to v5.1dbscripts[Migration_back]

2.Summitupgrade_v4.1.4HF_B003_20140715 to v5.1_dbscripts[TableSchema]

3.Summitupgrade_v4.1.4HF_B003_20140715 to v5.1_dbscripts[ViewSchema]

4.Summitupgrade_v4.1.4HF_B003_20140715 to v5.1_dbscripts[FunctionSchema]

5.Summitupgrade_v4.1.4HF_B003_20140715 to v5.1_dbscripts[SPSchema]

6.Summitupgrade_v4.1.4HF_dbscripts[PostDeployment]

7.Summitupgrade_v5.1_dbscripts[PostDeployment]

8.Summitupgrade_v5.1_dbscripts[Roletemplate_Migration]

9.Summitupgrade_v5.1_dbscripts[InstanceMigration]

10.Summitupgrade_v5.1_dbscripts[License]

v5.1

v5.1

11.Summitupgrade_v5.1_HF01_24March_to_v5.1_STC_16June_dbscripts

12.Summitupgrade_v5.1_STC_16June_to_v5.1_HF02_01August

13.Summitupgrade_v5.1_HF02_B008_01Aug_to_v5.1_HF03_B015_08Dec

14.Summitupgrade_v5.1_HF03_B015 to v5.1HF02_27OCT

15.Summitupgrade_v5.1HF02_27OCT_to_v5.1SP1_11Dec

v5.1 SP1

v5.1 SP1

16.Summitupgrade_v5.1SP1_11Dec_to_v5.1SP2_B002_16Feb2016.sql

17.Summitupgrade_v5.1_dbscripts[Data_Migration_Modulewise]

v5.1 SP2

v5.1SP2

18.Summitupgrade_v5.1SP2_B002_17Feb2016_to_v5.1SP4_B006_04May2016

v5.1SP4

v5.1SP4

19.Summitupgrade_v5.1SP5_B001_04May2016_to_v5.1SP7_B003_04July

v5.1 SP7

v5.1SP7

20.Summitupgrade_v5.1SP7_B003_04July2016_to_v5.3_09thAugust2016

v5.3

v5.3

21.Summitupgrade_v5.3_9thAug2016_to_v5.4_06thJan2017

v5.4

v5.3 to v5.4 License migration related scripts

22.SummitMigrationScripts-for-v5.3tov5.4_License

InsertInCustomerInfo.sql

UpdateLicense.sql

lm_ANALYSTMAPPING.sql

Note: Read the SUMMIT License Admin Guide and pass the parameter before upgrading the scripts.

License upgrade

v5.4

23.Summitupgrade_v5.4_06thJan2017_to_v5.4SP1_B006_14thFeb2017

Note: The upgrade step for v5.4HF01 is merged with this script.

v5.4SP1

v5.4SP1

24.Summitupgrade_v5.4SP1_B006_14Feb2017_to_v5.4SP2_B009_27March2017

Note: The upgrade steps for v5.4SP1HF01 to v5.4SP1HF03 are merged with this script.

v5.4SP2

v5.4SP2

25.Summitupgrade_v5.4SP2_B009_27March2017_to_v5.5_9thJune2017.

v5.5

v5.5

26.Summitupgrade_v5.5_09June2017_to_v5.5SP1_23rdAug2017.sql

Note: The upgrade steps for v5.5HF01 and HF02 are merged with this script.

v5.5 SP1

v5.5 SP1

27.Summitupgrade_v5.5SP1_23rdAug2017_to_v5.5SP2_2ndNov2017.sql

Note: The upgrade step for v5.5SP1_ B005 is merged with this script.

v5.5 SP2

v5.5 SP2

28.Summitupgrade_v5.5SP2_2ndNov2017_to_v5.6_5thFeb2018.sql

Note: The upgrade steps for v5.5SP2HF01 to HF03 are merged with this script.

v5.6

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

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

Example: ..\\Summitv5.6UpgradeScripts\

Download the upgrade scripts from 4.4 to 5.6 from below path:

https://summitbuild.blob.core.windows.net/denali/Upgradescripts_v4.1.4HF_to_v5.6.zip

Database Upgrade from v5.6 to v5.7

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

Schema Version

Upgrade Script

Upgraded Schema Version

v5.6

1.Summitupgrade_v5.6_05Feb2018_to_v5.7_ 25thMay2018.sql

v5.7

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

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

Example: ..\\Summitv5.6SP1UpgradeScripts\

Database Upgrade from v5.7 to v5.7SP2

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

Schema Version

Upgrade Script

Upgraded Schema Version

v5.6 SP1

2. Summitupgrade_v5.7_25thMay2018_to_v5.7SP2_B008_21stSep2018.sql

v5.7SP2

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

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

Example: ..\\Summitv5.7UpgradeScripts\

Database Upgrade from v5.7SP2 to v5.7SP5

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

Schema Version

Upgrade Script

Upgraded Schema Version

V5.7SP2

3.Summitupgrade_v5.7SP2_B008_21stSep2018_to_v5.7SP5_B005_02Jan2019.sql

v5.7 SP5

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

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

Example: ..\\Summitv5.7 SP1UpgradeScripts\

Database Upgrade from v5.7SP5 to ALPS

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

Schema Version

Upgrade Script

Upgraded Schema Version

v5.7 SP5

4.Summitupgrade_v5.7SP5_B005_02Jan2019_to_ALPS_01Apr2019.sql

ALPS

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

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

Example: ..\\Summitv5.7 SP1UpgradeScripts\

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

ALPS

5.Summitupgrade_ALPS_01Apr2019_to_ALPS_HF01_B006_6thMay2019.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: ..\\Summitv5.7 SP2UpgradeScripts\

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

6.Summitupgrade_ALPS_HF01_B006_6thMay2019_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: ..\\Summitv5.7 SP3UpgradeScripts\

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

7.Summitupgrade_ALPS_SP1_B006_4thJune2019_to_SIERRA_26thAug2019.sql

SIERRA

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

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

Example: ..\\Summitv5.7 SP5UpgradeScripts\

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

8.Summitupgrade_SIERRA_26thAug2019_SIERRA_HF01_B002_11thOct2019.sql

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: ..\\SummitAIALPSUpgradeScripts\

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 HF01

9.Summitupgrade_SIERRA_HF01_B002_to_SIERRA_SP1_B014_12thNov2019.sql

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: ..\\SummitvALPSUpgradeScripts\

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

10.Summitupgrade_SIERRA_SP1_B014_12thNov2019_to_SIERRA_SP1_HF01_B008_10thDec2019.sql

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: ..\\SummitvALPSUpgradeScripts\

Database Upgrade from SIERRA SP1 HF01 to Denali

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

Schema Version

Upgrade Script

Upgraded Schema Version

SIERRA SP1 HF01

11.Summitupgrade_SIERRA_SP1_HF01_B008_10thDec2019_to_DENALI_B025_8thApr2020.sql

DENALI

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 Denali to Denali HF01

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

Schema Version

Upgrade Script

Upgraded Schema Version

DENALI 

12.Summitupgrade_DENALI_8thApr2020_to_DENALI_HF01_16thJun2020.sql

Note:

  • The upgrade steps of v5.7 SP5 HF14 B002, ALPS SP1 HF11 B005, Sierra SP1 HF04 B008, and Sierra SP1 HF05 B007 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.

DENALI HF1

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 Denali HF01 to Denali HF02

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

Schema Version

Upgrade Script

Upgraded Schema Version

DENALI HF01 

13.Summitupgrade_DENALI_HF01_16thJun2020_to_DENALI_HF02_5thAug2020.sql

Note:

  • The upgrade steps of Sierra SP1 HF06 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.

DENALI 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 Denali HF02 to Denali HF03

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

Schema Version

Upgrade Script

Upgraded Schema Version

DENALI HF02 

14.Summitupgrade_DENALI_HF02_5thAug2020_to_DENALI_HF03_31stAug2020.sql

Note:

  • The upgrade steps of SP1 HF07 B003 and 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.

DENALI 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 Denali HF03 to Denali HF04

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

Schema Version

Upgrade Script

Upgraded Schema Version

DENALI HF03 

15.Summitupgrade_DENALI_HF03_31stAug2020_to_DENALI_HF04_30thSept2020.sql