Current Position:Home > DTP does not fetch all records from Source, fetches only records in First Data Package.

DTP does not fetch all records from Source, fetches only records in First Data Package.

Update:10-11Source: network consolidation
Advertisement
Fellas,
I have a scenario in my BW system, where I pull data from a source using a Direct Access DTP. (Does not extract from PSA, extracts from Source)
The Source is a table from the Oracle DB and using a datasource and a Direct Access DTP, I pull data from this table into my BW Infocube.
The DTP's package size has been set to 100,000 and whenever this load is triggered, a lot of data records from the source table are fetched in various Data packages. This has been working fine and works fine now as well.
But, very rarely, the DTP fetches 100,000 records in the first data package and fails to pull the remaining data records from source.
It ends, with this message "No more data records found" even though we have records waiting to be pulled. This DTP in the process chain does not even fail and continues to the next step with a "Green" Status.
Have you faced a similar situation in any of your systems?  What is the cause?  How can this be fixed?
Thanks in advance for your help.
Cheers
Shiva

The Best Answer

Advertisement
Hello Raman & KV,
Thanks for your Suggestions.
Unfortunately, I would not be able to implement any of your suggestions because, I m not allowed to change the DTP Settings.
So, I m working on finding the root cause of this issue and came across a SAP Note - 1506944 - Only one package is always extracted during direct access , which says this is a Program Error.
Hence, i m checking more with SAP on this and will share their insights once i hear back from them.
Cheers
Shiva
  • DTP does not fetch all records from Source, fetches only records in First Data Package. Update:10-11

    Fellas, I have a scenario in my BW system, where I pull data from a source using a Direct Access DTP. (Does not extract from PSA, extracts from Source) The Source is a table from the Oracle DB and using a datasource and a Direct Access DTP, I pull da

  • ODS Activation - Number of Records Per Data Package Update:11-30

    Hello, We are using the default Global ODS Setting called "Min Num of Data Records"... which defaults to 10,000. However, when I activate the ODS and look at the job log, I see that less than 10,000 records are in most of the data packages.  Bel

  • Function modules transfer  repeated records in Generic data source Update:11-30

    Hello Friends , I have created a FM to extract the data from fields of  tables BKPF and BSEG . This functional module is used in the Generic data source. Now if I check in RSA3 for this Generic data source, the records are coming 10 times instead of

  • Data Package 1 ( 0 Data Records ) at DTP with Status RED Update:11-30

    Hi All,    For 0 records at DTP level it is showing Overall status & Technical status as RED and yellow beside Data Package 1 ( 0 Data Records ).  There is no short dump no error message. At PSA level in status tab the message displayed is Status 8 w

  • Deleting duplicate records from different data packets in BI data source. Update:11-30

    Hi, I am getting same (duplicate) records from different data packets in BI data source, after completion of extraction. I tried to store key fields of the first data packet in an internal table. But this internal table is not carrying the previous d

  • Data Package Issue in DTP Update:10-11

    Hi gurus, My dataflow is like datsource->infosource->wrute optimised DSO with semantic key.. In source , i have 10 records in that 7 records are duplicate records. I reduced the DTP datapackage size from 50000 to 5. When i excuted the DTP , i got 2

  • Error In DTP:Data package 1 / XDateX  XTimeX Status 'Processed with Errors' Update:11-30

    Hi, While Pushing the data from the DSO(0PP_DS01 - Planned/Actual Comparison Order/Material View) to Cube 0PP_C15 -( Backlogged Production Orders). Getting the Error as : Data package 1 / XDateX  XTimeX Status 'Processed with Errors' When checked the

  • Impact of Changing Data Package Size with DTP Update:11-30

    Hi All, We have delta dtp to load data from DSO to infocube. Default data package size with dtp is 50,000 records. Due to huge no of data, internal table memory space is used and data loading get fails. Then we changed the data package size to 10,000

  • The ADO NET Source was unable to process the data. ORA-64203: Destination buffer too small to hold CLOB data after character set conversion. Update:10-11

     We developed a SSIS Package to pull the data From Oracle source to Sql Server 2012. Here we used ADO.Net source to pull the records from Source but getting the below error after pulling some 40K records.   [ADO NET Source [2]] Error: The ADO NET Sou

  • Record all the data acquired by DAQ Update:10-11

    Hi all, I have a problem when I tried to record all the data acquired by the DAQ card. My DAQ is NI 6259, and the Labview version is 2009. Basically, what I need do is using multiple channels to get the voltages of different point, then I subtract va