SAP Knowledge Base Article - Preview

3700195 - Filter conditions not working as expected or being ignored

Symptom

  • A task with an SAP Applications source (ECC ERP S4HANA) is not working as expected
  • The task returns incorrect results, no results, or the wrong results.
  • The issue may occur after upgrading your CI-ds Agent.

Example 1:

("Transform1".Field1 in ( 'AA' , 'BB', 'CC'))

The result is that results from 'AA' are returned.

Using OR operator instead of IN for the filter produces better results in this example:

("Transform1".Field1 = 'AA' or "Transform1".Field1 = 'BB' or
"Transform1".Field1 = 'CC')


Read more...

Environment

Cloud Integration for Data Services

Product

SAP Cloud Integration for data services all versions

Keywords

IBP, websocket, job, push-down, bad data, problem, issue, not working, zero records, 0 records, 0 results , KBA , LOD-HCI-DS-AGNT , On-Premise Agent, Connectivity, Task Run errors , 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.