Page 1 of 1
Oracle Load Problem
Posted: Wed Apr 25, 2007 9:57 am
by kashif007
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
Posted: Wed Apr 25, 2007 10:34 am
by ivannavi
Why do you need "Copy stage"? I have never used it. I have sussessfuly loaded rejected records either to Oracle table or to a file.
Re: Oracle Load Problem
Posted: Wed Apr 25, 2007 10:38 am
by sud
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.
Posted: Wed Apr 25, 2007 11:17 am
by kashif007
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??
Posted: Wed Apr 25, 2007 2:52 pm
by kashif007
Can anyone tell me how I can fix this error
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
Posted: Wed Apr 25, 2007 2:52 pm
by kashif007
Does anyone know how I can fix this error
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
Please
Posted: Wed Apr 25, 2007 2:53 pm
by kashif007
Does anyone know how I can fix this error
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
Its a fatal error
Please
Posted: Wed Apr 25, 2007 3:04 pm
by csrazdan
NLS support has to be enabled during installation. You need to check with your DataStage Administrator.
Posted: Wed Apr 25, 2007 3:14 pm
by kashif007
It is installed in my Datastage. It says I need to set the NLS_LANG which is I think a environmental variable, which I can't find. I am asking how will I be able to set it or reset. Or Just somehow get ride of the above mentioned error.
Posted: Wed Apr 25, 2007 3:46 pm
by kashif007
Found the solution. Metadata and data format used for load should be correct. NLS_LANG is in oracle which is set to AMERICAN by default