Obsolete promotions cleanup

[VijayaR]

Our client has too many osbolete promotions which needeed to be cleaned up.

We plan to run DBClean against promotion objects. Has any one done this? Please share your experience, any unexpected behaviour?

-thanks

[VijayaR]

Also would like to see the rule(cleanconf record) with which promotion objects were successfully removed.

[VijayaR]

After running DBClean on promotion object for obsolete promotions, when they try to create a new promotion with the same name as one of the promotions which were deleted, they are getting this Error.

-----------------------------------------------

com.ibm.commerce.tools.epromotion.commands.RLPromotionSaveControllerCmdImpl redirect This name has already been created, although it is marked for delete. You cannot create a discount with same name until the discount is deleted.

-----------------------------------------------

I checked all the tables I can think of where PX_PROMOTION_ID could be a foreign key. Some how Commerce seems to know about the deleted promotions.

Any ideas about what might be happening?

[VijayaR]

Problem is solved. One needs to delete the records from CALCODE table. CALCODE.CODE refers to promotion code name(PX_PROMOTION.NAME).