My Oracle Support Banner

SFM Not Processing Messages efficiently (Doc ID 2775522.1)

Last updated on MAY 11, 2021

Applies to:

Oracle Installed Base - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms



ACTUAL BEHAVIOR
---------------
The SFM Event Manager Queue Service is running but messages in the Event queue are increasing and not decreasing (Processing Messages Very Slowly). Due to this performance issue the Item Instances are not being created or updated in Install Base timely

This issue happens on WIP transactions

EXPECTED BEHAVIOR
-----------------------
Expect not to have performance issue

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Process IB transactions using Service Fulfilment Manager
2. Verify Processing speed by running sql SELECT msg_status, COUNT(*) FROM xnp_msgs GROUP BY msg_status;
3. Check if READY status messages count is decreasing.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.