Installation, Configuration, and Upgrade Denali SP1 HF22
- Enterprise IT
Previous Versions: << Sierra << Sierra HF01 << Sierra SP1 << Sierra SP1 HF01 << Sierra SP1 HF02 << Sierra SP1 HF03 << Denali << Denali HF01 << Denali HF02 << Denali SP1 << Denali SP1 HF01 << Denali SP1 HF02 << Denali SP1 HF03 << Denali SP1 HF04 << Denali SP1 HF05 << Denali SP1 HF06 << Denali SP1 HF07 << Denali SP1 HF08 << Denali SP1 HF09 << Denali SP1 HF10 << Denali SP1 HF11 << Denali SP1 HF12 << Denali SP1 HF13 << Denali SP1 HF14 << Denali SP1 HF15 << Denali SP1 HF16 << Denali SP1 HF17 << Denali SP1 HF18 << Denali SP1 HF19 << Denali SP1 HF20 << Denali SP1 HF21
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
- Patch Update for .NET Framework
- Security Best Practices for SummitAI Application Deployment
- SummitAI Upgrade Steps
- Installing PsExec Tool
- Post Installation Steps
- Oracle and IBM Client Configuration
- Online Help Upgrade
- BI Reports
- Maximum File Size for Attachments
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 SP1 HF07, do the following:
All old configuration of the Auto Problem Record creation will be deleted when you upgrade from pre-Denali SP1 to Denali SP1 or a later release. Hence, the Administrator needs to do configurations based on CONDITION and TARGET fields again.
For more information, see Configuring Auto Create Problem Records.
- Assumptions
- Scripting
- Pre Upgrade Steps
- Database Upgrade from v4.1.4 Hotfix To v5.6
- Database Upgrade from v5.6 to v5.7
- Database Upgrade from v5.7 to v5.7SP2
- Database Upgrade from v5.7SP2 to v5.7SP5
- Database Upgrade from v5.7SP5 to ALPS
- Database Upgrade from ALPS to ALPS HF01
- Database Upgrade from ALPS HF01 to ALPS SP1
- Database Upgrade from ALPS SP1 to SIERRA
- Database Upgrade from SIERRA to SIERRA HF01
- Database Upgrade from SIERRA HF01 to SIERRA SP1
- Database Upgrade from SIERRA SP1 to SIERRA SP1 HF01
- Database Upgrade from SIERRA SP1 HF01 to Denali
- Database Upgrade from Denali to Denali SP1
- Database Upgrade from Denali SP1 to Denali SP1 HF01
- Database Upgrade from Denali SP1 HF01 to Denali SP1 HF02
- Database Upgrade from Denali SP1 HF02 to Denali SP1 HF03
- Database Upgrade from Denali SP1 HF03 to Denali SP1 HF04
- Database Upgrade from Denali SP1 HF04 to Denali SP1 HF05
- Database Upgrade from Denali SP1 HF05 to Denali SP1 HF06
- Database Upgrade from Denali SP1 HF06 to Denali SP1 HF07
- Database Upgrade from Denali SP1 HF07 to Denali SP1 HF08
- Database Upgrade from Denali SP1 HF08 to Denali SP1 HF09
- Database Upgrade from Denali SP1 HF09 to Denali SP1 HF10
- Database Upgrade from Denali SP1 HF10 to Denali SP1 HF11
- Database Upgrade from Denali SP1 HF11 to Denali SP1 HF12
- Database Upgrade from Denali SP1 HF12 to Denali SP1 HF13
- Database Upgrade from Denali SP1 HF13 to Denali SP1 HF14
- Database Upgrade from Denali SP1 HF14 to Denali SP1 HF15
- Database Upgrade from Denali SP1 HF15 to Denali SP1 HF16
- Database Upgrade from Denali SP1 HF16 to Denali SP1 HF17
- Database Upgrade from Denali SP1 HF17 to Denali SP1 HF18
- Database Upgrade from Denali SP1 HF18 to Denali SP1 HF19
- Database Upgrade from Denali SP1 HF19 to Denali SP1 HF20
- Database Upgrade from Denali SP1 HF20 to Denali SP1 HF21
- Database Upgrade from Denali SP1 HF21 to Denali SP1 HF22
- Database Upgrade in BI Report and Global Search
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:
- 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.
For installing BI Reports (Alps onwards releases) ensure you contact SummitAI Support and Implementation team. This is a one time script and needs to be executed only once. It does not require execution for every upgrade.
For example, if you have executed the script to install BI Reports in DENALI SP1 HF11 Release, you need not execute it in DENALI SP1 HF 12 Release.
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 SP1
To perform the database upgrade from Denali to Denali SP1, do the following:
Schema Version | Upgrade Script | Upgraded Schema Version |
DENALI | 12.Summitupgrade_DENALI_B025_8thApr2020_to_DENALI_SP1_20thJul2020.sql Note:
| DENALI 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 Denali SP1 to Denali SP1 HF01
To perform the database upgrade from Denali SP1 to Denali SP1 HF01, do the following:
Schema Version | Upgrade Script | Upgraded Schema Version |
DENALI SP1 | 13.Summitupgrade_DENALI_SP1_20thJul2020_to_DENALI_SP1_HF01_B009_3rdSept2020.sql Note:
| DENALI 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 Denali SP1 HF01 to Denali SP1 HF02
To perform the database upgrade from Denali SP1 HF01 to Denali SP1 HF02, do the following:
Schema Version | Upgrade Script | Upgraded Schema Version |
DENALI SP1 HF01 | 14.Summitupgrade_DENALI_SP1_HF01_B009_3rdSept2020_to_DENALI_SP1_HF02_B005_1stOct2020.sql Note:
| DENALI 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 Denali SP1 HF02 to Denali SP1 HF03
To perform the database upgrade from Denali SP1 HF02 to Denali SP1 HF03, do the following:
Schema Version | Upgrade Script | Upgraded Schema Version |
DENALI SP1 HF02 | 15.Summitupgrade_DENALI_SP1_HF02_B005_1stOct2020_to_DENALI_SP1_HF03_B003_30thOct2020.sql Note:
| DENALI 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 Denali SP1 HF03 to Denali SP1 HF04
To perform the database upgrade from Denali SP1 HF03 to Denali SP1 HF04, do the following:
Schema Version | Upgrade Script | Upgraded Schema Version |
DENALI SP1 HF03 | 16.Summitupgrade_DENALI_SP1_HF03_B003_30thOct2020_to_DENALI_SP1_HF04_B005_11thDec2020.sql Note:
| DENALI 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 Denali SP1 HF04 to Denali SP1 HF05
To perform the database upgrade from Denali SP1 HF04 to Denali SP1 HF05, do the following:
Schema Version | Upgrade Script | Upgraded Schema Version |
DENALI SP1 HF04 | 17.Summitupgrade_DENALI_SP1_HF04_B005_11thDec2020_to_DENALI_SP1_HF05_B003_1stFeb2021.sql Note:
| DENALI 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 Denali SP1 HF05 to Denali SP1 HF06
To perform the database upgrade from Denali SP1 HF05 to Denali SP1 HF06, do the following:
Schema Version | Upgrade Script | Upgraded Schema Version |
DENALI SP1 HF05 | 18.Summitupgrade_DENALI_SP1_HF05_B003_1stFeb2021_to_DENALI_SP1_HF06_B003_01stMarch2021.sql Note:
| DENALI 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 Denali SP1 HF06 to Denali SP1 HF07
To perform the database upgrade from Denali SP1 HF06 to Denali SP1 HF07, do the following:
Schema Version | Upgrade Script | Upgraded Schema Version |
DENALI SP1 HF06 | 19.Summitupgrade_DENALI_SP1_HF06_B003_1stMarch2021_to_DENALI_SP1_HF07_B003_31stMarch2021.sql Note:
| DENALI 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 Denali SP1 HF07 to Denali SP1 HF08
To perform the database upgrade from Denali SP1 HF07 to Denali SP1 HF08, do the following:
Schema Version | Upgrade Script | Upgraded Schema Version |
DENALI SP1 HF07 | 20.Summitupgrade_DENALI_SP1_HF07_B003_31stMar2021_to_DENALI_SP1_HF08_B004_1stMay2021 Note: · The upgrade steps Denali HF09, Sierra SP1 HF14, and Alps SP1 HF20 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 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 Denali SP1 HF08 to Denali SP1 HF09
To perform the database upgrade from Denali SP1 HF08 to Denali SP1 HF09, do the following:
Schema Version | Upgrade Script | Upgraded Schema Version |
DENALI SP1 HF08 | 21.Summitupgrade_ DENALI_SP1_HF08_B004_1stMay2021_to_DENALI_SP1_HF09_31stMay2021 Note: · The upgrade steps of Sierra SP1 HF15 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 SP1 HF09 |
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 SP1 HF09 to Denali SP1 HF10
To perform the database upgrade from Denali SP1 HF09 to Denali SP1 HF10, do the following:
Schema Version | Upgrade Script | Upgraded Schema Version |
DENALI SP1 HF09 | 22.Summitupgrade_ DENALI_SP1_HF09_B004_31stMay2021_to_DENALI_SP1_HF10_B004_30thJune2021 Note: · The upgrade steps of 5.7SP5 HF01, ALPS SP1 HF21, SIERRA SP1 HF16, and DENALI HF10 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 SP1 HF10 |
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 SP1 HF10 to Denali SP1 HF11
To perform the database upgrade from Denali SP1 HF10 to Denali SP1 HF11, do the following:
Schema Version | Upgrade Script | Upgraded Schema Version |
DENALI SP1 HF10 | 23.Summitupgrade_DENALI_SP1_HF10_B003_30thJune2021_to_DENALI_SP1_HF11_B004_4thAug2021 Note: · The upgrade steps of ALPS SP1 HF22 and SIERRA SP1 HF17 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 SP1 HF11 |
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 SP1 HF11 to Denali SP1 HF12
To perform the database upgrade from Denali SP1 HF11 to Denali SP1 HF12, do the following:
Schema Version | Upgrade Script | Upgraded Schema Version |
DENALI SP1 HF11 | 24.Summitupgrade_DENALI_SP1_HF11_B004_4thAug2021_to_DENALI_SP1_HF12_B005_1stSep2021 Note: · The upgrade steps of ALPS SP1 HF23, SIERRA SP1 HF18, and DENALI HF11 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 SP1 HF12 |
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 SP1 HF12 to Denali SP1 HF13
To perform the database upgrade from Denali SP1 HF12 to Denali SP1 HF13, do the following:
Schema Version | Upgrade Script | Upgraded Schema Version |
DENALI SP1 HF12 | 25.Summitupgrade_DENALI_SP1_HF12_B005_1stSep2021_to_DENALI_SP1_HF13_B004_1stOct2021 Note: · The upgrade steps of v5.7 SP5 HF22, ALPS SP1 HF24, Sierra SP1 HF19 and DENALI HF12 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 SP1 HF13 |
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 SP1 HF13 to Denali SP1 HF14
To perform the database upgrade from Denali SP1 HF13 to Denali SP1 HF14, do the following:
Schema Version | Upgrade Script | Upgraded Schema Version |
DENALI SP1 HF13 | 26.Summitupgrade_DENALI_SP1_HF13_B004_1stOct2021_to_DENALI_SP1_HF14_B003_30thOct2021 Note: · The upgrade steps of Sierra SP1 HF20 and DENALI HF13 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 SP1 HF14 |
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 SP1 HF14 to Denali SP1 HF15
To perform the database upgrade from Denali SP1 HF14 to Denali SP1 HF15, do the following:
Schema Version | Upgrade Script | Upgraded Schema Version |
DENALI SP1 HF14 | 27.Summitupgrade_DENALI_SP1_HF14_B003_30thOct2021_to_DENALI_SP1_HF15_B003_2ndDec2021 Note: · The upgrade steps of ALPS SP1 HF25, Sierra SP1 HF21, and DENALI HF14 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 SP1 HF15 |
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 SP1 HF15 to Denali SP1 HF16
To perform the database upgrade from Denali SP1 HF15 to Denali SP1 HF16, do the following:
Schema Version | Upgrade Script | Upgraded Schema Version |
DENALI SP1 HF15 | 28.Summitupgrade_DENALI_SP1_HF15_B003_2ndDec2021_to_DENALI_SP1_HF16_B002_31stJan2022 Note: · The upgrade steps of ALPS SP1 HF26, Sierra SP1 HF22, DENALI HF15 and Tahoe SP1 HF02 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 SP1 HF16 |
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 SP1 HF16 to Denali SP1 HF17
To perform the database upgrade from Denali SP1 HF16 to Denali SP1 HF17, do the following:
Schema Version | Upgrade Script | Upgraded Schema Version |
DENALI SP1 HF16 | 29.Summitupgrade_DENALI_SP1_HF16_B002_31stJan2022_to_DENALI_SP1_HF17_B002_2ndMar2022 Note: · The upgrade steps of Sierra SP1 HF23, Denali HF16 and Denali SP1 HF15 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 SP1 HF17 |
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 SP1 HF17 to Denali SP1 HF18
To perform the database upgrade from Denali SP1 HF17 to Denali SP1 HF18, do the following:
Schema Version | Upgrade Script | Upgraded Schema Version |
DENALI SP1 HF17 | 30.Summitupgrade_DENALI_SP1_HF17_B002_2ndMar2022_to_DENALI_SP1_HF18_B003_31stMar2022 Note: · The upgrade steps of Alps SP1 HF27 and Sierra SP1 HF24 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 SP1 HF18 |
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 SP1 HF18 to Denali SP1 HF19
To perform the database upgrade from Denali SP1 HF18 to Denali SP1 HF19, do the following:
Schema Version | Upgrade Script | Upgraded Schema Version |
DENALI SP1 HF18 | 31.Summitupgrade_DENALI_SP1_HF18_B003_31stMar2022_to_DENALI_SP1_HF19_B002_10thMay2022 Note: · The upgrade steps of Sierra SP1 HF25 and Denali HF17 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 SP1 HF19 |
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 SP1 HF19 to Denali SP1 HF20
To perform the database upgrade from Denali SP1 HF19 to Denali SP1 HF20, do the following:
Schema Version | Upgrade Script | Upgraded Schema Version |
DENALI SP1 HF19 | 32.Summitupgrade_DENALI_SP1_HF19_B002_10thMay2022_to_DENALI_SP1_HF20_B002_1stJune2022 Note: · The upgrade steps of Sierra SP1 HF26 and Denali HF18 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 SP1 HF20 |
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 SP1 HF20 to Denali SP1 HF21
To perform the database upgrade from Denali SP1 HF20 to Denali SP1 HF21, do the following:
Schema Version | Upgrade Script | Upgraded Schema Version |
DENALI SP1 HF20 | 33.Summitupgrade_DENALI_SP1_HF20_B002_1stJune2022_to_DENALI_SP1_HF21_B004_26thAugust2022 Note: · The upgrade steps of Sierra SP1 HF27, Sierra SP1 HF28, Denali HF19, and Denali HF20 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 SP1 HF21 |
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 SP1 HF21 to Denali SP1 HF22
To perform the database upgrade from Denali SP1 HF21 to Denali SP1 HF22, do the following:
Schema Version | Upgrade Script | Upgraded Schema Version |
DENALI SP1 HF21 | 34.Summitupgrade_DENALI_SP1_HF21_B004_26thAugust2022_to_DENALI_SP1_HF22_B002_30thSep2022 Note: · The upgrade steps of Sierra SP1 HF29 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. | DENALI SP1 HF22 |
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 in BI Report and Global Search
To perform the database upgrade in BI Report and Global Search script, do the following:
Schema Version | Upgrade Script | Upgraded Schema Version |
BI-Report and Global Search | 35.SummitMigrationscripts_enable_BIReport_GlobalSearch 1. De-normalization Process Steps.doc – Refer DN Process documents and how-to setup the Linked Server configurations. 2. DN_Scripts-ONLY_FOR_NEW_IMPLE_NotUpgrade Note: The DN_Scripts.sql is only executed for new implementation not for the upgrade. 3. Upgrade_Scripts_Till_DENALI SP1 HF22 Post DENALI, you can run this script to upgrade the DN schemas. Notes: • Drop the dependent index completely if there is an error while dropping the column. • While altering the column type or length, take the backup of dependent index and drop. After executing the alter command, recreate the index. 4. DB_Server_Configuration_LoadData Follow mentioned steps, in case change in DN configuration 5. Views.sql 6. PostScripts.sql Note: · To enable the BI Configuration, follow the steps given in the DeNormalization Process Steps document. · Denormalization: If the SR_RPT_DN_ServcieTicketMaster contains around 1.5 lacks records, the post-deployment script runs approximately 3 minutes to update old records for [Resolved Updated By ****] columns. Based on the volume of the records and index, the actual execution time may vary. SummitAI Global Search (Mandatory) · Global Search_Configuration_Linked Server Environment.docx · SummitSearch_FullTextEnabled_GlobalSearch_index_Script · SummitSearch_FullTextEnabled_GlobalSearch_index_Script_DN · Enable outbound transaction for Linked Server.docx · BI Report-Emails & Scheduling (Pushreport).docx
Note: · For the customer who has DN database only, they need to run SummitSearch_FullTextEnabled_GlobalSearch_index_Script_DN script only. · The scripts written in the Global Search_Configuration_Linked Server Environment document are for reference purpose only. Ensure that you execute SummitSearch_FullTextEnabledTable_Script_LinkedServer.sql. · To enable the Summit Global Search, follow the steps given in Global Search_Configuration_Linked Server Environment document. · To access BI report related pages, the user needs to update the SummitAI license. For more details, see Enhancement on ROLE TEMPLATE feature in v5.5 SP1 B005 RN. WithGDPR_Enablescripts 01. DN_Enable_GDPRChanges.sql Run this script in case GDPR is enabled for the client Enable BI Reports (Denali SP1) 01.EnableBI_Reports script Note: For installing BI Reports (Denali SP1), please contact SummitAI Support and Implementation team. | DENALI SP1 HF22 |
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\
Installing PsExec Tool
SummitAI uses Microsoft PsExec tool to perform the following activities:
- SummitAI IT Operations Management: MS Exchange Monitoring
- Asset Management: Remote Software Delivery
- Incident Management: Service Assist
Ensure to install the PsExec tool on the SummitAI Server, if it does not already exist.
Download link: http://technet.microsoft.com/en-us/sysinternals/bb897553
Place the downloaded psexec.exe file under the following SummitAI installer folder:
..\\Bin\TOOLS\PS\psexec.exe
Example: c:\Inetpub\wwwroot\SummitWeb\Bin\TOOLS\PS\psexec.exe
Post Installation Steps
Post installation of the SummitAI application setup, Izenda API Physical Path manually configured to the proper path. Physical Path: <Installation Directory>\API\Izenda7\
Note:
The APIs for the various modules, Incident, IT Operations, Asset, and BI Reports (Sierra) are part of the SummitAI Application setup.
Oracle and IBM Client Configuration
The Oracle and IBM client configurations are done to monitor the Oracle and IBM databases, respectively.
Oracle Client Configuration
To configure Oracle client, perform the following:
- Open the URL http://www.oracle.com/technetwork/database/windows/downloads/utilsoft-087491.html. Alternatively, you can open the URL http://symphonysummit.blob.core.windows.net/customer-build/ODAC1120320Xcopy_32bit.zip.
- Download the ODAC component ODAC1120320Xcopy_32bit.zip.
- Extract the .zip folder to the <<drive>>:\extracted folder.
- Run the command, cd “C:\ SummitAI \ODAC1120320Xcopy_32bit”, to change directory to the extracted folder, cd <<drive>>:\extracted folder.
- Run the command, install.bat odp.net20 c:\oracle\11.2\odac odac11, to install Oracle Data Access Components.
- Add the following paths of the installed ODAC components in the Environment Variables of the system:
- C:\oracle\11.2\odac
- C:\oracle\11.2\odac\bin
To add these paths in the Environment Variables, perform the following:
- Click Start, right-click Computer, and then click Properties.
- On the left side of the Control Panel, click Advanced system settings. The System Properties pop-up page is displayed.
- On the System Properties pop-up page, click the Environment Variables button under the Advanced tab. The Environment Variables pop-up page is displayed.
- On the Environment Variables pop-up page, in the System variable section, double-click the variable, Path, to edit it.
- On the Edit System Variable pop-up page, in the Variable value field, add the text, C:\oracle\11.2\odac;C:\oracle\11.2\odac\bin, at the beginning of the existing text, and then click OK.
- Restart your system.
IBM Client Configuration
To configure the IBM client, perform the following steps:
- Open the URL http://www-01.ibm.com/support/docview.wss?rs=4020&uid=swg21385217. Alternatively, you can open the URL https://symphonysummit.blob.core.windows.net/prerequisites/ibm_data_server_client_winx64_v11.1.zip.
- On the following page, click IBM Data Server Client.
- In the IBM Data Server Client section, select IBM Data Server Client (Windows AMD64 and Intel EM64T) option, and then click Continue.
- Fill in the required details, and then click I confirm.
- The .exe file is downloaded. You can install the file to connect to the IBM Database Server.
Online Help Upgrade
While upgrading from earlier version of SUMMIT to v5.7 SP1 HF01, perform the following steps for Online Help configuration:
Delete the existing Online Help folder (~/Webfiles/OnlineHelp) and add new Online Help folder from 5.7 SP1 HF01 upgrade files.
BI Reports
While upgrading from earlier version of SummitAI to v5.7 SP1 HF01, perform the following steps for BI report configuration:
- Add the below tag in web.config file and remove the Izenda.config file from (~/Webfiles/) <add key="Izenda:LicenseKey" value="T370 Symphony Summit +DASH +MAPS +LANG +FORMS +VISION+FUSION|Enterprise|6.8|09/30/2016|0|0|0|M|YG6YSZE"/>
- Delete the existing Reporting folder(~/Webfiles/Reporting) and add new Reporting folder from 5.7 SP1 HF01 upgrade files
- Update the SMTP configuration details in web.config instead of izenda.config
Maximum File Size for Attachments
The default maximum file attachment size is 4 MB. This value can be configured using the following keys in the web.config file:
<add key="All:MaxAttachmentSize" value="4" />
However, it is recommended to keep the maximum file size limit to 8 MB for best system performance.
Reference Documents
SummitAI IT Management Suite document library comprises the following list of documents:
- SummitAI Service Management Online Help (Denali SP1)
- SummitAI Asset Management Online Help (Denali SP1)
- SummitAI IT Operations Management Online Help (Denali SP1)
- SummitAI Platform Online Help (Denali SP1)
- SummitAI Procurement Online Help (Denali SP1)
- SummitAI Installation Guide (Denali SP1)
- SummitAI Proxy Agent Installation Guide (Denali SP1)
- SummitAI IT Operations Management Monitoring Parameters List (Denali SP1)
For all other documents, please contact the SummitAI Support Team.
Support
If you need any technical assistance from the SummitAI Support Team, contact at:
https://support.symphonysummit.com/ or e-mail to summitsupport@symphonysummit.com.
Confluence Cloud Migration Alert: Please refer to known issues you may encounter in Confluence Cloud: https://eitdocs.atlassian.net/wiki/x/wDGwAQ