Page 1 of 1
Rejection with ODBC Stage in PX job
Posted: Mon Jan 21, 2008 4:56 am
by laxman.ds
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
Re: Rejection with ODBC Stage in PX job
Posted: Mon Jan 21, 2008 5:36 am
by mdan
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
Posted: Mon Jan 21, 2008 6:33 am
by laxman.ds
Hi...the structure of rejuction table:--
Data_Record Varchar 4000
Sql_Error_Code Varchar 100
Load_Sys Varchar 100
Load_Table Varchar 100
Re: Rejection with ODBC Stage in PX job
Posted: Mon Jan 21, 2008 6:38 am
by laxman.ds
Hi...the structure of rejuction table:--
Data_Record Varchar 4000
Sql_Error_Code Varchar 100
Load_Sys Varchar 100
Load_Table Varchar 100
Re: Rejection with ODBC Stage in PX job
Posted: Mon Jan 21, 2008 6:43 am
by laxman.ds
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
Hi...but the problem occured in sqlcode generated after the record is rejected....
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
Re: Rejection with ODBC Stage in PX job
Posted: Mon Jan 21, 2008 2:39 pm
by mdan
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