ITAM failed to triggers emails related to events.

Products

• CA IT Asset Manager Asset Portfolio Management

Issue/Introduction

After successfull completion of Data Import job ITAM, Emails  from ITPAM where not triggered. 

Environment

CA ITAM 17.3.X
CA ITPAM 4.3
 

Cause

2024-05-16 11:39:37,968 UTC [EventService] ERROR CA.Applications.EventService.EventService - Web Service threw exceptionSystem.ArgumentException: You are searching for attribute 'zamc' in class 'usp_owned_resource_audit', and the attribute does not exist in the class. ---> System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary.
   at System.Collections.Generic.Dictionary`2.get_Item(TKey key)
   at CA.Common.Data.Meta.ClassDef.GetAttribute(String attrName)
   --- End of inner exception stack trace ---
   at CA.Common.Data.Meta.ClassDef.GetAttribute(String attrName)
   at CA.Common.Data.AdvancedSearch.QueryTransformer.BuildSelectClause()
   at CA.Common.Data.AdvancedSearch.QueryTransformer.Transform()
   at CA.Common.Data.AdvancedSearch.QueryEngine.Execute(QueryDefinition query)
   at CA.Common.Data.Persistence.Loader.GetList(String className, ListingParameters param, Int32& totalCount)
   at CA.Common.Business.BusinessEntityImp.GetValueObjectList(ListingParameters param, Int32& totalCount)
   at CA.Common.Event.RelationShipUtil.GetFiredAuditVal(String childClass, ClassDef childCD, String eventFireId, List`1 selectedAttribs, String auditTrailID, Dictionary`2& associatedValObjs, Boolean isEventCauseDeletedOnly)
   at CA.Common.Event.RelationShipUtil.GetAssociatedValObjs(String fullyQualifiedClassName, Dictionary`2 classAttributesToRead, String eventFireId, String auditTrailID, Boolean isEventCauseDeletedOnly)
   at CA.Applications.Business.FiredEvent.GetDataMapped(FiredEventsInfo info)
2024-05-16 11:39:37,971 UTC [EventService] ERROR CA.Applications.EventService.EventService - Web Service threw exception

Resolution

1. Validate if Event services are running. 
2. Validate if ITPAM soap webservices are accessible: 
     Ex:http://ITPAM SERVER NAME:8080/itpam/soap?wsdl
3.  <ITAM install folder>\MDB\PostInstallSteps
4.  Copy CreateAuditTableAndTriggersMsSql.sql
5. Execute sql query from the SQL query profile.
    ** Check for any error. 
6. Run IISReset  

Additional Information

How to locate ITAM log.