Troubleshooting
Problem
A regression introduced in 7.1.0-TIV-NCI-FP0020 breaks Database Event Readers. With the exception of those connected to an Oracle data source, all DatabaseEventReader services are affected.
Services based on OmnibusEventReader are not affected as these use a different Service type.
Symptom
The general symptom is that events will not be read by the reader.
The specifics of the error messages shown will vary depending on the RDBMS.
For Object Server, the reader's log file will show the error: JZ0TC: Attempted conversion between an illegal pair of types
And the impactserver.log file fill show the full message and Java stack trace, as below:
ERROR [AbstractEventReader] <Reader Name>: Error retrieving the event from the EventFeedConnection, Exception:
com.micromuse.response.event.GenericEventDriverException: Error Getting Events java.sql.SQLException: JZ0TC: Attempted conversion between an illegal pair of types.
at com.micromuse.response.event.GenericEventDriver$GenericEventConnection.readEvents(GenericEventDriver.java:477) ~[nci.jar:?]
at com.micromuse.response.event.GenericEventDriver$GenericEventConnection.waitForEvent(GenericEventDriver.java:650) ~[nci.jar:?]
at com.micromuse.response.service.AbstractEventReader.run(AbstractEventReader.java:593) [nci.jar:?]
at java.lang.Thread.run(Thread.java:822) [?:2.9 (07-24-2020)]
Caused by: java.sql.SQLException: JZ0TC: Attempted conversion between an illegal pair of types.
at com.sybase.jdbc3.jdbc.ErrorMessage.raiseError(Unknown Source) ~[jconn3-6.0.5.jar:?]
at com.sybase.jdbc3.tds.TdsDataObject.badConversionCombination(Unknown Source) ~[jconn3-6.0.5.jar:?]
at com.sybase.jdbc3.tds.TdsDataObject.getDateObject(Unknown Source) ~[jconn3-6.0.5.jar:?]
at com.sybase.jdbc3.jdbc.SybResultSet.getTimestamp(Unknown Source) ~[jconn3-6.0.5.jar:?]
at com.micromuse.response.event.GenericEventDriver$GenericEventConnection.readEvents(GenericEventDriver.java:380) ~[nci.jar:?]
... 3 more
com.micromuse.response.event.GenericEventDriverException: Error Getting Events java.sql.SQLException: JZ0TC: Attempted conversion between an illegal pair of types.
at com.micromuse.response.event.GenericEventDriver$GenericEventConnection.readEvents(GenericEventDriver.java:477) ~[nci.jar:?]
at com.micromuse.response.event.GenericEventDriver$GenericEventConnection.waitForEvent(GenericEventDriver.java:650) ~[nci.jar:?]
at com.micromuse.response.service.AbstractEventReader.run(AbstractEventReader.java:593) [nci.jar:?]
at java.lang.Thread.run(Thread.java:822) [?:2.9 (07-24-2020)]
Caused by: java.sql.SQLException: JZ0TC: Attempted conversion between an illegal pair of types.
at com.sybase.jdbc3.jdbc.ErrorMessage.raiseError(Unknown Source) ~[jconn3-6.0.5.jar:?]
at com.sybase.jdbc3.tds.TdsDataObject.badConversionCombination(Unknown Source) ~[jconn3-6.0.5.jar:?]
at com.sybase.jdbc3.tds.TdsDataObject.getDateObject(Unknown Source) ~[jconn3-6.0.5.jar:?]
at com.sybase.jdbc3.jdbc.SybResultSet.getTimestamp(Unknown Source) ~[jconn3-6.0.5.jar:?]
at com.micromuse.response.event.GenericEventDriver$GenericEventConnection.readEvents(GenericEventDriver.java:380) ~[nci.jar:?]
... 3 more
For DB2 and MS-SQL the error shown in the reader log is :
Error while reading events: __LOGVIEWER__STACKTRACE_ Error Getting Events java.lang.NullPointerException
and the impactserver.log file will have
ERROR [AbstractEventReader] <Reader Name>: Error retrieving the event from the EventFeedConnection, Exception:
com.micromuse.response.event.GenericEventDriverException: Error Getting Events java.lang.NullPointerException
at com.micromuse.response.event.GenericEventDriver$GenericEventConnection.readEvents(GenericEventDriver.java:466) ~[nci.jar:?]
at com.micromuse.response.event.GenericEventDriver$GenericEventConnection.waitForEvent(GenericEventDriver.java:636) ~[nci.jar:?]
at com.micromuse.response.service.AbstractEventReader.run(AbstractEventReader.java:593) [nci.jar:?]
at java.lang.Thread.run(Thread.java:822) [?:2.9 (07-24-2020)]
Caused by: java.lang.NullPointerException
at com.micromuse.response.event.GenericEventDriver$GenericEventConnection.readEvents(GenericEventDriver.java:380) ~[nci.jar:?]
... 3 more
com.micromuse.response.event.GenericEventDriverException: Error Getting Events java.lang.NullPointerException
at com.micromuse.response.event.GenericEventDriver$GenericEventConnection.readEvents(GenericEventDriver.java:466) ~[nci.jar:?]
at com.micromuse.response.event.GenericEventDriver$GenericEventConnection.waitForEvent(GenericEventDriver.java:636) ~[nci.jar:?]
at com.micromuse.response.service.AbstractEventReader.run(AbstractEventReader.java:593) [nci.jar:?]
at java.lang.Thread.run(Thread.java:822) [?:2.9 (07-24-2020)]
Caused by: java.lang.NullPointerException
at com.micromuse.response.event.GenericEventDriver$GenericEventConnection.readEvents(GenericEventDriver.java:380) ~[nci.jar:?]
... 3 more
Document Location
Worldwide
[{"Line of Business":{"code":"LOB77","label":"Automation Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSSHYH","label":"Tivoli Netcool\/Impact"},"ARM Category":[{"code":"a8m500000008ZuMAAU","label":"Impact-\u003EImpact Server-\u003EEvent Reader"}],"ARM Case Number":"","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"7.1.0"}]
Log InLog in to view more of this document
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Was this topic helpful?
Document Information
Modified date:
08 May 2025
UID
ibm16398308