XTK Reject Table | Community
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
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.

View reply

4 replies

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
ShrawanSaxena-1Accepted solution
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
    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
    david--garcia
    david--garcia
    Level 10
    Sep 20, 2021 2:07 PM UTC

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

     

     

    Translate
    Terms & ConditionsAccessibility statement

    Loading footer...