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
Cause
APAR IJ25247
Resolving The Problem
APAR IJ30015, has been addressed in 7.1.0-TIV-NCI-IF0008.
7.1.0-TIV-NCI-IF0008 can be downloaded from here: https://www.ibm.com/support/pages/node/6404584
7.1.0-TIV-NCI-IF0008 can be downloaded from here: https://www.ibm.com/support/pages/node/6404584
Document Location
Worldwide
[{"Line of Business":{"code":"LOB45","label":"Automation"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSSHYH","label":"Tivoli Netcool\/Impact"},"ARM Category":[{"code":"a8m500000008ZuMAAU","label":"Impact->Impact Server->Event 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"}]
Was this topic helpful?
Document Information
Modified date:
18 January 2021
UID
ibm16398308