Hi!
I am working on PX job. The Source is Dataset and target is SQLServer. To populate target i am using ODBC Stage,While doing Rejection process i am Getting following error:--
XfmReject: Error when checking operator: Could not find input field "sqlcode"
Can you please help me to come out with the same.
Regards,
Laks
Rejection with ODBC Stage in PX job
Moderators: chulett, rschirm, roy
Rejection with ODBC Stage in PX job
2 B 1 4 ALL
Re: Rejection with ODBC Stage in PX job
can you post the design of the reject capture ?
laxman.ds wrote:Hi!
XfmReject: Error when checking operator: Could not find input field "sqlcode"
Re: Rejection with ODBC Stage in PX job
Hi...the structure of rejuction table:--
Data_Record Varchar 4000
Sql_Error_Code Varchar 100
Load_Sys Varchar 100
Load_Table Varchar 100
Data_Record Varchar 4000
Sql_Error_Code Varchar 100
Load_Sys Varchar 100
Load_Table Varchar 100
2 B 1 4 ALL
Re: Rejection with ODBC Stage in PX job
Hi...the structure of rejuction table:--
Data_Record Varchar 4000
Sql_Error_Code Varchar 100
Load_Sys Varchar 100
Load_Table Varchar 100
Data_Record Varchar 4000
Sql_Error_Code Varchar 100
Load_Sys Varchar 100
Load_Table Varchar 100
2 B 1 4 ALL
Re: Rejection with ODBC Stage in PX job
Hi...but the problem occured in sqlcode generated after the record is rejected....laxman.ds wrote:Hi...the structure of rejuction table:--
Data_Record Varchar 4000
Sql_Error_Code Varchar 100
Load_Sys Varchar 100
Load_Table Varchar 100
for this i take copy stage and remove the sqlcode from output then its working fine...
Please clearify get the value of sqlcode....
Regards,
Laksman
2 B 1 4 ALL
Re: Rejection with ODBC Stage in PX job
Hi laxman.ds,
between the ODBC and your reject target add a modify stage and write into spec sqlcode=sqlcode. Be sure that you have the sqlcode column in the output.
It should work.
Dan
between the ODBC and your reject target add a modify stage and write into spec sqlcode=sqlcode. Be sure that you have the sqlcode column in the output.
It should work.
Dan