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

  • SAP Commerce
  • SAP Commerce Cloud

Product

SAP Commerce Cloud all versions ; SAP Commerce all versions

Keywords

Advance, serach, drools, rule, not, working, backoffice, sql, error, data, type, text, nvarchar, incompatible, equal, invalid, unexpected, empty, content, hybris, commerce, ccv2 , 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.