Related Documents
Document Properties
Kbid29476P
Last Modified08-Jul-2020
Added to KB09-Jul-2020
Public AccessEveryone
StatusOnline
Doc TypeReferences

Job - DeleteDomainReferences (valid to 7.2)

Name

DeleteDomainReferences

Domain

root

Job Dependencies

none

AcquiredResources

none

Cartridge

core

Pipeline

TriggerDeleteDomainReferences-Start

Affected Domain Objects

  • Product
  • Profile
  • ...

Affected Tables

  • core:
    acqlogentry
    acqlogentry_av
    acqlogentryresourceassignment
    activityuserassignment
    activityusergroupassignment
    basicaddress
    basicaddress_av
    basiccredentials
    basicexchangerateser_av
    basicexchangerateserviceconfig
    basicprofile
    basicprofile_av
    businesseventpipelineinfo
    deleteduser
    domain
    domain_av
    domain_ra
    domaininformation
    isresource
    isresource_av
    jobconfiguration
    jobconfiguration_av
    jobintermittenttimecondition
    jobrelativetimecondition
    jobresourceassignment
    preference
    process
    process_av
    regionalsettings
    regionalsettings_av
    replicationprocesstaskassign
    replicationtask
    replicationtask_av
    replicationtaskassignment
    replicationtaskhistory
    stagingprocesscomponent
    usergroup
    usergroup_ra
    usergroupassignment
    usergroupinformation
    usergroupinformation_av
    usergroupuserassignment
    workflowactivity
    workflowactivity_av
    workflowprocess
    workflowprocess_av
    workflowthread
    workflowthread_av
  • xcs:
    bundleassignment
    businessrule
    catalogcategory
    catalogcategory_av
    catalogcategory_hma
    catalogcategory_ra
    catalogcategorylink
    deletedproduct
    derivedproduct
    derivedproductcostprice
    derivedproductlistprice
    discount
    discount_av
    discountattributedef_av
    discountattributedefinition
    manufacturername
    manufacturername_av
    manufacturernamealia_av
    manufacturernamealias
    product
    product_ra
    productattribute
    productattribute_av
    productcategoryassignment
    productcostprice
    productdiscountassignment
    productlink
    productlink_av
    productlistprice
    productpricechangeevent
    productset
    productset_av
    productsetassignment
    productsetdomainassignment
    producttype
    producttype_av
    producttypediscountassignment
    productvariation
    productvariation_av
    productvariationassignment
    productvariationvalu_av
    productvariationvalue
    ruleset
    rulesetassignment
    scaledprice
    scaledpriceentry
    timecondition
    timeintervalcondition
    usergroupprice
    variablevariationatt_av
    variablevariationattribute
    variationtype
    variationtype_av
    weekdaycondition
  • bts:
    basket
    basket_av
    basket_hma
    bundledproductlineit_av
    bundledproductlineitem
    catalogcategory_hma
    handlingmethod
    handlingmethod_av
    handlingmethodconfig
    handlmethodcalcmodel
    handlmethodcalcmodelamnt
    isorder
    isorder_av
    isorder_hma
    lineitemgroup
    lineitemgroup_av
    paymentconfiguration
    paymentconfiguration_av
    paymentcost
    paymentcost_av
    paymenthistory
    paymenthistory_av
    paymentinstrumentinf_av
    paymentinstrumentinfo
    paymentserviceconfig_av
    paymentserviceconfiguration
    paymentservicedomainassignment
    paymenttaxclassassignment
    paymenttransaction
    paymenttransaction_av
    paymentusergroupassignment
    productlineitem
    productlineitem_av
    productlineitem_hma
    servicelineitem
    servicelineitem_av
    shippingmethod
    shippingmethod_av
    shippingmethod_hma
    shippingserviceconfig
    staticaddress
    staticaddress_av
  • bsc:
    methodcalcmodel
    methodcalcmodelamount
  • btc:
    basictaxclass
    basictaxclass_av
    basictaxclassconfig
    basictaxclassconfig_av
    jurisdictionmapping
    taxjurisdiction
    taxjurisdiction_av
    taxjurisdictionconfi_av
    taxjurisdictionconfig
    taxrate
  • sbc:
  • bc_approval:
    approvalanswer
    approvalanswer_av
  • bc_foundation:
    acqlogentryresourceassignment
    attributedescriptor_av
    attributegroup
    attributegroup_av
    brandinginstallation
    brandinginstallation_av
    brandingpackage
    brandingpackage_av
    consumergroup
    consumergroup_av
    iscomment
    iscomment_av
    isresource
    jobconfiguration
    journalentry
    journalentry_av
    label
    label_av
    linkgroup
    linkgroup_av
    linklinkgroupassignment
    messagebody
    messagebody_av
    messageenvelope
    messageenvelope_av
    messageuserassignment
    messageusergroupassignment
    ratingcomment
    ratingcomment_av
    resourcelock
    rule
    rule_av
    ruleaction
    ruleaction_av
    rulecondition
    rulecondition_av
    rulecontainer
    rulecontainer_av
    ruleoperator
    ruleoperator_av
    shortlink
    shortlink_av
    snapshotdata
    syndication
    syndication_av
    syndicationdatadecla_av
    syndicationdatadeclaration
    syndicationdatadecllist
    syndicationrule
    syndicationrule_av
    syndicationruleset
    syndicationugassignment
  • bc_marketing:
    abtest
    abtest_av
    abtestgroup
    abtestgroup_av
    abteststatistics
    abteststatistics_av
    affiliatepartner
    affiliatepartner_av
    affiliateprogram
    affiliateprogram_av
    affiliatesession
    affiliatesession_av
    bonuspointaccount
    bonuspointaccount_av
    bonuspointentry
    bonuspointentry_av
    couponinstance
    couponinstance_av
    couponorderassignment
    coupontemplate
    coupontemplate_av
    promotion
    promotion_av
    rebate
    rebate_av
    rebateruleassignment
  • bc_mvc:
    alert
    alert_av
    catalog
    catalog_av
    catalogcategorylabelassignment
    catalogfilter
    catalogfilter_av
    commoditygroup
    commoditygroup_av
    commoditygroupassignment
    contract
    contract_av
    filtergroupassignment
    filterobjectassignment
    filterproductassignment
    productdatadeclarati_av
    productdatadeclaration
    productdatadeclarationlist
    productdatamappingru_av
    productdatamappingrule
    productdatamappingruleset
    productlabelassignment
    productlist
    productlist_av
    productlistitem
    productlistitem_av
    productlistuserassignment
    productmappingrule
    productmappingrule_av
    repository
    repository_av
  • bc_organization:
    account
    account_av
    accounttransaction
    accounttransaction_av
    accounttransactionbinding
    applicationtype
    applicationtype_av
    applicationtypeassignment
    budget
    budget_av
    budgetperiod
    budgetperiod_av
    channeltype
    channeltype_av
    costcenter
    costcenter_av
    costcenter_ra
    department
    department_av
    department_ra
    organization
    organization_av
    organization_ra
    organizationgroupassignment
    userdelegation
  • bc_pmc:
  • bc_pricing:
    pricedefinitionprodu_av
    pricedefinitionproductbinding
    pricelist
    pricelist_av
    pricelistusergroupassignment
    pricescaleentry
    pricescaleentry_av
    pricescaletable
    pricescaletable_av
    pricescaletableassignment
  • bc_requisition:
    activereqawfdefassignment
    deliverynote
    deliverynote_av
    recurringdate
    recurringdate_av
    recurringrequisition
    recurringrequisition_av
    requisitionawfdefini_av
    requisitionawfdefinition
    requisitionawfsequen_av
    requisitionawfsequence
    requisitionawfstep
    requisitionawfstep_av
    routingrule
    routingrule_av
    routingrulecondition
    routingruleoperator
  • bc_tendering:
    rfq
    rfq_av
    rfqparameter
    rfqparameter_av
    rfqparametergroup
    rfqparametergroup_av
    rfqparametervalue
    rfqparametervalue_av
    rfqproductassignment
    rfqproductassignment_av
    rfqrequest
    rfqrequest_av
  • ac_bmecat:
    bmecatimportctr
  • ac_oci:
    ociconfiguration
    ociconfiguration_av

Stored Procedure

  • core:
    sp_deleteEventsByDomain
    sp_deleteExchangeRatesByDomain
    sp_deleteJobsByDomain
    sp_deletePreferencesByDomain
    sp_deleteProcessesByDomain
    sp_deleteRegSettingsByDomain
    sp_deleteReplTasksByDomain
    sp_deleteUserDataByDomain
    sp_deleteWorkflowsByDomain
  • xcs:
    sp_deleteCatalogObjects
    sp_deleteDiscountByDomain
    sp_deleteManAliasesByDomain
    sp_deletePriceByDomain
    sp_deletePriceEventByDomain
    sp_deleteProductObjects
    sp_deleteProductSetsByDomain
    sp_deleteProductTypeObjects
    sp_deleteProductVariObjects
    sp_deleteRulesByDomain
  • bts:
    sp_deleteHandlingByDomain
    sp_deleteLineItemCtnrByDomain
    sp_deletePaymentByDomain
    sp_deleteShippingByDomain
    sp_delHandlCalcModelByDomain
  • bsc:
    sp_deleteCalcModelByDomain
  • btc:
    sp_deleteTaxByDomain
  • sbc:
    sp_deleteContentByDomain
    sp_deleteDynTemplateByDomain
    sp_deleteKeywordByDomain
    sp_deleteLibraryByDomain
    sp_deleteLinkByDomain
    sp_deletePublicationByDomain
    sp_deleteStyleByDomain
    sp_deleteSyndicationByDomain
    sp_deleteTemplateByDomain
    sp_deleteTypeByDomain
    sp_deleteVersionByDomain
    sp_deleteContentLabelByDomain
  • bc_approval:
    sp_deleteApprovalByDomain
  • bc_foundation:
    sp_deleteAttrGroupByDomain
    sp_deleteBrandingByDomain
    sp_deleteCommentByDomain
    sp_deleteConsumerGroupByDomain
    sp_deleteJournalByDomain
    sp_deleteLabelByDomain
    sp_deleteMessageByDomain
    sp_deleteRatingByDomain
    sp_deleteRuleByDomain
    sp_deleteShortLinkByDomain
  • bc_marketing:
    sp_deleteABTestByDomain
    sp_deleteAffiliateByDomain
    sp_deleteBonusPointsByDomain
    sp_deleteCouponByDomain
    sp_deletePromotionByDomain
  • bc_mvc:
    sp_deleteAlertByDomain
    sp_deleteCatalogByDomain
    sp_deleteCatalogFilterByDomain
    sp_deleteCatalogLabelByDomain
    sp_deleteCommodityByDomain
    sp_deleteContractByDomain
    sp_deleteDataMappingByDomain
    sp_deleteMappingRuleByDomain
    sp_deleteProductListByDomain
    sp_deleteRepositoryByDomain
  • bc_organization:
    sp_deleteAccountByDomain
    sp_deleteBudgetByDomain
    sp_deleteChannelByDomain
    sp_deleteCostCenterByDomain
    sp_deleteDepartmentByDomain
    sp_deleteOrganizationByDomain
    sp_deleteUserDelegateByDomain
  • bc_pmc:
    sp_deletePageletsByDomain
  • bc_pricing:
    sp_deletePriceDefByDomain
    sp_deletePriceListsByDomain
    sp_deletePriceScaleByDomain
  • bc_requisition:
    sp_deleteDeliveryNoteByDomain
    sp_deleteRecurringReqByDomain
    sp_deleteReqAWFByDomain
    sp_deleteRoutingRuleByDomain
  • bc_tendering:
  • ac_bmecat:
  • ac_oci:

Default State

Enabled

Is Site Specific

True

Edit State

Globally Enabled

Live State

Disabled

Description

Triggers deleted domain cleanup.

Scheduling

manually after domain marked for deletion

What Happens Switched Off

Old marked as to be deleted domain (potentially mass data) content still exists.

Trouble Shooting

To complex to run all the specific stored procedures with correct order and for all related domains (sites, units, organizations, ...). Only the job can handle domain deletion.

Comments


Product Version

7.0

Product To Version

7.2

Status
final

Disclaimer

The information provided in the Knowledge Base may not be applicable to all systems and situations. Intershop Communications will not be liable to any party for any direct or indirect damages resulting from the use of the Customer Support section of the Intershop Corporate Web site, including, without limitation, any lost profits, business interruption, loss of programs or other data on your information handling system.

Customer Support
Knowledge Base
Product Resources
Tickets