3516043 - Apply promotion rule failure due to promotion module initialization failure at startup caused by database disconnect

Symptom

The promotion rule is not being applied to the cart or order.

In the Kibana log, the following logs can be found:

"message": "Error while destroying connection 2(-A!) : connection is closed."

"message": "PreparedStatementCallback; SQL [UPDATE CLNodeInfos SET lastPingTS=? WHERE clusterID=?]; Connection reset by peer; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: Connection reset by peer",
"cause": {
"extendedStackTrace": [
{
"location": "mssql-jdbc-11.2.3.jre17.jar",
"version": "?",
"file": "SQLServerConnection.java",
"method": "terminate",
"exact": false,
"line": 3806,
"class": "com.microsoft.sqlserver.jdbc.SQLServerConnection"
}

"loggerName": "de.hybris.platform.ruleengine.event.OnTenantStartupProcessor",
......
"message": "[Catalina-utility-1]: Exception caught in rule module initialization during tenant startup or after initialization: de.hybris.platform.servicelayer.exceptions.ModelSavingException: [de.hybris.platform.droolsruleengineservices.interceptors.DroolsKIEModulePrepareInterceptor@5dcfb545]: unexpected preparer error: SQL search error - enable the property 'flexible.search.exception.show.query.details' for more details",

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."

Environment

SAP Commerce Cloud in the Public Cloud (CCv2)

Product

SAP Commerce Cloud all versions

Keywords

Commerce, Commerce Could, Promotion rule, Promotion module, promotion apply failed, rule module, rule module initialization, module initialization , 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.