Job - DeleteDomainReferences (valid to 7.2)

Personal Library

https://support.intershop.com/kb/29476P

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	New Labels

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.