Job - DeleteUserReferences

Personal Library

https://support.intershop.com/kb/N29477

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