Scheduled process show incorrectly in SMA
User has observed 308162 scheduled processes in System Management Application (SMA) and the count was increasing by 2000 in every 10 minutes. In the database table - PR_SYS_QUEUE, user could see around 80000 records in scheduled status.
STEPS TO REPRODUCE
a) Open SMA -> under Agent Management -> System Queue Management : Beside Scheduled' status, check the Item Count.
b) Verify the count under table PR_SYS_QUEUES. This count mismatch with SMA.
SystemIndexer and SystemWorkIndexer agents were not running. Due to this reason, large number of records were observed in the PR_SYS_QUEUES table.
Suggested user to start SystemIndexer and SystemWorkIndexer agents. These agents create indexes for Rules and Work-Items. These agents also help event processing. System event evaluation agent uses the items queued by SystemWorkIndexer. Stopping this agent results in accumulating Queue items, performance will be affected due to large volume of queue items, Search and Events does not work.
Following steps were shared with user before starting the agents:
- Stop all activity on this system (all nodes connected to the database)
- Truncate the PR_SYS_WORKINDEXER_QUEUE table.
- Start re-indexing manually - Re-index Work index from the Search landing page.
0% found this useful