Describe failed because of missing column for FLD02I

lohtc · Post by **lohtc** » Tue Jan 18, 2005 8:57 pm

Hit the following error message when trying to move a column from 1 oracle table to another. The compilation is ok but validation failed.

Source field: varchar2(eight), date format in YYYYMMDD eg: 20051230
Destination field: date [when imported to Datastage becomes timestamp]

The tranformation string used:
StringToTimestamp(DSLink3.FLD02I:"000000","%yyyy%mm%dd%hh%nn%ss")

The exact FATAL error message:
"Describe failed because of missing column for FLD02I"

Note: FLD02I is actually an existing source column. The above work when Write Method = Upsert. Upon changing to Write Method = Load, the error is encountered.

Any help is appreciated.

Eric · Post by **Eric** » Wed Jan 19, 2005 6:41 am

Write Method = Load

After the job has failed - if you set the 'write method' property back to 'Load' does the job work again?

If not then what is the property "Write Mode" set to ?

timsmith_s · Post by **timsmith_s** » Tue Feb 27, 2007 11:46 am

I am experiencing the same issue - is this a bug with the load/upsert settings of the oracle enterprise stage?