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 8.0.0.5 SIA [20420] and later
Information in this document applies to any platform.

Goal

Qn1:
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?

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

Qn3:
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.

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

Solution

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