My Oracle Support Banner

Table S_CM_MSG_STAT full resulting in Comm Outbound Manager Delivering Emails Slowly (Doc ID 1504506.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel Email Response - Version 8.1.1.7 [21238] and later
Information in this document applies to any platform.

Symptoms

On Siebel 8.1.1.7 enterprise application (call-center) customer using Siebel outbound communications for sending several outbound emails through workflow policies, eMail manager, eMail response, F9, etc.

Recently it was found that there was a performance deterioration in outbound communications - emails being sent by the Communication Outbound Manager.

Upon investigating we found Communication outbound manager tasks are blocking each other, with wait type PAGELATCH_UP and taking some time to clear these blocks on the database and causing delaying in outbound communications. These locks are due to the following query that communications outbound manager is using.
SELECT
      T1.CONFLICT_ID,
      CONVERT (VARCHAR (10),T1.LAST_UPD, 101) + ' ' + CONVERT (VARCHAR (10),T1.LAST_UPD, 8),
      CONVERT (VARCHAR (10),T1.CREATED, 101) + ' ' + CONVERT (VARCHAR (10),T1.CREATED, 8),
      T1.LAST_UPD_BY,
      T1.CREATED_BY,
      T1.MODIFICATION_NUM,
      T1.ROW_ID
   FROM
       dbo.S_CM_MSG_STAT T1
   ORDER BY
      T1.OBJECT_TYPE_CD, T1.SEND_TS
 OPTION (FAST 40)

We are wondering how these records are creating into this table and we can see per day approximately 10,000 records creating into this table and we do not see any triggers on this table against policies Campaign Offer Message Tracking – Delivered and Campaign Offer Message Tracking – Failed.


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
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.