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.
Error in Reject file
Moderators: chulett, rschirm, roy
Error in Reject file
ANSHUL
-
- Participant
- Posts: 62
- Joined: Sat Mar 07, 2009 4:59 am
- Location: Chicago
- Contact:
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.
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.
Suresh Reddy
ETL Developer
Research Operations
"its important to know in which direction we are moving rather than where we are"
ETL Developer
Research Operations
"its important to know in which direction we are moving rather than where we are"
Add "$APT_PRINT_SCHEMAS" to your job and see if the schema going to your reject there is indeed an input field "ABC".
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>