SAP Knowledge Base Article - Public

3621848 - Replication Flow error - unexpected type: expect payload type [][]any or arrow.Table, but received <nil>

Symptom

Transferring initial data failed due to the following error: unexpected type: expect payload type [][]any or arrow.Table, but received <nil>.
CorrelationID: XXXX

Inside partition message:
unexpected type: expect payload type [][]any or arrow.Table, but received <nil>

Environment

SAP Datasphere

Reproducing the Issue

While executing replication flow the error described in symptom section occurs.

Cause

Mismatched data types between what is on source system tables and target datasphere.

Resolution

  1. Confirm the cause by investigating SM37 job log and ST22 looking for similar errors.
  2. Identify what structure mismatched elements are related due to different data types.
  3. Consider combination of: restricting the source with mandatory known filters to limit the amount of records that will flow with Initial and Delta and 
    correcting target table in SAP Datasphere with right data types of fields, recreating the Replication Flow and marking existing target table as final target in Datasphere.

Keywords

RF, type data , KBA , DS-DI-RF , Replication Flows , Problem

Product

SAP Datasphere all versions