Below is a prodcut advisory for this issue:
Product Advisory for CC Analyzer 5.1, 6.1, 6.5
Issued:
February 06, 2003
Defect Number:
53502
Summary:
CC Analyzer components that use a JDBC database connection may stop working after installing MS SQL
Server 2000 Service Pack 3 (SP3). Formal criteria is not available to assess if the problem will affect a
particular environment.
Affected Products & Versions:
CCAnalyzer ETL Runtime, ETL Assistant, IS DataSourcer, all versions in conjunction with
MS SQL Server 2000 SP3
Problem Description:
CC Analyzer components that use a JDBC database connection may stop working after installing MS SQL
Server 2000 Service Pack 3 (SP3). The problem is related to the BEA WebLogic JDBC driver operation.
If the problem occurs, the following error message is printed in the corresponding log file:
java.sql.SQLException: I/O exception while talking to the server, java.io.EOFException
Unable to connect, please check your server's version and availability.
The problem has the following impact:
ETL Runtime is unable to transfer data collected in the ODS database into the DataMart database. As a
result, the data is temporarily unavailable in the reports and the corresponding ODS database that is fed by
Stat Server continues to grow.
IS Data Sourcer is unable to extract fresh data from the ICS Contact Server database and store it in the
ODS database. As a result, the data is temporarily unavailable in the reports.
ETL Assistant is unable to connect to the DataMart database and display the report layouts structure.
Overall the problem does not lead to data loss provided that a fix is installed shortly. As soon as the fix is
installed and the affected components begin working properly, the missing data will be gradually transferred
into the DataMart database and will become available in the reports.
Note: The ODS database growth can potentially lead to data loss due to a lack of available disk space.
Workaround:
A workaround is not available.
Fix Available In:
The problem is related to the BEA WebLogic JDBC driver operation. Genesys has received a new JDBC
driver that resolves the problem from BEA and is planning to include it in Generally Available CC Analyzer
installation packages. Meanwhile you can download the new driver using the following link:
ftp://ftp.genesyslab.com/pub/production/weblogic_mssql_SP3_jdbc_driver.zip
The package consists of the driver itself and the Deployment Procedure document.
If you have trouble deploying this package, contact Genesys Technical Support.
