SAP Knowledge Base Article - Preview

3486555 - Promotion engine data check via groovy in SAP Commerce


This article shows you a groovy that could check the data of your promotion engine in SAP Commerce.

You could run this groovy in HAC and use the result as a reference to help you troubleshoot the promotion related issue in SAP Commerce.

Please note that,  if you want to run the groovy in your local installation of Commerce which not use the MS SQL Server DB. e.g. HQSQL embeded in COMMERCE.

Please change the following lines From



String func_length="length";

String func_currDate= "SYSDATE()";



  • SAP Commerce Cloud 2211
  • SAP Commerce Cloud 2205
  • SAP Commerce Cloud 2105


SAP Commerce 2105 ; SAP Commerce 2205 ; SAP Commerce Cloud 2105 ; SAP Commerce Cloud 2205 ; SAP Commerce Cloud 2211


Promotion, Promotion engine, Rule, Rule engine, Groovy , KBA , CEC-SCC-COM-PRO-PE , Promotion Engine , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.