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

[nachtaktiv]

check the number-format of your 0CALMONTH-filter !

[mitko1994]

I already did that. My SQL query in the HANA DB Explorer has exactly the same WHERE clause as in the SQL statement generated by the DTP