SAP Knowledge Base Article - Preview

3204212 - Advance Search for Drools Rules via "Rule Content" field is not working in backoffice

Symptom

The Advance Search for Drools Rules via "Rule Content" field is not working in backoffice.

Below two kinds of exceptions will be thrown.

SQL search error - The data types text and nvarchar are incompatible in the equal to operator.

SQL search error - Argument data type text is invalid for argument 1 of lower function.

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


Read more...

Environment

The issue could be reproduced before below COMMERCE versions with SQLServer database.

  • COMMERCE 2105.10
  • COMMERCE 2011.20
  • COMMERCE 2005.25
  • COMMERCE 1905.41

Product

SAP Commerce 1905 ; SAP Commerce 2005 ; SAP Commerce 2011 ; SAP Commerce 2105

Keywords

rule engine, rule content, rulecontent, rule_content, advence search, promotion, promotion engine , KBA , CEC-SCC-COM-PRO-RE , Rule 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.