Release Note

Data Mart

8.0.x

Genesys Telecommunications Laboratories, Inc. © 2014

Contents

Introduction

Release Number AIX HP-UX IPF Linux Solaris Windows
8.0.100.08 [02/04/2014] – General X X X X X

Link to 7.6 Product Release Note (Cumulative)
Link to All Genesys Release Notes
Known Issues and Recommendations
Discontinued Support
Internationalization
Additional Information


Introduction

As of February 1, 2012, Genesys is no longer an affiliate of Alcatel-Lucent; any indication of such affiliation within Genesys products or packaging is no longer applicable. Please see the Genesys website at http://www.genesys.com for more details.

This release note applies to all 8.0 releases of Data Mart.

Use of Third-Party Software

Genesys follows applicable third-party redistribution policies to the extent that Genesys solutions utilize third-party functionality. For additional information about third-party software used in this product, see the Read Me. Please contact your Genesys Customer Care representative if you have any questions.


Release Number 8.0.100.08 [02/04/2014] – General

Supported Operating Systems
New in This Release
Corrections and Modifications

Supported Operating Systems

The operating systems supported by this release are listed in the Contents, above.

New in This Release

There are no restrictions for this release. Refer to the Deployment Procedure for this release to deploy the installation package within your environment.

This section describes new features that were introduced in the initial 8.0 release of Data Mart.

Corrections and Modifications

This release includes the following corrections and modifications that were made between Release 7.6 releases and the initial 8.0 release:


ETL Service Starter no longer stops unexpectedly when simultaneously writing messages from a subprocess and its own messages to the log. (CCA-2039, CCA-1983)


ETL Service Starter now correctly terminates ETL Runtime upon receipt of the request to stop from the Solution Control Server. (CCA-1991)


On Unix and AIX, ETL Service Starter now stops correctly upon a request from the Solution Control Server. (CCA-1979, CCA 1970)


Data Mart no longer incorrectly marks all newly added External Route Point DNs as deleted. Previously when these DNs were marked as deleted and are members of the monitored DN Groups, it caused an uncontrolled growth of the OBJ_TO_OBJ table. (CCA-1969)


On Unix, ETL Service Starter (64-bit) no longer terminates unexpectedly. (CCA-1879)


Top of Page


Known Issues and Recommendations

This section provides the latest information on known issues and recommendations associated with this product.


Recommended Configuration for Oracle RAC 11g Releases 1 and 2—In order to support Oracle RAC in ETL, you must configure jdbcurl in etl.properties and any other properties files you use (for example, purge, createdb, and tenants_alias_update) as shown in the following examples:

(ER# 314049494)

Found In: 7.6.100.08 Fixed In: 

If using Oracle Thin driver with Oracle RAC, and configuring ETL by using ETL Assistant, there may be a problem connecting to a Data Mart database. ETL Assistant generates the following URL to connect to the Data Mart database, and to configure the ODS Data Source:

jdbc:oracle:thin:@<Oracle Cluster IP address or Cluster Hostname>:<Oracle Listener Port>:<SID>

In the above, <SID> can only point to one particular instance of the cluster, and <SID> is populated from the SID Name in the ETL Assistant field. This is the only format that is supported when ETL Assistant connects to the Data Mart database. This same format is used in ETL Assistant for the ODS Data Source configuration if the ODS database is located on Oracle RAC. However, if you have an Oracle RAC cluster database, and want ETL Service Starter to be able to connect to the running instance during an instance failure, the Service Name must be used instead of the SID.

ETL Assistant cannot construct the URL with a Service Name. If this is desired, you need to create a new ODS Data Source in ETL Assistant, and then update its URL to the following format (note that you must use "/" instead of ":"):

jdbc:oracle:thin:@<Oracle Cluster IP address or Cluster Hostname>:<Oracle Listener Port>/<Service Name>

This can be done by issuing the following SQL statement against the Data Mart database:

update SOURCE set DB_URL = <DB URL in the format above> where SOURCE_ID = <ID of the ODS source> (ER# 255574621)

Found In:  7.6.000.08 Fixed In: 

ETL Service Starter may incorrectly write the time dimensions for the START_TIME and END_TIME columns in scenarios where a data chunk is not aligned to the minute boundary. In such situations, the duration (END_TIME-START_TIME) will be preserved, and the START_TIME and END_TIME columns will both be shifted, so that START_TIME is aligned with the minute's beginning. (ER# 215929509)

Found In:  7.6.000.08 Fixed In: 

In certain Japanese locales (for example, ja_JP.eucJP and ja_JP.PCK), Data Mart's Configuration Tracking module may fail to unpack a localized string and return java.lang.NullPointerException. To avoid this problem, add the following option to the startup command of the Configuration Tracking module:

-Dfile.encoding=SJIS

The Configuration Tracking module's startup command is specified in the Command configuration option of the ETL_Tracking section. (ER# 73476983, 73789489)

Found In:  7.2.002.08 Fixed In: 

On Solaris platforms, Data Sourcer may experience a time synchronization problem for some U.S. time zones during Daylight Savings Time, causing duplicate values to be recorded. (ER# 118869764)

Found In:  7.2.002.02 Fixed In: 

Under certain circumstances, ETL Assistant will display the actual Data Mart table name instead of its synonym. (ER# 79928601)

Found In:  7.2.001.06 Fixed In: 

On the Windows 2003 Japanese platform using the Japanese character set, the Data Mart Wizard does not successfully connect to a Data Mart built with Microsoft SQL RDBMS. (ER# 71735571)

Found In:  7.2.001.06 Fixed In: 

For the Windows 64-bit platform, the Data Mart Installation may fail to detect the 64-bit JRE. To solve this problem, install the 32-bit JRE, install Data Mart, and then start Data Mart using the 64-bit JRE. (ER# 32384033)

Found In:  7.2.000.04 Fixed In: 

In some situations, the jTDS driver used by ETL Service Starter may not connect to the database on Microsoft SQL. The driver contains an incomplete set of charset conversion rules. The jTDS driver can be updated with the correct set of charset conversion rules, but for the 7.2 release, the driver that is shipped has already been updated for all charsets for which the issue was reported, including the MS949 charset. (ER# 35457267)

Found In:  7.1.000.09 Fixed In: 

If you are configuring Data Mart and you select a custom driver, the installation process does not copy the driver to ETL Service Starter home directory. You must copy the custom JDBC driver files to your target ETL Service Starter home directory manually. (ER# 99384)

Found In: 7.0.200.10 Fixed In: 

Due to a problem in Unix installations of ETL Service Starter, a newly installed instance of ETL Service Starter may fail to start. To resolve this issue, employ the following steps:

  1. Copy run.sh from the main Data Mart installation directory to the etl_runtime subdirectory.
  2. Rename the starter_32 file in the etl_runtime subdirectory to starter.

(ER# 95445)

Found In: 7.0.200.02 Fixed In: 

Warning: Before upgrading your Data Mart manually, ensure that you save copies of your .properties files, including: createdb.properties, etl.properties, and purging.properties, as these files will be overwritten by this process. (ER# 93751)

Found In: 7.0.200.02 Fixed In: 

To update your current Data Mart version during the installation process, remove the existing application and then create a new one. The offer to update your current Data Mart should be ignored. (ER# 97445)

Found In: 7.0.100.07 Fixed In: 

If you delete layouts before creating a purge schedule, the layouts cannot later be purged. (ER# 80628)

Found In: 7.0.100.09 Fixed In: 

The Historical Wizard configures the setFirstDayOfWeek runtime parameter for the Starter process but does not set its value in all .properties files. If you elect to manually run ETL Runtime processes, remember to set the value of this parameter in the .properties file that you use. (ER# 75995)

Found In:  7.0.100.04 Fixed In: 

Object duplication in Brio Reports and incorrect statistical values can occur in certain situations after the following has occurred: a report layout is deleted, a report layout object name is modified, and the report layout is re-created. ETL Service Starter unites these layouts automatically; however, ETL Service Starter does not update object information for deleted layouts. (ER# 62573)

Found In:  6.5.001.12 Fixed In: 

In some rare cases when Configuration Tracking module and Configuration Server are running on the same HP11 64-bit box, the Configuration Tracking module may freeze upon start. If you encounter this problem, contact Genesys Customer Care . (ER# 74238)

Found In:  6.5.001.09 Fixed In: 

The length of integer fields in DB2 Data Marts may not be adequate in some Reporting environments. This may result in arithmetic overflow. Contact Genesys Customer Care if this problem occurs. (ER# 63994)

Found In:  6.5.001.09 Fixed In: 

For each report view, ETL Assistant shows the RDBMS view name containing data for every report layout based on the same underlying layout template. ETL Assistant does not reveal table names; therefore, you should use views to build reports. (ER# 51714)

Found In:  6.5.001.06 Fixed In: 

If you attempt to add a Configuration Server node using ETL Assistant without first using the Data Mart Wizard to configure ETL Assistant, ETL Assistant displays the following error message: Config Server authentication error. Click Ignore in this message box and the node will be saved in the Data Mart anyway. (ER# 52929)

Found In:  6.5.001.05 Fixed In: 

The Solution Reporting Wizard creates an ETL_Service application object and installation package; however, the installation package creates another ETL_Service application object and does not enable you to select any pre-existing ETL application object. (ER# 85379)

Found In:  6.5 Fixed In: 

The Configuration Tracking module of ETL Service Starter may generate a java.lang.NullPointerException error when checking agent skills if the ETL user has inadequate permissions to view the corresponding tenants. (ER# 75806)

Found In:  6.1.301.07 Fixed In: 

You may see minor inconsistencies in the appearance of the mouse cursor while hovering it over various elements of the ETL Assistant interface. (ER# 48601)

Found In:  6.1.301.02 Fixed In: 

ETL Assistant may display the following error message while trying to schedule a purge process when more than 20 report layouts are open:

Unable to generate NextID to table PURGING_RULES Exception Mess:ORA-00604 error occurred at recursive SQL level1 ORA_01000: maximum open cursors exceeded;

Click OK to close this dialog box. (ER# 43366)

Found In: 6.1.301.02 Fixed In: 

When you add a new Configuration Server to the Data Mart, verify the information in the New Source dialog box displayed by ETL Assistant as ETL Assistant does not always detect all available ODS sources.

Also, you must add JDBC information manually as this information is not available within Configuration Server. For further details on the scanning process of the ETL Assistant, refer to the "Auto-Detecting ODS Sources" topic in the Reporting 7.2 ETL Assistant Help file. (ER# 42298)

Found In:  6.1.301.02 Fixed In: 

For some RDBMSs, such as DB2 or Sybase, having ETL Assistant open continuously can inhibit the purge process; therefore, do not keep ETL Assistant open for an extended period of time. (ER# 40021)

Found In: 6.1.301.01 Fixed In: 

ETL Assistant does not support multi-byte characters. Entering a multi-byte user or application name causes login failure. (ER# 38535)

Found In: 6.1.007 Fixed In: 

Top of Page


Discontinued Support

This section documents features that are no longer supported in this software. This cumulative list is in release-number order with the most recently discontinued features at the top of the list.


Support for the following has been discontinued:

Discontinued As Of: 8.0.100.08

Top of Page


Internationalization

Information in this section is included for international customers.


Internationalization is not supported for this release of Data Mart.

Top of Page


Additional Information

Additional information on Genesys Telecommunications Laboratories, Inc. is available on our Genesys Customer Care website. The following documentation also contains information about this software. Please consult the Deployment Guide first.

Product documentation is provided on the Customer Care website, the Genesys Documentation website, and the Documentation Library DVD (produced monthly).

Note: For the DVD, the New Documents on this DVD page indicates the production date for that disc. Due to disc production schedules, documentation on the Genesys Documentation website may be more up-to-date than what is available on disc immediately after a product is released or updated. To determine the version of a document, check the version number that is located on the second page in PDFs or on the About This File topic in Help files.

Top of Page