My Oracle Support Banner

Marketing Cache Data is not being deleted (Doc ID 967519.1)

Last updated on JUNE 20, 2017

Applies to:

Siebel Marketing Server Enterprise Edition - Version SIA [20420] and later
Information in this document applies to any platform.


We have noticed that records are not getting deleted automatically from M_C_CONTACT table even though system is configured to do that in our production environment.

Since this is a temporary table that is used during campaign load/launch process, can you please let us know if there is a siebel product defect around this?

We are still getting the "kmsgErrorInDeletingCache" errors in sawlog file. Please advise.

We noticed a query running in Analytics this morning with the following log:

-------------------- SQL Request:
EXECUTE PHYSICAL CONNECTION POOL "Oracle Data Warehouse"."Oracle Data Warehouse Connection Pool" DELETE FROM M_C_CONTACT WHERE GUID = '670ca920-0b67-1000-81c6-ac1293190000'
-------------------- Sending query to database named Oracle Data Warehouse (id: ExecutePhysical Gateway):
DELETE FROM M_C_CONTACT WHERE GUID = '670ca920-0b67-1000-81c6-ac1293190000'

Please let us know if this is part of the purge.

Purge Cache query has been running for past 6 hours. How much time should this usually take?


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

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