Page 1 of 1

Error in Reject file

Posted: Sun Jun 20, 2010 11:47 pm
by anshulroy
We have a new server. The jobs have been moved to this server. While executing the jobs, we are getting erro in reject files These errors are not coming when the same job is executing in the previous server. The errors are like columns input into the reject files are not available."Could not find input field "ABC"".
Can someone suggest if any specific setting needs to be done for the reject file as the server is completely new and the error is coming only in the reject file.

Posted: Sun Jun 20, 2010 11:57 pm
by anshulroy
One more important point is the errors are coming only in the reject files associated with lookup rejects. Is there any particular setting that we need to implement in this new server for lookup to resolve this issue.

Posted: Mon Jun 21, 2010 12:00 am
by sureshreddy2009
Welcome to DSXchange forum... :D

There is no setting needed when you move the jobs to different server.
Basically test the job first with out reject file , if it is working then give the reject link to the source , I guess the source file it self do not have that field. and see the reject file mode , whether it is overwrite or append.

Posted: Mon Jun 21, 2010 5:34 am
by ArndW
Add "$APT_PRINT_SCHEMAS" to your job and see if the schema going to your reject there is indeed an input field "ABC".

Posted: Mon Jun 21, 2010 6:58 am
by chulett
It's always a good idea to post complete and unedited error messages rather than something that may or may not be... close.