BW Bridge: DTP Filter doesn't fetch any records but there is data to be processed

[mitko1994]

Hello everyone,

I have a data flow from one standard ADSO to another standard ADSO via an InfoSource. Both transformations have SQLScript Expert Routines. I went ahead and created a full DTP with a filter on 0CALMONTH. When I run the DTP, no data is retrieved nor processed. If I run the full DTP without a filter, the load runs fine. I'm sure the source has data for the selection because I'm able to see records for the same filter selection in the HANA Database Explorer. If I create an intermediate ADSO to "stage" the data inbetween, both transformations routines run fine and are able to load data to and from the intermediate ADSO. Any ideas what might be causing the issue with the InfoSource flow?

EDIT: I added a screenshot of the DTP Monitor

[roland_szajko]

Does the data reach your expert routine? Do you see data in INTAB in the AMDP debugger?

Are you using a static filter in the DTP or a filter routine? Is the filter routine producing the expected filter criteria? If you are using a filter routine, have you tried with a static filter?

[mitko1994]

It's a static filter on 0CALMONTH. I will attach screenshot from the DTP monitor

[mitko1994]

I tried executing the DTP in Simulation, but for some reason the debugger is not active, so I can't really debug it.