Existing Escalation actions are not working after SOI up-gradation from 3.3 CU2 to 4.2. SOI is working fine with newly created escalation actions but problem is with existing Escalation Actions and it may throw an exception as below...
Ticket Action - java.lang.NullPointerException
The cause of this problem is that those existing escalation actions did not have the correct value for the "PropertySetID" in the "ActionPropertySets" table in SAMStore DB. The value should have been 1 but it contains 0 instead
1) Run SQL Query "select * from ActionPropertySets" table and check "PropertySetID" value. The value should have "1", if this has "0" value then run below steps to fix this problem.
2) Stop "CA SAM Application Server" service on SOI Manager
3) Run below SQL Update query
set PropertySetID = replace (PropertySetID, '0', '1')
where PropertySetID = 0
4) Start "CA SAM Application Server" service