DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
mohan2312
Participant



Joined: 16 Oct 2012
Posts: 4
Location: Hyderabad
Points: 28

Post Posted: Mon May 08, 2017 4:08 am Reply with quote    Back to top    

DataStage® Release: 11x
Job Type: Parallel
OS: Unix
I am using generic job to extract a table and load the same table in another schema using RCP enabled in the job. The target connector ( oracle) has a reject link with ERROR CODE and ERROR TEXT columns selected.

When I ran the job and there were rejects, I could only see ERROR CODE and ERROR TEXT in the reject file. I would like to see the actual record to take corrective action.

Please suggest how do I design the job to be able to see actual record ( actual columns along with ERROR CODE and ERROR TEXT).
anudeepdasari001
Participant



Joined: 14 Dec 2015
Posts: 36
Location: Arizona
Points: 313

Post Posted: Tue May 09, 2017 6:51 am Reply with quote    Back to top    

Try checking with Disabling RCP and Map all the columns till the Target connector,Then you can check the columns list on the oracle connector output tab for reject link.

_________________
anudpETL
Rate this response:  
Mike



Group memberships:
Premium Members

Joined: 03 Mar 2002
Posts: 983
Location: Omaha, NE
Points: 6324

Post Posted: Tue May 09, 2017 7:33 am Reply with quote    Back to top    

How did you look at your reject file?

Mike
Rate this response:  
cdp



Group memberships:
Premium Members

Joined: 15 Dec 2009
Posts: 105
Location: New Zealand
Points: 1505

Post Posted: Tue May 09, 2017 4:27 pm Reply with quote    Back to top    

In your target Oracle Stage output/columns tabs...
Is the 'Runtime column propagation' box checked ?
Rate this response:  
mohan2312
Participant



Joined: 16 Oct 2012
Posts: 4
Location: Hyderabad
Points: 28

Post Posted: Tue May 16, 2017 11:49 pm Reply with quote    Back to top    

cdp wrote:
In your target Oracle Stage output/columns tabs... Is the 'Runtime column propagation' box checked ?

Yes, in the target connector Runtime Column Propagation box checked.
Rate this response:  
mohan2312
Participant



Joined: 16 Oct 2012
Posts: 4
Location: Hyderabad
Points: 28

Post Posted: Tue May 16, 2017 11:55 pm Reply with quote    Back to top    

Mike wrote:
How did you look at your reject file?

I went and did view data on the reject file. Since there are only ERRORTEXT and ERRORCODE columns in the metadata so i am able to view only these two columns. I also went and checked the file in the unix path manually and the file also doesnt have other columns except the above two.
Rate this response:  
mohan2312
Participant



Joined: 16 Oct 2012
Posts: 4
Location: Hyderabad
Points: 28

Post Posted: Tue May 16, 2017 11:57 pm Reply with quote    Back to top    

anudeepdasari001 wrote:
Try checking with Disabling RCP and Map all the columns till the Target connector,Then you can check the columns list on the oracle connector output tab for reject link.

This is a generic job and I dont know the what columns will come for a table. That is the reason to go with RCP instead of mapping columns. I have to use same job to load multiple tables.
Rate this response:  
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours