Troubleshooting
Problem
The introduction of a new feature in Netcool Impact FP21 (7.1.0-TIV-NCI-FP0021) adversely affects the existing property - updatefornewevents.
By default, this property is not set for any Event Readers. If this property is not set, then there is no negative impact. This document is relevant only to customers who use updatefornewevents and have upgraded to FP21.
Symptom
After applying Netcool Impact 7.1.0-TIV-NCI-FP0021, if updatefornewevents is set and updateforneweventsexpr is not set, then updatefornewevents will have no effect (i.e. the ImpactFlag field will not be updated). Instead an error will be seen in the impact server logs.
The error in the impact server log will be something like this:
WARN [JDBCVirtualStatement] Bad connection com.sybase.jdbc3.jdbc.SybSQLException: ERROR=Invalid column on line 1 of statement 'update alerts.status set ImpactReadFlag = 1 where Serial IN (...)', at or near 'ImpactReadFlag'
WARN [JDBCVirtualStatement] Bad connection com.sybase.jdbc3.jdbc.SybSQLException: ERROR=Invalid column on line 1 of statement 'update alerts.status set ImpactReadFlag = 1 where Serial IN (...)', at or near 'ImpactReadFlag'
Note: The actual event processing will work OK i.e. if the event matches the restriction filter(s) clause, then the associated policy will run OK.
Also, if both updatefornewevents and the updateforneweventsexprproperties are set, then the field specified will be updated, but it will be updated before the event is processed, as opposed to afterwards, and this could have negative consequences. There will be no error in the logs in this case. Again the actual event processing will work OK - this is not affected.
Document Location
Worldwide
[{"Type":"SW","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":"a8m500000008ZvyAAE","label":"Impact-\u003EImpact Server-\u003EDatabaseEventReader"}],"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
ibm16444783