Symptom
"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."
Data Flow deployment failed with filter of Date/Time in Source Filters.
Group messages:
Group: default; Messages: Graph failure: XXXXX failed with the following error:
HTTP 400: {"requestId":"XXXXX","providerErrorCode":400,"message":"Bad Request","providerMessage":"[{\"message\":\"\\XXXXXLineItem WHERE EndDate >= 2025-02-20 14:43:50.0000000 AND EndDate <=\\n ^\\nERROR at Row:1:Column:70\\nunexpected token: '14'\",\"errorCode\":\"MALFORMED_QUERY\"}]"}
INZ-5000005: |Reader BODIVView1 Error number <5000005> occurred. There is no additional description. Message parameters are: <HTTP 400: {"requestId":"XXXXXX","providerErrorCode":400,"message":"Bad Request","providerMessage":"[{\"message\":\"\\XXXXXItem WHERE EndDate >= 2025-02-20 14:43:50.0000000 AND EndDate <=\\n ^\\nERROR at Row:1:Column:70\\nunexpected token: '14'\",\"errorCode\":\"MALFORMED_QUERY\"}]"}>.
Container is terminated. ExitCode=63
Environment
- SAP Datasphere
Reproducing the Issue
- Open Data Flow.
- Click on Source, change Source Filters, e.g. "Between 2025-02-20 14:43:50.0000000 AND 2025-02-21 14:43:56.0000000".
- Deploy the Data Flow.
Cause
The issue was caused by a known limitation in parsing date time format.
Resolution
Please try below workaround.
- Manually convert the filter values into below format: 'YYYY-MM-DDTHH:MM.sssZ' (e.g., '2025-02-18T14:43:50.000Z' and '2025-02-19T14:43:56.000Z' for your current filter) with the following steps:
Step 1: Click “Edit” in “Source Filters”
Step 2: Copy-Paste new format into the start and end value input:
2025-02-18 14:43:50.0000000 => 2025-02-18T14:43:50.000Z
2025-02-19 14:43:56.0000000 => 2025-02-19T14:43:56.000Z
Step 3: Click “OK”. The filter is updated. - Edit the Source Filters in source properties. Copy and past the converted date time values into the Date Time input. This will override the values from the Date Time picker.
- Save the filter and check the Source Filters in source properties. It should display as:
EndDate
Between 2025-02-20T14:43:50.000Z AND 2025-02-21T14:43:56.000Z - You can consider toggle "Apply filters upon data preview" and preview filtered data. In case there's no data in the Data Preview result please consider adjust the filter so there are matching records.
- Save and deploy the Data Flow. Execute and check the execution result.
Keywords
KBA , DS-DI-DF , Data Flows , CA-DI-IS-FA , Flow Agent , CA-DI-EMB , Data Intelligence Embedded in Data Warehouse Cloud , Problem