ABAP stage not fetching data

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
esivaprasad
Participant
Posts: 135
Joined: Tue Dec 09, 2008 10:35 am

ABAP stage not fetching data

Post by esivaprasad »

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
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

What's different (anything) about that particular ABAP stage?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Might that stage's query legitimately be returning no rows?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
esivaprasad
Participant
Posts: 135
Joined: Tue Dec 09, 2008 10:35 am

Post by esivaprasad »

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
esivaprasad
Participant
Posts: 135
Joined: Tue Dec 09, 2008 10:35 am

Post by esivaprasad »

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
Post Reply