The data engine is queued up and QOS messages are not being processed.
Release : 20.3, 20.4 or higher
Component : UIM - DATA_ENGINE
It was observed that a script was blocking, and that was preventing data inserts into the UIM database.
Upon analysis, it was observed that the database maintenance script and indexing script was scheduled at the same time, and this was causing the issue.
Schedule the database maintenance script and indexing script to run at different times.
Data maintenance script that data_engine uses runs at 12:40 am. Indexing should not run at the same time.
Note that auto indexing is fine for small UIM environments but should be disabled in medium-to-large environments.
Table partitioning is sufficient to maintain the tables so partitioning should be enabled but large tables should be manually partitioned first before enabling the option in the data_engine.