Oracle Load Problem
Moderators: chulett, rschirm, roy
Oracle Load Problem
I have developed a job to load the data to a Oracle database using oracle enterprise stage. Now at the end of the load if there are any rejects in the load process I have used a copy stage from the oracle enterprise stage to capture the rejects into a sequential file. The load is working fine, but the Reject copy stage and sequential stage doesn't work. I get the following error.
RejectFile: Error when checking operator: Could not find input field "CLM_KEY"
I have 17 fatal errors like this representing all 17 columns as output to reject.
The copy stage works as a reference(dotted) link from the output of the oracle enterprise stage but not a streaming link. This might be the reason it is not able to find the rejects even though all the column do exist. Can any one suggest me how do I capture the rejects from oracle enterprise stage or fix the problem I have. Please help.
Thanks
RejectFile: Error when checking operator: Could not find input field "CLM_KEY"
I have 17 fatal errors like this representing all 17 columns as output to reject.
The copy stage works as a reference(dotted) link from the output of the oracle enterprise stage but not a streaming link. This might be the reason it is not able to find the rejects even though all the column do exist. Can any one suggest me how do I capture the rejects from oracle enterprise stage or fix the problem I have. Please help.
Thanks
Regards
Kashif Khan
Kashif Khan
Re: Oracle Load Problem
In all probability you forgot to do the column mapping in the copy stage.
Go into the copy stage and go to Output --> Mapping and map the columns. After that it should be fine. Also, ivannavi is correct, you can directly link the reject link to the database stage.
Go into the copy stage and go to Output --> Mapping and map the columns. After that it should be fine. Also, ivannavi is correct, you can directly link the reject link to the database stage.
It took me fifteen years to discover I had no talent for ETL, but I couldn't give it up because by that time I was too famous.
Thanks for the suggestions.
Actually I was missing one column in the input file because of which all the others were not able to map accordingly. Copy stage works fine now. But I have another problem now. I get the followuing message and its a fatal error after this messgae.......
main_program: An NLS map <ISO-8859-1> is specified, but NLS_LANG is not set. The NLS map must be set to an ICU codepage which is equivalent to the character set specified by NLS_LANG
What has an ICU codepage to do with Oracle Load.
Does anyone know??
Actually I was missing one column in the input file because of which all the others were not able to map accordingly. Copy stage works fine now. But I have another problem now. I get the followuing message and its a fatal error after this messgae.......
main_program: An NLS map <ISO-8859-1> is specified, but NLS_LANG is not set. The NLS map must be set to an ICU codepage which is equivalent to the character set specified by NLS_LANG
What has an ICU codepage to do with Oracle Load.
Does anyone know??
Regards
Kashif Khan
Kashif Khan