This deployment procedure applies to the 7.6.100.24 Hot Fix release of Interaction Concentrator, released 07/24/09. It describes how to deploy Interaction Concentrator using the package you received from Genesys via FTP.
To deploy this installation package within a new environment, follow the instructions in the Interaction Concentrator 7.6 Deployment Guide—but be sure to execute all the scripts listed in the Database Scripts section below.
To deploy the package within your existing 7.6.x or 7.5.x Interaction Concentrator environment, perform the following steps:
Create a backup of your attached-data configuration file.
You can locate this file, by default named ccon_adata_spec.xml
,
in the directory where Interaction Concentrator (ICON) is
installed.
Note: If you have customized the gudCustDISP1
or gudCustDISP2
dispatcher stored procedures and saved them with the default (Genesys-provided) names, back up the procedures and restore them after the upgrade.
Depending on your current environment, do one of the following:
If you are upgrading ICON in an environment with Genesys
Info Mart, and Genesys Info Mart has already been extracting
data from the Interaction Concentrator database (IDB)
into which the existing ICON application stores data,
do not create a new ICON Application
object
in the Configuration Layer. Instead, use the existing
ICON Application
object. Refer to the Genesys
Info Mart 7.6 Operations Guide for more information.
If you are upgrading from 7.5.x release of ICON in an environment without Genesys Info Mart:
Import the application template for ICON 7.6.x.
Create and configure a new ICON 7.6.x Application
object.
If you are upgrading from 7.6.x release of ICON in
an environment without Genesys Info Mart, you do not
have to make any changes to your ICON 7.6.x Application
object. Note, however, that you must add the new configuration
option, gls-active-reason-codes,
and set
its value to true
if you want to implement
the active Agent reason codes feature introduced in
ICON release 7.6.100.19.
Run the setup file (install.sh
or setup.exe
) provided in your installation package.
Use Genesys Solution Control Interface to stop ICON, if it is running.
Note: The content of the persistent queue file (icon_**.pq
) will be lost as a result of the upgrade. Do not back up the persistent queue file. To minimize the loss of data, perform the upgrade when the contact center load is minimal.
(Optional) Back up IDB. Genesys recommends backing up IDB, but only if it is feasible to do so without prolonging the service interruption to an unacceptable extent. Backing up a very large IDB (while ICON is stopped) may interrupt data collection for a long period of time.
Using the database scripts created as a result of the installation, upgrade IDB as described in the Database Scripts section.
Restore the attached-data configuration file:
If necessary, update the attached-data configuration file (from Step 1) as required to implement the new functionality provided by ICON 7.6. For more information, see the chapter about attached data in the Interaction Concentrator 7.6 User�s Guide.
Copy your file to replace the one in the folder where you deployed ICON 7.6.100.24.
Use Genesys Solution Control Interface to start ICON.
Verify that ICON 7.6.100.24 runs properly by checking the log for errors.
If you have multiple ICON applications, repeat this procedure for each instance.
If deploying this installation package within a new environment, note that the database initialization procedure differs from the one that is described in the Interaction Concentrator 7.6 Deployment Guide.
Use the table and instructions in this section to either initialize or upgrade Interaction Database:
For a new deployment, execute the scripts in the order specified in the New Install. Order column.
For an upgrade from a previous ICON release, execute the scripts in the order specified in the Upgrade Order column for your particular release.
Note: In the table, the abbreviation N/A indicates that a given script is not applicable to (should not be executed for) a given release.
Script Name | New Install. Order | 7.5.000.12 Upgrade Order | 7.5.000.16 Upgrade Order | 7.5.000.17 Upgrade Order | 7.5.000.18 Upgrade Order | 7.5.000.19 Upgrade Order | 7.5.000.22 Upgrade Order | 7.5.000.23 Upgrade Order | 7.5.000.24 Upgrade Order | 7.5.000.25 Upgrade Order | 7.5.000.26 Upgrade Order | 7.6.000.16 Upgrade Order | 7.6.000.18 Upgrade Order | 7.6.000.20 Upgrade Order | 7.6.000.21 Upgrade Order | 7.6.100.10 Upgrade Order | 7.6.100.12 Upgrade Order | 7.6.100.14 Upgrade Order | 7.6.100.18 |
7.6.100.19 Upgrade Order |
7.6.100.23 Upgrade Order |
Script Description | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
01_gcc_<db_type>_schema.sql | 1 | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | Creates the core IDB tables and indexes. | |
02_gos_<db_type>_schema.sql | 2 | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | Upgrades the IDB schema to include the Outbound data tables. | |
03_gcc_<db_type>stp_api.sql | 3 | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | Creates core stored procedures. | |
04_gcc_<db_type>_schema_2.sql | 4 | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | Upgrades the IDB schema to include the G_VIRTUAL_QUEUE
table. |
|
05_gcc_<db_type>stp_api_2.sql | 5 | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | Creates stored procedures that associate calls with Virtual Queues. | |
06_gcc_<db_type>_schema_3.sql | 6 | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | Upgrades the IDB schema to include custom-state tables. | |
07_gcc_<db_type>_idx_change_3.sql | 7 | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | Creates indexes to various IDB tables. | |
08_mcr_<db_type>_schema.sql | 8 | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | Upgrades the IDB schema to include the Multimedia user data tables. | |
09_gcc_<db_type>_stp_api_3.sql | 9 | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | Creates stored procedures related to call control, login sessions, and user data. | |
10_gcc_<db_type>_stp_sys_3.sql | 10 | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | Creates special (service) stored procedures. | |
11_gcc_<db_type>_idx_change_5.sql | 11 | 1 | 1 | 1 | 1 | 1 | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | Creates indexes to various IDB tables. | |
12_gcc_<db_type>_stp_api_4.sql | 12 | 2 | 2 | 2 | 2 | 2 | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | Upgrades stored procedures for configuration data tracking. | |
13_gcc_<db_type>_svc_change_5.sql | 13 | 3 | 3 | 3 | 3 | 3 | 1 | 1 | 1 | 1 | 1 | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | Creates and/or modifies additional special (service) stored procedures. | |
14_gcc_<db_type>_stp_api_5.sql | 14 | 4 | 4 | 4 | 4 | 4 | 2 | 2 | 2 | 2 | 2 | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | Upgrades stored procedures for open media data tracking. | |
15_gcc_<db_type>_stp_sys_5.sql | 15 | 5 | 5 | 5 | 5 | 5 | 3 | 3 | 3 | 3 | 3 | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | Upgrades special (service) stored procedures. | |
16_gcc_<db_type>_stp_api_6.sql | 16 | 6 | 6 | 6 | 6 | 6 | 4 | 4 | 4 | 4 | 4 | 1 | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | Upgrades stored procedures for user data tracking. | |
17_gcc_<db_type>_idx_change_6.sql | 17 | 7 | 7 | 7 | 7 | 7 | 5 | 5 | 5 | 5 | 5 | 2 | 1 | 1 | 1 | N/A | N/A | N/A | N/A | N/A | N/A | Creates index for G_PARTY IDB table. |
|
18_gcc_<db_type>_stp_api_7.sql | 18 | 8 | 8 | 8 | 8 | 8 | 6 | 6 | 6 | 6 | 6 | 3 | 2 | 2 | 2 | N/A | N/A | N/A | N/A | N/A | N/A | Creates stored procedures related to call control, configuration data, and user data tracking. | |
19_gcc_<db_type>_stp_sys_7.sql | 19 | 9 | 9 | 9 | 9 | 9 | 7 | 7 | 7 | 7 | 7 | 4 | 3 | 3 | 3 | N/A | N/A | N/A | N/A | N/A | N/A | Upgrades the merge procedure. | |
20_gcc_<db_type>_disp.sql | 20 | 10 | 10 | 10 | 10 | 10 | 8 | 8 | 8 | 8 | 8 | 5 | 4 | 4 | 4 | N/A | N/A | N/A | N/A | N/A | N/A | Creates stored procedures for event dispatcher functionality for gud and cfg roles. | |
21_gcc_<db_type>_schema_4.sql | 21 | 11 | 11 | 11 | 11 | 11 | 9 | 9 | 9 | 9 | 9 | 6 | 5 | 5 | 5 | 1 | 1 | 1 | N/A | N/A | N/A | Creates the table to store active Agent state reason codes. | |
22_gcc_<db_type>_stp_api_8.sql | 22 | 12 | 12 | 12 | 12 | 12 | 10 | 10 | 10 | 10 | 10 | 7 | 6 | 6 | 6 | 2 | 2 | 2 | N/A | N/A | N/A | Creates stored procedures to store active Agent state reason codes and Agent state reason codes. | |
23_gcc_<dbtype>_disp3.sql | 23 | 13 | 13 | 13 | 13 | 13 | 11 | 11 | 11 | 11 | 11 | 8 | 7 | 7 | 7 | 3 | 3 | 3 | N/A | N/A | N/A | Creates stored procedures for event dispatcher functionality for gls. | |
24_gcc_<db_type>_stp_api_9.sql | 24 | 14 | 14 | 14 | 14 | 14 | 12 | 12 | 12 | 12 | 12 | 9 | 8 | 8 | 8 | 4 | 4 | 4 | 1 | 1 | N/A | Creates stored procedure to mark IS Link as failed. | |
25_gcc_<db_type>_disp1.sql | 25 | 15 | 15 | 15 | 15 | 15 | 13 | 13 | 13 | 13 | 13 | 10 | 9 | 9 | 9 | 5 | 5 | 5 | 2 | 2 | N/A | Creates stored procedures for event-dispatcher functionality. | |
26_gcc_<db_type>_dict.sql | 26 | 16 | 16 | 16 | 16 | 16 | 14 | 14 | 14 | 14 | 14 | 11 | 10 | 10 | 10 | 6 | 6 | 6 | 3 | 3 | N/A | Populates the dictionary tables with metadata. | |
27_gcc_<db_type>_stp_api_10.sql | 27 | 17 | 17 | 17 | 17 | 17 | 15 | 15 | 15 | 15 | 15 | 12 | 11 | 11 | 11 | 7 | 7 | 7 | 4 | 4 | N/A | Creates stored procedure to store userdata in GM_F_USERDATA table. | |
28_gcc_<db_type>_disp2.sql | 28 | 18 | 18 | 18 | 18 | 18 | 16 | 16 | 16 | 16 | 16 | 13 | 12 | 12 | 12 | 8 | 8 | 8 | 5 | 5 | N/A | Creates stored procedures for event dispatcher functionality for gud. | |
29_gcc_<db_type>_version.sql | 29 | 19 | 19 | 19 | 19 | 19 | 17 | 17 | 17 | 17 | 17 | 14 | 13 | 13 | 13 | 9 | 9 | 9 | 6 | 6 | N/A | Updates the version of the IDB schema. | |
gcc_<db_type>_clean_init.sql | 30 | 20 | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | Creates tables and indexes in IDB to clean up (purge) the database. | |
gcc_<db_type>_clean_upgrade.sql | N/A | N/A | 20 | 20 | 20 | 20 | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | Updates tables and indexes in IDB to clean up (purge) the database. | |
gcc_<db_type>_clean_api.sql | 31 | 21 | 21 | 21 | 21 | 21 | 18 | 18 | 18 | 18 | 18 | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | Creates stored procedures to purge IDB. | |
purge_gcc_<db_type>_proc.sql | 32 | 22 | 22 | 22 | 22 | 22 | 19 | 19 | 19 | 19 | 19 | 15 | 14 | 14 | 14 | N/A | N/A | N/A | N/A | N/A | N/A | Creates service table and stored procedures for 7.6.1 purge
IDB procedure (gsysPurge76 ). |
Additional information on Genesys Telecommunications Laboratories, Inc. is available on our Technical Support website. The following documentation also contains information about this software. Please consult the Deployment Guide first.
Interaction Concentrator 7.6 Deployment Guide provides a high-level overview of Interaction Concentrator, deployment-planning materials, and deployment procedures.
Interaction Concentrator 7.6 User�s Guide provides information about Interaction Concentrator functionality, including IDB architecture, models used in Interaction Concentrator, attached data processing, available stored procedures, and integration with other Genesys products.
Interaction Concentrator 7.6 Physical Data Model for each supported RDBMS provides database schema with table and field descriptions for a particular IDB.
Framework 7.6 Combined Log Events Help describes log events generated by every Genesys server application, including Interaction Concentrator.
If you encounter any issues with the deployment of this package, please contact Genesys Technical Support.