Installation, Configuration, and Upgrade Sierra SP1 HF01
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 Sierra SP1 HF01, 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:
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.
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.1 SP7
To perform the database upgrade from v4.1.4 hotfix to v5.1 SP7, 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 |
All the upgrade script files are available along with SummitAI installer files.
Upgrade Folder Path: <Summit installer CD>\Summit<version no>\UpgradeScripts\
Example: ..\\Summitv5.1\UpgradeScripts\
Database Upgrade from v5.1 SP7 To v5.3
To perform the database upgrade from v5.1 SP7 to v5.3, do the following:
Schema Version | Upgrade Script | Upgraded Schema Version |
|---|---|---|
v5.1SP7 | 20.Summitupgrade_v5.1SP7_B003_04July2016_to_v5.3_09thAugust2016 | v5.3 |
All the upgrade script files are available along with SummitAI installer files.
Upgrade Folder Path: <Summit installer CD>\Summit<version no>\UpgradeScripts\
Example: ..\\Summitv5.3UpgradeScripts\
Note:
Execute the scripts (folder name: v5.3-AD_Related_Changes_SP) only if any AD-related changes are fixed between v5.1 to v5.3 and v5.3 to v5.4 upgrade.
Database Upgrade from v5.3 To v5.4
To perform the database upgrade from v5.3 to v5.4, do the following:
Schema Version | Upgrade Script | Upgraded Schema Version |
|---|---|---|
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 |
All the upgrade script files are available along with SummitAI installer files.
Upgrade Folder Path: <Summit installer CD>\Summit<version no>\UpgradeScripts\
Example: ..\\Summitv5.4UpgradeScripts\
Database Upgrade from v5.4 To v5.4 SP1
To perform the database upgrade from v54 to v54 SP1, do the following:
Schema Version | Upgrade Script | Upgraded Schema Version |
|---|---|---|
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 |
All the upgrade script files are available along with SummitAI installer files.
Upgrade Folder Path: <Summit installer CD>\Summit<version no>\UpgradeScripts\
Example: ..\\Summitv5.4SP1UpgradeScripts\
Database Upgrade from v5.4 SP1 to v5.4 SP2
To perform the database upgrade from v54 SP1 to v54 SP2, do the following:
Schema Version | Upgrade Script | Upgraded Schema Version |
|---|---|---|
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 |
All the upgrade script files are available along with SummitAI installer files.
Upgrade Folder Path: <Summit installer CD>\Summit<version no>\UpgradeScripts\
Example: ..\\Summitv5.4SP2UpgradeScripts\
Database Upgrade from v5.4 SP2 to v5.5
To perform the database upgrade from v54 SP2 to v5.5, do the following:
Schema Version | Upgrade Script | Upgraded Schema Version |
|---|---|---|
v5.4SP2 | 25.Summitupgrade_v5.4SP2_B009_27March2017_to_v5.5_9thJune2017. | v5.5 |
All the upgrade script files are available along with SummitAI installer files.
Upgrade Folder Path: <Summit installer CD>\Summit<version no>\UpgradeScripts\
Example: ..\\Summitv5.5UpgradeScripts\
Database Upgrade from v5.5 to v5.5 SP1
To perform the database upgrade from v5.5 to v5.5 SP1, do the following:
Schema Version | Upgrade Script | Upgraded Schema Version |
|---|---|---|
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 |
All the upgrade script files are available along with SummitAI installer files.
Upgrade Folder Path: <Summit installer CD>\Summit<version no>\UpgradeScripts\
Example: ..\\Summitv5.5SP1UpgradeScripts\
Database Upgrade from v5.5 SP1 to v5.5 SP2
To perform the database upgrade from v5.5 SP1 to v5.5 SP2, do the following:
Schema Version | Upgrade Script | Upgraded Schema Version |
|---|---|---|
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 |
All the upgrade script files are available along with SummitAI installer files.
Upgrade Folder Path: <Summit installer CD>\Summit<version no>\UpgradeScripts\
Example: ..\\Summitv5.5SP2UpgradeScripts\
Database Upgrade from v5.5 SP2 to v5.6
To perform the database upgrade from v5.5 SP2 to v5.6, do the following:
Schema Version | Upgrade Script | Upgraded Schema Version |
|---|---|---|
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\
Database Upgrade from v5.6 to v5.6 SP1
To perform the database upgrade from v5.6 to v5.6 SP1, do the following:
Schema Version | Upgrade Script | Upgraded Schema Version |
|---|---|---|
v5.6 | 29.Summitupgrade_v5.6_05Feb2018_to_v5.6SP1_B003_20thFeb2018.sql Note: The upgrade step for v5.6HF01 is merged with this script. | v5.6 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.6SP1UpgradeScripts\
Database Upgrade from v5.6 SP1 to v5.7
To perform the database upgrade from v5.6 SP1 to v5.7, do the following:
Schema Version | Upgrade Script | Upgraded Schema Version |
|---|---|---|
v5.6 SP1 | 30.Summitupgrade_v5.6SP1_B003_20thFeb2018_to_v5.7_ 25thMay2018.sql Note: The upgrade steps for V5.6SP1 HF01 to V5.6SP1 HF03 and V5.6SP2 to V5.6SP2 HF02 are merged with this script. | 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.7UpgradeScripts\
Database Upgrade from v5.7 to v5.7 HF01
To perform the database upgrade from v5.7 to v5.7 HF01, do the following:
Schema Version | Upgrade Script | Upgraded Schema Version |
|---|---|---|
V5.7 | 31.Summitupgrade_v5.7_25thMay2018_to_v5.7HF01_B005_22ndJune2018.sql. | v5.7 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 SP1UpgradeScripts\
Database Upgrade from v5.7 HF01 to v5.7 SP1
To perform the database upgrade from v5.7 HF01 to v5.7 SP1, do the following:
Schema Version | Upgrade Script | Upgraded Schema Version |
|---|---|---|
V5.7 HF01 | 32.Summitupgrade_v5.7HF01_B005_22ndJune2018.sql_to_v5.7SP1_B007_04thAugust2018.sql. | v5.7 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 SP1UpgradeScripts\
Database Upgrade from v5.7 SP1 to v5.7 SP2
To perform the database upgrade from v5.7 SP1 to v5.7 SP2, do the following:
Schema Version | Upgrade Script | Upgraded Schema Version |
|---|---|---|
V5.7 SP1 | 33.Summitupgrade_v5.7SP1_B007_04thAug2018_to_v5.7SP2_B008_21stSep2018 Notes:
- v5.7 SP1 HF01 - v5.7 SP1 HF02 - V5.6SP2HF07 - V5.6SP2HF08 - V5.5SP2HF10 - V5.5SP2HF11
- Identify the full text index and take the backup - Drop the backup full text indexes - Alter the column type or length columns - Create the full text index (execute the full text index backup taken at the first step).
- Identify the procedures and take the backup - Drop the backup procedures - Alter the table type columns
- Identify the index and take the backup - Drop the index - Alter the column - Create the index (execute the index backup taken at the first step) Example of error observed in v5.7 SP2: The index 'IX_User_Master_127892' is dependent on column 'EmpID'. This issue is observed in user master of the v5.7 SP2. It is recommended to follow the above steps if the same error occurs for any other table. | v5.7 SP2 |
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 v5.7 SP2 to v5.7 SP3
To perform the database upgrade from v5.7 SP2 to v5.7 SP3, do the following:
Schema Version | Upgrade Script | Upgraded Schema Version |
|---|---|---|
V5.7 SP2 | 34.Summitupgrade_v5.7SP2_B008_21stSep2018_to_v5.7SP3_B007_05Dec2018 Notes:
- v5.6 SP2 HF10
- Identify the full text index and take the backup - Drop the backup full text indexes - Alter the column type or length columns - Create the full text index (execute the full text index backup taken at the first step).
- Identify the procedures and take the backup - Drop the backup procedures - Alter the table type columns - Create the procedure (execute the procedure backup taken at the first step). This issue is observed in user master of the v5.7 SP3. It is recommended to follow the above steps if the same error occurs for any other table. | v5.7 SP3 |
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 v5.7 SP3 to v5.7 SP5
To perform the database upgrade from v5.7 SP3 to v5.7 SP5, do the following:
Schema Version | Upgrade Script | Upgraded Schema Version |
|---|---|---|
V5.7 SP3 | 35.Summitupgrade_v5.7SP3_B007_05Dec2018_to_v5.7SP5_B005_2ndJanuary2019.sql. Note: The upgrade steps of v5.7 SP4 are merged with this script. | 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 SP5UpgradeScripts\
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 |
|---|---|---|
V5.7 SP5 | 36.Summitupgrade_v5.7SP5_B005_2ndJanuary2019_to_Alps_B016_31stMarch2019.sql Note: |