3793347 - High work process with error "unique constraint violated: Table(/SDF/IM_PUSH_ERR), Index(/SDF/IM_PUSH_ERR~0) with error" during Integration & Exception Monitoring Data Collection - SAP Cloud ALM

• Error in work process: Unique constraint violated: Table(/SDF/IM_PUSH_ERR), Index(/SDF/IM_PUSH_ERR~0) with error: unique constraint violation (duplicate key) on /SDF/IM_PUSH_ERR$delta_1$en
• Log of workprocess: Transaction rolled back by lock wait timeout: TrexColumnUpdate failed on table '/SDF/IM_PUSH_ERR'
• multiple locks visible in SM12 related to data collection jobs.
• Increasing/occupied work processes in SM66 by the data collection background user.
• expensive statements observed on table /SDF/IM_PUSH_ERR

• SAP Cloud ALM
• Managed system ABAP with ST-PI 7.40 SP32, ST-PI 7.40 SP33 or ST-PI 7.58 SP00 

/SDF/IM_PUSH_ERR, unique constraint violated, /SDF/IM_PUSH_ERR~0, duplicate key, TrexColumnUpdate, lock wait timeout, NIECONN_REFUSED(-10), Integration & Exception Monitoring, ST-PI, SM12 locks, SM66 work processes, expensive statements, data push, index violation, aggregation filters , KBA , SV-CLM-OP-IM , Integration Monitoring Service , SV-CLM-DC , SAP ALM Data Collectors (ABAP) , Problem