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
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.