Troubleshooting
Problem
When running a job that has a Transformer stage that is linked to an Oracle Connector stage, the following warning is seen: Item #: 28 Event ID: 27 Timestamp: 2013-05-07 15:11:42 Type: Warning User Name: testuser Message Id: IIS-CONN-NGBR-00019 Message: ora_connector: Schema field Test_Col in input data set 0 not present in design time information. Extended field properties for this field will not be available.
Diagnosing The Problem
In the Transformer stage, under stage properties, check if Runtime column propagation (RCP) is enabled for the link going to the Oracle Connector stage.
Resolving The Problem
To resolve this issue:
- Double click on the Transformer stage
- Click on 'Stage Properties'
- Click on the 'Outputs' tab and in the 'Output name' field, use the drop down to choose the appropriate link name that is going to the Oracle connector stage
- Uncheck the box next to 'Runtime column propagation'
- Click 'OK' and 'OK' again in the Transformer stage panel to exit
- Save and compile the job
- Run the job
Note: Other stages may see the same warning occur. Please contact IBM Technical Support for further assistance.
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21637093