Marketing Cache Data is not being deleted
Last updated on JUNE 20, 2017
Applies to:Siebel Marketing Server Enterprise Edition - Version 188.8.131.52 SIA  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?
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms