2046524 - A column added to target table does not show in Table_Compare transform before the target in SAP Data Services

SAP Knowledge Base Article - Public

2046524 - A column added to target table does not show in Table_Compare transform before the target in SAP Data Services

Symptom

A newly added column to target table is not visible in Table_Compare transform that is before the target table in SAP Data Services.

Environment

SAP Data Services 14.2.1.224

Reproducing the Issue

1. Create a DataFlow with objects in sequence and connect them as follows: Source Table, QT, Table_Compare Transform, Target Table.

2. Add a new column to Source Table in Database client.

3. Reimport the modified table metadata.

Note: You can see the modified target table, but not updated in the Table_Compare transform.

Cause

The issue has been identified and logged under Problem Report ID ADAPT01731583.

Resolution

The issue will be fixed in Data Services !4.2 SP3.

To workaround the issue, you may perform any of the following:

  • Delete and Recreate the Table_Compare transform.
  • In the Table_Compare transform, change the Datastore information and change back the information.

Keywords

BODI, DI, XI, ADAPT, Table_Compare transform not updated, BODS , KBA , EIM-DS-EXE , Data Services Job Execution , Problem

Product

SAP Crystal Reports 2013