Self-Solve Knowledge Search

Minimize Maximize
UCA TBC - some rca alarm cannot be cleared
This document has not been formally reviewed for accuracy and is provided as is
Title :
UCA TBC - some rca alarm cannot be cleared
Document ID :
KM01190953
Product - Version:
unified topology manager ;
OS :
Updated :
Wed Oct 01 02:11:36 GMT 2014
Summary :
some rca alarm cannot be cleared after the children alarms were cleared.
Problem

check the followning trace log for more info.

eventlog_exception.log

search for the children alarm related trace from eventlog_exception.log and check for exception info

2014-07-30 01:13:53,Non-recoverable,Failed (SQL) to terminate Event in DB,EventDBService,EventDBEngineOracle,terminateEvent(),1
Attributes <<[Event [ (key=baseClass & object=com.hp.sdh.TerminationPoint), (key=originatingTime & object=2014-07-30 01:13:53), (key=previousSeverity & object=Major), (key=eventId & object=TeMIP:idea.top.oc.tx_super_oc#116403)
………..
……….
Exception Text <<ORA-01704: string literal too long
>>

Cause
The root cause of the problem is the length of the  Additional Text field of the raw alarm. When the raw  alarm is terminated, it is failed to be inserted into  the ev_event table of UCA because of the length of  Additional Text field. This issue is fixed by optimizing  the insert SQL.
Fix
UCATBCENGLIN_00013 was developed for this issue