How To Fix AQQIS_CNTRL022 - Fields &1 and &2 cannot be connected

AQQIS_CNTRL022 - Overview

• Message type: E = Error

• Message class: AQQIS_CNTRL - Join-Control InfoSet

• Message number: 022

• Message text: Fields &1 and &2 cannot be connected

What causes this issue?

The attempt at joining two fields failed.
This could be caused by the following:
No agreement in the technical properties of the fields (type, length,
decimal places).
The fields are already joined.
Field A from table A is already joined with another field C from table
B. For this reason, field A from table A can no longer be joined with
field B from table B.

System Response

The system issues an error message and will not allow you to continue with this transaction until the error is resolved.

How to fix this error?

Procedure for System Administrators

Error message extract from SAP system. Copyright SAP SE.

AQQIS_CNTRL022 - Details

• The SAP error message AQQIS_CNTRL022, which states "Fields &1 and &2 cannot be connected," typically occurs in the context of data processing or integration within SAP systems, particularly when dealing with data sources, data models, or data connections in applications like SAP BW (Business Warehouse) or SAP HANA.
  
  Cause:
  This error usually arises due to one of the following reasons:
  
  
  Incompatible Data Types: The fields you are trying to connect or relate have incompatible data types. For example, one field might be a string while the other is a numeric type.
  
  
  Missing or Incorrect Mapping: There may be a missing mapping between the fields in the data model or transformation process, leading to an inability to establish a connection.
  
  
  Field Properties: The properties of the fields (like length, precision, or scale) may not match, causing the connection to fail.
  
  
  Data Source Issues: The data sources from which the fields are being pulled may not be properly