Table IWA_CaseMapEvent

Case map events happens happens during the execution of a case map

Columns

Primary Key Name Type Length Precision Can Be Null Default References Action Hints Comment
true CaseMapEventId BIGINT false Primary key
false BusinessCaseId BIGINT false IWA_CaseMapBusinessCase(BusinessCaseId) ON DELETE CASCADE Java , MsSqlServer Business case id this event belongs ot
false Timestamp DATETIME false Timestamp the event occurred
false Kind INTEGER false Java BusinessCaseStarted, BusinessCaseEnded, BusinessCaseDestroyed, StageChanged, ProcessStarted, ProcessEnded, ProcessDestroyed, MilestoneReached, MilestoneRevoked
false Stage VARCHAR 200 false Stage of the business case at the time the event occurred
false Process VARCHAR 200 false Process id of the started, ended or destroyed process
false ProcessCaseId BIGINT true IWA_Case(CaseId) ON DELETE CASCADE MsSqlServer Case id of the started, ended or destroyed process
false Milestone VARCHAR 200 false The Milestone that was reached or revoked
false Reason VARCHAR 200 false Reason why this event happen. Also include evaluated pre-conditions and executed post-actions
false ProcessingState INTEGER false Java 0 not processes, 1 processed, 2 error
false ProcessingErrorMessage VARCHAR 750 false Java Message of the last error occurred while processing of the event by the case map engine
false ProcessingErrorCount INTEGER false Number of times the processing of the event failed on the case map engine
false ProcessingRetryTimestamp DATETIME true Next time the event is retried to process on the case map engine

Indexes

Name Columns Hints Comment
IWA_CaseMapEvent_BcId BusinessCaseId
IWA_CaseMapEvent_PrcRtryTstmp ProcessingRetryTimestamp
IWA_CaseMapEvent_PrcState ProcessingState
IWA_CaseMapEvent_ProcessCaseIdIndex ProcessCaseId

Cache

Object Strategy
IWA_CaseMapEvent ALL_REMOVE_UNUSED

Java

Object AsParent Enum Truncate
BusinessCaseId true
Kind ch.ivyteam.ivy.casemap.runtime.repo.restricted.CaseMapEventKind
ProcessingState ch.ivyteam.ivy.casemap.runtime.repo.restricted.ProcessingState
ProcessingErrorMessage true

MsSqlServer

Object NoReferenceUseTrigger
BusinessCaseId true
ProcessCaseId true