Hi,
Foll is the job.
Seq file read --> Transformer-->Oracle table load
The column 'FILE_CODE' is not propagated beyond transformer.
Still i am getting the error
"Oracle_Enterprise_15: Describe failed because of a missing column for FILE_CODE".
Write method=load
Write mode=append.
The column 'FILE_CODE' is not present in the table and is of no importance hence not propagated beyond the transformer.
'FILE_CODE' is the first column to be read of the input fixed width file.
I also went to the extent of trying putting the o/p of job1 in a dataset and
then in job2 the dataset -->oracle table.
in job2 there is no mention of 'FILE_CODE'. Still i am getting this error in job2 as well.
Can anyone please help?
Thanks,
Harshada
Describe failed because of a missing column, Oracle stage
Moderators: chulett, rschirm, roy
I had similar problem, but though it doesnt make sense, i added a modify stage inbetween the transformer and Oracle Load, and just a dummy specification like <in_col_name> = <out_col_name>
and it works for me, no more errors.
for eg: in your case, if the column name coming from sequential file is FILE_CODE and in transformer you are mapping that to FCODE that is the column name in oracle table, we usually get the error that you mentioned, that describe failed for FILE_CODE.
My work around is to add a modify between transformer and oracle stage and give just one dummy specification FCODE=FCODE, the input and output metadata for Modify stage is the same as Oracle table.
Try to see if this works for you.
and it works for me, no more errors.
for eg: in your case, if the column name coming from sequential file is FILE_CODE and in transformer you are mapping that to FCODE that is the column name in oracle table, we usually get the error that you mentioned, that describe failed for FILE_CODE.
My work around is to add a modify between transformer and oracle stage and give just one dummy specification FCODE=FCODE, the input and output metadata for Modify stage is the same as Oracle table.
Try to see if this works for you.
-
- Participant
- Posts: 46
- Joined: Fri Oct 06, 2006 6:36 am
- Location: Tucson