Page 1 of 1
<FIELD> in input data set 0. Design Time Info error
Posted: Mon Aug 29, 2011 7:22 am
by clarcombe
I am using RCP via a dataset to populate an Oracle table using the OCI connector PX stage.
However, it gives warnings for every field in the table even though the table is loaded
Code: Select all
OCI_CIBLE: Schema field SETID in input data set 0 not present in design time information. Extended field properties for this field will not be available.
Having seen some of the other responses on the board for this error, am I correct in thinking the only way to get round this is NOT use RCP or use the old OCI Enterprise stage ?
Posted: Tue Aug 30, 2011 5:43 am
by clarcombe
Solution found.
Added a copy stage with Force = True between RCP data set and OCI PX Connector.
Warnings disappear
Posted: Mon Oct 17, 2011 6:43 am
by clarcombe
And make sure there are no fields in the output of the copy stage. The copy stage must be entirely RCP.
Posted: Tue Jan 15, 2013 1:17 am
by Gazelle
Setting force=true didn't get rid of the warning message for us (we're using DataStage v8.5.0.1).
There's an APAR for DataStage Server v8.1, suggesting it is "working as designed", and to demote the message via the message handler:
http://www-01.ibm.com/support/docview.w ... wg1JR37908
Apparently the APAR was accepted for consideration in later releases (to not show the warning if RCP is used). Perhaps it has not yet been implemented as at v8.5.0.1
Posted: Tue Mar 19, 2013 10:47 am
by lfong
You've enabled Runtime Column Propagation (RCP), and 'exposed' the same columns you are loading.
Turn off RCP and rerun your job.
Posted: Thu Jun 08, 2017 4:08 am
by ying
clarcombe wrote:And make sure there are no fields in the output of the copy stage. The copy stage must be entirely RCP.
Thanks, that resolved my problem.
Posted: Thu Jun 08, 2017 6:15 am
by chulett
