Error:
The input schema column name is not used and the connector is configured to stop when unused columns are detected in the input schema.
Explanation:
The specified input schema column is present in the input schema, but it is not used in the SQL statement. The connector is configured to stop the job when the SQL statement does not use a column in the input schema.
Resolution:
Correct the SQL statement so that it includes all columns in the input schema of the Oracle connector or change the Drop unmatched fields property to Yes.
More Details:
The resolution of this error depends on whether the connector is configured to read data from a JDBC data source or write data to a JDBC data source
When the connector is configured to read rows from the data source, ensure that the SELECT statement that the connector uses to read the rows includes a column in its select list that corresponds to the column on the link. Alternatively, remove the unmatched column from the link.
The following table includes examples of scenarios and respective problems that you might encounter when the connector is configured to read data from a JDBC data source and the resolution for the problems.
| SELECT statement | Output link columns | Problem | Resolutions |
|---|---|---|---|
| SELECT A1, A3 FROM TABLE1 | A1, A2 and A3 | The link column A2 is treated as an unmatched column and results in error | Complete one of the following steps: Change the statement to - SELECT A1, A2, A3 FROM TABLE1 (OR) - Remove column A2 from the output link. |
| The SELECT statement is generated automatically and the source table TABLE1 contains columns A1, A3 and A4 | A1, A2 and A3 | The connector does not include the table column A4 in the generated statement and does not fetch data for it because it determines that a corresponding the column is not defined on the output link. But the connector includes column A2 in the generated statement because it is present on the output link and that leads to an error because the table does not have the column with that same name. | Complete one of the following steps: - Add column A2 to the table. (OR) - Remove column A2 from the output link. |
When the connector is configured to write records from the input link to the data source, each column on the input link must be referenced by one or more SQL statements that the stage uses to write records to the data source.
If a column on the input link is not referenced the behavior depends on the value of the Drop unmatched fields property. When this property is set to No, the connector reports an error, and the job fails.
When the property is set to Yes, the connector reports an informational message for each unused input link column to indicate that the column is ignored, and the job continues.
