Qlik Replicate: Using bindDateAsBinary Leads to Data Inconsistencies

Sonja_Bauernfeind — Wed, 11 Jun 2025 09:36:18 GMT

A Qlik Replicate task may fail or encounter a warning caused by Data Inconsistencies when using Oracle as a source.

Example Warning:

]W: Invalid timestamp value '0000-00-00 00:00:00.000000000' in table 'TABLE NAME' column 'COLUMN NAME'. The value will be set to default '1753-01-01 00:00:00.000000000' (ar_odbc_stmt.c:457)
]W: Invalid timestamp value '0000-00-00 00:00:00.000000000' in table 'CTABLE NAME' column 'COLUMN NAME'. The value will be set to default '1753-01-01 00:00:00.000000000' (ar_odbc_stmt.c:457)

Example Error:

]E: Failed (retcode -1) to execute statement: 'COPY INTO "********"."********" FROM @"SFAAP"."********"."ATTREP_IS_SFAAP_0bb05b1d_456c_44e3_8e29_c5b00018399a"/11/ files=('LOAD00000001.csv.gz')' [1022502] (ar_odbc_stmt.c:4888) 00023950: 2021-08-31T18:04:23 [TARGET_LOAD ]E: RetCode: SQL_ERROR SqlState: 22007 NativeError: 100035 Message: Timestamp '0000-00-00 00:00:00' is not recognized File '11/LOAD00000001.csv.gz', line 1, character 181 Row 1, column "********"["MAIL_DATE_DROP_DATE":15] If you would like to continue loading when an error is encountered, use other values such as 'SKIP_FILE' or 'CONTINUE' for the ON_ERROR option. For more information on loading options, please run 'info loading_data' in a SQL client. [1022502] (ar_odbc_stmt.c:4895)

Resolution

The bindDateAsBinary attribute must be removed or set on both endpoints.

Cause

The parameter bindDateAsBinary means the date column is captured in binary format instead of date format.

If bindDateAsBinary is not configured on both tasks, the logstream staging and replication task may not parse the record in the same way.

Environment

Qlik Replicate

Re: Qlik Replicate: Using bindDateAsBinary Leads to Data Inconsistencies

korsikov — Mon, 12 Jan 2026 11:13:37 GMT

Hello Sonja.
we faced with the same problem in MSSQL Source / Target.
Invalid timestamp value '0000-00-00 00:00:00.000000000' in table 'dbo.Table1' column '_Fld1'. The value will be set to default '1753-01-01 00:00:00.000000000'

binddateasbinary parameter applicable for MSSQL?

article Qlik Replicate: Using bindDateAsBinary Leads to Data Inconsistencies in Official Support Articles

Qlik Replicate: Using bindDateAsBinary Leads to Data Inconsistencies

Resolution

Cause

Environment

Re: Qlik Replicate: Using bindDateAsBinary Leads to Data Inconsistencies