Document Properties
    Kbid
    29476P
    Last Modified
    15-Mar-2024
    Added to KB
    09-Jul-2020
    Public Access
    Everyone
    Status
    Online
    Doc Type
    References
    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
    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.
    The Intershop Knowledge Portal uses only technically necessary cookies. We do not track visitors or have visitors tracked by 3rd parties. Please find further information on privacy in the Intershop Privacy Policy and Legal Notice.
    Home
    Knowledge Base
    Product Releases
    Log on to continue
    This Knowledge Base document is reserved for registered customers.
    Log on with your Intershop Entra ID to continue.
    Write an email to supportadmin@intershop.de if you experience login issues,
    or if you want to register as customer.