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.


Read more...

Environment

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

  • COOMERCE 2105.10
  • COOMERCE 2011.20
  • COOMERCE 2005.25
  • COOMERCE 1905.41

Keywords

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