8.5.001.23

Reporting and Analytics Aggregates Release Notes

Release Date	Release Type	Restrictions	AIX	Linux	Solaris	Windows
12/07/16	General		X	X	X	X

Helpful Links

Releases Info

• List of 8.5.x Releases
• 8.5.x Known Issues

Deployment Procedure

8.5.0 Deployment Procedure

Product Documentation

Reporting and Analytics Aggregates

Genesys Products

List of Release Notes

What's New

This release contains the following new features and enhancements:

• Support for Microsoft SQL Server Standard Edition:
  • Microsoft SQL deployments of RAA require Microsoft SQL Server 2008 R2 or later. See the Supported Operating Environment: Genesys Info Mart page for more detailed information and a list of all supported databases.
  • RAA now supports migration from old table storage layout (AG2_* tables) to new table storage layout (AGT_* tables and AG2_* views) on deployments with Microsoft SQL Server Standard Edition.
• A new column, DESIRED_TS_TIME, is added to the CALLBACK_FACT_GI2 table, and is used to record the desired callback time (TIMESTAMP).
• RAA has changed the way it queries the Genesys Info Mart PostgreSQL database on partitioned deployments; an additional WHERE clause (<table alias>.START_DATE_TIME_KEY BETWEEN <integer> AND <integer>) is added to allow PostgreSQL to optimize partition scans.

  ---

Resolved Issues

This release contains the following resolved issues:

---

Query hints are now added on Genesys Info Mart deployments with a non-partitioned Oracle database. Previously on Oracle deployments, query hints were applied only if the database was partitioned, and only if the option partitioned-gim in the agg-feature section was set. (GII-6006)

---

On PostgreSQL deployments, RAA now automatically sets the partition-gim option, which causes the partition-kit to be automatically applied on PostgreSQL. Genesys Info Mart always uses a partitioned schema on PostgreSQL deployments. On PostgreSQL deployments, the file partition-kit.ss is now ignored. (GII-6001)

---

On PostgreSQL deployments, RAA now creates larger partitions (35 days) for AGT tables. Previously, RAA created smaller partitions, which sometimes impacted performance. (GII-5999)

---

During RAA upgrade, the ms-sql-std-edition feature is now added correctly. Previously, when migrating from old table storage layout (AG2_* tables) to new table storage layout (AGT_* tables and AG2_* views) on some MSSQL standard edition deployments with more than one time zone, the upgrade could fail. (GII-5995)

---

In scenarios where an agent initiates a consultation call, and later releases the consultation, but does not release the call with the customer, RAA no longer reports the interaction as AGENT_DISCONNECT_FIRST. (GII-5988)

---

RAA storage migration now completes successfully. Previously, in some migration scenarios involving migrating RAA storage or splitting storage by media type, RAA failed with the following exception:

java.lang.SecurityException: class "com.microsoft.sqlserver.jdbc.ISQLServerConnection$$EnhancerByCGLIB$$e13d34c0"'s signer information does not match signer information of other classes in the same package

(GII-5969)

---

Upgrade Notes

Refer to the Deployment Procedure for this release to deploy the installation package within your environment.