Error in Reject file

anshulroy · Post by **anshulroy** » Sun Jun 20, 2010 11:47 pm

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.

anshulroy · Post by **anshulroy** » Sun Jun 20, 2010 11:57 pm

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.

sureshreddy2009 · Post by **sureshreddy2009** » Mon Jun 21, 2010 12:00 am

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.

ArndW · Post by **ArndW** » Mon Jun 21, 2010 5:34 am

Add "$APT_PRINT_SCHEMAS" to your job and see if the schema going to your reject there is indeed an input field "ABC".

chulett · Post by **chulett** » Mon Jun 21, 2010 6:58 am

It's always a good idea to post complete and unedited error messages rather than something that may or may not be... close.