Qlik Replicate: Dataset Unload Failure Due to LocalDate and String Type Mismatch when using SAP Extractor

[lilizou]

Unloading data from a specific SAP Extractor may fail with the error:

[sourceunload ] [VERBOSE] [] Retrieved new data from Extractor 'ZDSGDZ037', Job 'GCDEX67T70NNYN27EH6U4AJ6BRTI4L' row '38932'
[sourceunload ] [VERBOSE] [] Failed to convert value at row 38933 for column 'DATE_FROM' of type 'DATS' value = '~{AQAAALKr+HRru6Zm/c2sIw6hKyA=}~'
[sourceunload ] [VERBOSE] [] value 'JAPAN' replaced by the invalid date placeholder '1970-01-01'
[sourceunload ] [VERBOSE] [] Retrieved new data from Extractor 'ZDSGDZ037', Job 'GCDEX67T70NNYN27EH6U4AJ6BRTI4L' row '38933'
[sourceunload ] [TRACE ] [] Removing existing extraction job for 'ZDSGDZ037' while aborting load data
[sourceunload ] [ERROR ] [] An error occurred unloading dataset: .ZDSGDZ037

Resolution

The issue has been resolved by addressing the problematic field in the SAP extractor ZDSGDZ037.

The DATE_FROM field has a short description of “Valid-from date – in current release only 00010101 possible”, and it was determined that this specific SAP date format is not supported by Qlik Replicate.

Change it to a valid value or exclude the DATE_FROM field if it's not necessary.

Cause

A data issue in the SAP extractor caused the failure.

Up to row 38932, all values were processed normally. The failure started at row 38933, where the following field could not be parsed as a valid SAP date:

• Column: DATE_FROM
• Type: DATS
• Value: ~{AQAAALKr+HRru6Zm/c2sIw6hKyA=}~

Qlik Replicate attempted to replace the invalid value with the fallback placeholder 1970-01-01, but failed to when the system produced a ClassCastException. This was caused by the program expecting the value to be a String, but instead receiving a LocalDate object.

The logs show the replaced value "JAPAN" being interpreted as an invalid date, which further confirms that the field contains non-date strings inside a DATS-type SAP field.

This indicates a data format inconsistency in the SAP source extractor, where a date field is populated with non-date content.

Environment

• Qlik Replicate