Skip to main content
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
ShrawanSaxena-1
ShrawanSaxena-1Accepted solution
Adobe Employee
Sep 21, 2021 2:14 AM UTC

You are referring the internal tables related to cleanup process from which data will be selected and deleted based on parameters defined for cleanup in deployment wizard(purge settings) .  In the documentations it is just for reference purpose to show how cleanup works but you can not select this table from UI. These are internal tables and access is restricted to to DB admin and can not be viewed from UI.

4 replies

david--garcia
Level 10
Sep 20, 2021 2:07 PM UTC

What sort of data are you looking to find? Recipient exclusion log?

 

 

Translate
https://www.linkedin.com/in/david-garcia-uk/ | https://martech.network
prathap08Author
Level 4
Sep 20, 2021 2:24 PM UTC

David__Garcia  I meant this.. from adobe link >> experienceleague.adobe.com/docs/campaign-classic/using/monitoring-campaign-classic/data-processing/database-cleanup-workflow.html?lang=en#cleanup-of-rejects-generated-by-imports-

This step lets you delete records for which all data wasn’t processed during import.

  1. Mass-deletion is carried out on the XtkReject table with the following query:

    DELETE FROM XtkReject WHERE iRejectId IN (SELECT iRejectId FROM XtkReject WHERE tsLog < $(curDate)) LIMIT $(l))

    where $(curDate) is the current server date from which we subtract the period defined for the NmsCleanup_RejectsPurgeDelay option (refer to Deployment wizard) and $(l) is the maximum number of records to be mass deleted.

  2. All orphan rejects are then deleted using the following query:

    DELETE FROM XtkReject WHERE iJobId NOT IN (SELECT iJobId FROM XtkJob)
Translate
prathap08Author
Level 4
Sep 20, 2021 2:26 PM UTC

David__Garcia need to know whether xtk:Reject table available like other database cleanup tables? experienceleague.adobe.com/docs/campaign-classic/using/monitoring-campaign-classic/data-processing/database-cleanup-workflow.html?lang=en#cleanup-of-rejects-generated-by-imports- 

Translate
ShrawanSaxena-1
Adobe Employee
ShrawanSaxena-1Adobe EmployeeAccepted solution
Adobe Employee
Sep 21, 2021 2:14 AM UTC

You are referring the internal tables related to cleanup process from which data will be selected and deleted based on parameters defined for cleanup in deployment wizard(purge settings) .  In the documentations it is just for reference purpose to show how cleanup works but you can not select this table from UI. These are internal tables and access is restricted to to DB admin and can not be viewed from UI.

Translate