Database Query Failed on Symantec End Point (SEP) Event Collector 4.3

book

Article ID: 156094

calendar_today

Updated On:

Products

Security Information Manager

Issue/Introduction

One of the SEP Event Collector query fails for SEPM 12 on Sybase

 

INFO    2012-01-24 15:35:41,092    Collectors.3165.wGroup.[workinggroup0]    workinggroup0    All POLL sensor threads (1) have been created.
INFO    2012-01-24 15:35:42,155    Collectors.3165.wGroup.[workinggroup0].Sensor.[Sym_Endpoint_SOME_SENSOR]    Thread-20    JDBC driver: driverName = "jConnect (TM) for JDBC (TM)", driverVersion = "jConnect (TM) for JDBC(TM)/6.05(Build 25828)/P/EBF13044/JDK14/Fri Sep 30  1:05:16 2005", majorVersion = "6", minorVersion = "0"
INFO    2012-01-24 15:35:42,155    Collectors.3165.wGroup.[workinggroup0].Sensor.[Sym_Endpoint_SOME_SENSOR]    Thread-20    Database: productName = "SQL Anywhere", productVersion = "11.0.1.2472", productMajorVersion = "unknown", productMinorVersion = "unknown"
WARN    2012-01-24 15:35:53,326    Collectors.3165.wGroup.[workinggroup0].Sensor.[Sym_Endpoint_SOME_SENSOR]    Thread-20    Database query failed. JZ006: Caught IOException: java.io.IOException: JZ0TC: Attempted conversion between an illegal pair of types.).

Cause

The jConnect 6.0 drivers need to be updated to jConnect 7.0

Resolution

Please follow instructions from the technote below to download and configure new driver:

http://www.symantec.com/business/support/index?page=content&id=TECH167144