3404272 - [303]: invalid DATE, TIME or TIMESTAMP value: Error while parsing

Background:

You have a working Data Transfer Process (DTP). You have environment where execution does not result error (e.g. SAP HANA 1.0). 

Issue:

In the other environment (e.g. SAP HANA 2.0) you receive SQL Error Code 303 - "invalid DATE TIME or TIMESTAMP value".

Example:

Further you check the indexserver trace files you see: "invalid DATE, TIME or TIMESTAMP value: search table error" and "invalid DATE, TIME or TIMESTAMP value: Error while parsing".

[0000000]\{000000\}[000/0000000000] 2023-09-20 15:11:14.994026 e SQLScriptExecuto trex_llvm.cc(00386) : Llang Runtime Error: Exception::SQLException303: invalid DATE, TIME or TIMESTAMP value: Error while parsing 2023-06-1520:36:00 as TIMESTAMP

You realize SAP HANA does not understand the string as a valid timestamp: "2023-06-1520:36:00". There is supposed to be a space between the '15' (days) and the '20' (hours) for SAP HANA.

SAP HANA, platform edition

SAP, HANA, SQL, error, code, 303, invalid DATE TIME or TIMESTAMP value, search table error, Error while parsing, ABAPVARCHARMODE  , KBA , HAN-DB , SAP HANA Database , How To