What is best way to deal with old inactive promotions

[Former Member]

My application has huge amount of promotions , Which is causing perfomance hit . Kindly suggest what is best way to deal with Inactive promotions . Removal of promotions or archival .

[lenastodal]

Hi and welcome to the SAP Community!

Thank you for visiting SAP Community to get answers to your questions. Since you're asking a question here for the first time, I recommend that you familiarize yourself withhttps://community.sap.com/resources/questions-and-answers(if you haven't already), as it provides tips for preparing questions that draw responses from our members. For example, you can outline what steps you took to find answers (and why they weren't helpful) and share screenshots of what you've seen/done. The more details you provide, the more likely it is that members will be able to assist you.

Should you wish, you can revise your question by selecting Actions, then Edit (although once someone answers your question, you'll lose the ability to edit the question -- but if that happens, you can leave more details in a comment).

Finally, if you're hoping to connect with readers, please consider adding a picture to your profile. Here's how you do it:https://www.youtube.com/watch?v=F5JdUbyjfMA&list=PLpQebylHrdh5s3gwy-h6RtymfDpoz3vDS. By personalizing your profile with a photo of you, you encourage readers to respond.

Best,
Lena
SAP Community Moderator

[former_member633554]

We wrote a groovy script cronjob that deletes them. Hopefully this steers you in the right direction

import static org.mockito.Mockito.when;
import static org.mockito.MockitoAnnotations.initMocks;
import de.hybris.bootstrap.annotations.UnitTest;
import de.hybris.platform.ruleengine.RuleEngineActionResult;
import de.hybris.platform.ruleengine.RuleEngineService;
import de.hybris.platform.ruleengine.model.AbstractRuleEngineRuleModel;
import de.hybris.platform.ruleengine.model.DroolsKIEModuleModel;
import de.hybris.platform.ruleengineservices.RuleEngineServiceException;
import de.hybris.platform.ruleengineservices.compiler.RuleCompilerException;
import de.hybris.platform.ruleengineservices.compiler.RuleCompilerProblem.Severity;
import de.hybris.platform.ruleengineservices.compiler.RuleCompilerResult;
import de.hybris.platform.ruleengineservices.compiler.RuleCompilerService;
import de.hybris.platform.ruleengineservices.compiler.impl.DefaultRuleCompilerProblem;
import de.hybris.platform.ruleengineservices.compiler.impl.DefaultRuleCompilerResult;
import de.hybris.platform.ruleengineservices.enums.RuleStatus;
import de.hybris.platform.ruleengineservices.maintenance.RuleCompilerPublisherResult;
import de.hybris.platform.ruleengineservices.maintenance.RuleCompilerPublisherResult.Result;
import de.hybris.platform.ruleengineservices.model.AbstractRuleModel;
import de.hybris.platform.servicelayer.model.ModelService;
import de.hybris.platform.ruleengine.*;


//$promotionSourceRulesQuery="select {pk} from {promotionsourcerule} where {startdate}>'2017-12-01' and {enddate}<'2017-12-29'"
$promotionSourceRulesQuery="select {pk} from {promotionsourcerule} where ({status}=({{Select {pk} from {rulestatus} where {code}='ARCHIVED'}}))"
ruleCompilerService = spring.getBean('ruleCompilerService');
platformRuleEngineService = spring.getBean('platformRuleEngineService');
flexibleSearchService = spring.getBean('flexibleSearchService');
ruleMaintenanceService=spring.getBean("ruleMaintenanceService")


 result = flexibleSearchService.search("select {pk} from {promotionsourcerule} where ({status}=({{Select {pk} from {rulestatus} where {code}='ARCHIVED'}}))")
 itemsToDelete = result.getResult();
 modelService.removeAll(itemsToDelete);


//List sourceRules = flexibleSearchService.search($promotionSourceRulesQuery).getResult();
//for (sourceRule in sourceRules) { 
  //ruleCompilerService.compile(sourceRule);
 //sourceRule.remove;
//}
//platformRuleEngineService.initializeAllRulesModules();