Deployment Procedure

Contents

Introduction

This deployment procedure applies to the 8.0.001.10 Hot Fix release of Genesys Info Mart, released 12/10/10. It describes how to deploy Genesys Info Mart using the package you received from Genesys.

Deployment Procedure – Hot Fix [12/10/10]

To deploy this installation package within a new environment, follow the instructions in the Genesys Info Mart 8.0 Deployment Guide.

To deploy this package in an existing Genesys Info Mart 8.0.000.73 environment, follow all of the Pre-Installation and Installation steps in this Deployment Procedure.

To deploy this package in an existing Genesys Info Mart an 8.0.001.05 environment, follow all of the Pre-Installation steps and Installation Steps 1, 3, and 5. To upgrade from v8.0.001.05 to v8.0.001.10, you need not run Job_MigrateGIM.

Notes:

• Review all steps before you perform any of them.

• Plan a time when you can complete the installation in one continuous session. Several steps can take significant time to complete, and this potentially affects the availability of Info Mart data.

Pre-Installation Steps

1. Set the run-scheduler configuration option to FALSE in the schedule section of the Genesys Info Mart Application object to temporarily stop Genesys Info Mart Server from launching ETL jobs.

2. Wait for any currently running jobs to finish. Use the Genesys Info Mart Administration Console to monitor the completion of the jobs.

3. Stop the Genesys Info Mart Server.

4. Create a backup copy of your Info Mart database.

5. For reference purposes, create backup copies of the Genesys Info Mart deployment SQL scripts that you modified and ran when you last deployed Genesys Info Mart. The new Genesys Info Mart installation program overwrites these SQL scripts, and does not preserve your modifications.

To locate these SQL scripts, navigate to the Genesys Info Mart installation directory, then navigate to its sql_scripts directory. The SQL scripts are in the RDBMS-specific subdirectory: mssql and oracle.

6. Make a note of the application startup arguments if you customized them. The installation process will overwrite these arguments and you will lose any changes that you made.

Installation Steps

1. Install the new Genesys Info Mart installation package:

• On a Microsoft Windows operating system, uninstall the current Genesys Info Mart installation package using the Windows Control Panel > Add/Remove Programs. Then run setup to install the new Genesys Info Mart installation package.

2. For each IDB from which Genesys Info Mart will extract ICON details, run the appropriate Genesys Info Mart–provided SQL scripts—located in the <GIM root>/sql_scripts/<dbms> folder—to add to each IDB the views and indexes that Genesys Info Mart requires.

   • For a Voice details IDB, use migrate_idb_for_gim.sql.
   • For a Multimedia details IDB, use migrate_idb_for_gim_mm.sql..
   • For a Configuration details or an Outbound Contact details IDB, use either migrate_idb_for_gim.sql or migrate_idb_for_gim_mm.sql..

   Note: If the scripts do not complete correctly, restore the IDBs from the backup copies and the rerun the scripts before proceeding with Installation Step 3.

3. Restart the Genesys Info Mart Server; after this restart, Genesys Info Mart Server will be in the correct state to perform the migration.

4. Update the Info Mart database by launching Job_MigrateGIM from the Genesys Info Mart Administration Console v8.0.001.01 or higher. To do so, perform the following steps:

   1. Open the Administration Console window.
   2. Select the Schedule tab.
   3. Click Run Job….
   4. From the menu that opens, select Job_MigrateGIM.

   Allow this job to complete before continuing.

   Note: If Job_MigrateGIM does not complete successfully, do the following steps:

   1. Stop Genesys Info Mart Server.
   2. Restore the Genesys Info Mart database from the backup copy and then continue, starting from Step 3, above.
5. Set the run-scheduler configuration option to TRUE in the schedule section of the Genesys Info Mart Application object to resume the Genesys Info Mart Server schedule.

Top of Page

Additional Information

Additional information on Genesys Telecommunications Laboratories, Inc. is available on our Technical Support website. The following documentation also contains information about this software.

• Genesys Info Mart 8.0 Release Advisory provides important information that applies to the entire Genesys Info Mart release.

• Genesys Info Mart 8.0 Deployment Guide includes installation procedures for the Genesys Info Mart Administration Console and Genesys Info Mart and acquaints you with their functions.

• Genesys Info Mart 8.0 Operations Guide describes the procedures for using the Genesys Info Mart Administration Console to monitor ETL job status and, when necessary, to start or stop an ETL job outside of the normal schedule.

• Genesys Info Mart 8.0 Reference Manual for your RDBMS acquaints you with the subject areas, tables, and fields that make up the Genesys Info Mart star schemas.

• Genesys Info Mart 8.0 User's Guide provides examples of common voice and multimedia interactions.

• The Genesys Info Mart section of the Framework 8.0 Combined Log Events Help provides detailed information on the log events associated with Genesys Info Mart.

If you encounter any issues with the deployment of this package, please contact Genesys Technical Support.

Top of Page