Reporting and Analytics Aggregates Release Notes
|Release Date||Release Type||Restrictions||AIX||Linux||Solaris||Windows|
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.
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
Refer to the Deployment Procedure for this release to deploy the installation package within your environment.