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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms