Document Properties
Kbid
N29477
Last Modified
11-Dec-2023
Added to KB
09-Jul-2020
Public Access
Everyone
Status
Online
Doc Type
References
Product
  • ICM 7.10
  • ICM 11
Job - DeleteUserReferences

Name

DeleteUserReferences

Domain

root

Job Dependencies

none

AcquiredResources

none

Cartridge

core

Pipeline

TriggerDeleteUserReferences-Start (core)

ExecuteCartridgePipelines: UserDeletionPipeline

bts: DeleteUserReferencesTransaction-Start

Affected Domain Objects

  • Basket
  • Product Line Item
  • PaymentInstrumentInfo
  • Address

Affected Tables

basket
basket_av
basket_hma
bundledproductlineit_av
bundledproductlineitem
lineitemgroup
lineitemgroup_av
paymentinstrumentinf_av
paymentinstrumentinfo
productlineitem
productlineitem_av
productlineitem_hma
servicelineitem
servicelineitem_av
staticaddress
staticaddress_av

Stored Procedure

sp_deleteBasketForUser
sp_deletePIIsForUser

Default State

Enabled

Is Site Specific

False

Edit State

Globally Enabled

Live State

Globally Enabled

Description

Triggers deleted user cleanup.

Scheduling

Manually if users marked for deletion.

What Happens Switched Off

User related tables contain to be deleted content (potentially mass data).

Trouble Shooting

Manually process to complex and not possible (table DELETEDUSER iteration, stored procedure call, cache refresh and DML to table DELETEDUSER), only the job can handle that.

Comments

Only found within bts (UserDeletionPipeline = DeleteUserReferencesTransaction-Start) all tables are transactional (streamable).

To prevent streaming problems, enable this job only in one data center (global enabled).

Product Version

7.0

Product To Version


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.
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.