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



Joined: 09 Dec 2008
Posts: 131

Points: 1360

Post Posted: Thu Dec 07, 2017 8:11 am Reply with quote    Back to top    

DataStage® Release: 8x
Job Type: Parallel
OS: Windows
Hi ,

in one of the ABAP stage , we want to extract data from one SAP Server.Job completed without fetching any records .
from Remaining abap stages data fectching.

Please let me know why data not fectvhing from one abap stage.

_________________
Siva
ray.wurlod

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 54072
Location: Sydney, Australia
Points: 293282

Post Posted: Fri Dec 08, 2017 7:43 pm Reply with quote    Back to top    

What's different (anything) about that particular ABAP stage?

_________________
RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong | Hobart | Brisbane
currently hiring: Canberra, Sydney and Melbourne
Rate this response:  
Not yet rated
ray.wurlod

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 54072
Location: Sydney, Australia
Points: 293282

Post Posted: Fri Dec 08, 2017 7:44 pm Reply with quote    Back to top    

Might that stage's query legitimately be returning no rows?

_________________
RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong | Hobart | Brisbane
currently hiring: Canberra, Sydney and Melbourne
Rate this response:  
Not yet rated
esivaprasad
Participant



Joined: 09 Dec 2008
Posts: 131

Points: 1360

Post Posted: Mon Dec 11, 2017 8:58 am Reply with quote    Back to top    

In other job , we had abap stage, in that we have 3 tables with inner joins between tables, data will fetching without any issue.
But particularly in this one job, we had abap stage , Required to extract only one table , but still data not fetching.
but in other jobs it extracting without issue.

_________________
Siva
Rate this response:  
Not yet rated
esivaprasad
Participant



Joined: 09 Dec 2008
Posts: 131

Points: 1360

Post Posted: Tue Dec 12, 2017 5:00 am Reply with quote    Back to top    

There are LFM1, LFA1and LFM2 tables in SAP all contains data.LFM1, LFA1 data are successully extracted from DataStage using ABAP stage but data is not being extracted from LFM2 through ABAP stage.This job contains ABAP stage ---Tranformer -Sequential file stage(No tranformation logic).This job finish without any warnings but no data is extracted(but this LFM2 data conatins 6 records in SAP table). Datastage version 8.1.
Is it environment issue or ds version issue ?

_________________
Siva
Rate this response:  
Not yet rated
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