<FIELD> in input data set 0. Design Time Info error

clarcombe · Post by **clarcombe** » Mon Aug 29, 2011 7:22 am

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.

Question
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 ?

clarcombe · Post by **clarcombe** » Tue Aug 30, 2011 5:43 am

Solution found.

Added a copy stage with Force = True between RCP data set and OCI PX Connector.

Warnings disappear

clarcombe · Post by **clarcombe** » Mon Oct 17, 2011 6:43 am

And make sure there are no fields in the output of the copy stage. The copy stage must be entirely RCP.

Gazelle · Post by **Gazelle** » Tue Jan 15, 2013 1:17 am

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

lfong · Post by **lfong** » Tue Mar 19, 2013 10:47 am

You've enabled Runtime Column Propagation (RCP), and 'exposed' the same columns you are loading.

Turn off RCP and rerun your job.

ying · Post by **ying** » Thu Jun 08, 2017 4:08 am

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.

chulett · Post by **chulett** » Thu Jun 08, 2017 6:15 am