we are loading data from PSA to Write Optimised DSO, but only 1 requests is fetched though PSA is habing 15 requests

[Former Member]

In psa we are having 15 requests,in dtp settings we are having get all request by request setting checked. It needs to fetch all the request from psa 1 by 1

but it is fetching only 1 request means old request from psa and not fetching any more request. what need to be done  . Thanks in advance.

[sander_vanwilligen]

Hi Prabhakar,

Can you please confirm if my reply of Feb 23, 2014 12:31 AM is clear?

If not, please let me know how I can help you further.

Thanks,

Sander

[sander_vanwilligen]

Hi Prabhakar,

If I understood you correctly, you activated the indicator "Get All New Data Request by Request". I think that this setting should process the 15 requests one by one.

On-line help says the following:

This indicator belongs to a data transfer process (DTP) that gets data from a DataSource or InfoPackage in delta mode. To prevent DTP requests from becoming too large (when the source contains a large amount of data) to be sent to the target as one DTP request, delta DTPs can be used to get the data by requests.

Furthermore, I find in on-line help:

For reasons of downward compatibility, the system behaves differently for DTPs that were created before SAP NetWeaver 7.0 Support Package Stack 13:

DTPs for which the indicator is set only get the first new request, even if there is more than one new source request at the time of processing. This restricts the way in which these DTPs can be used in process chains, because requests accumulate in the source and the target may not contain the current data.  The Retrieve Until No More New Data indicator is therefore displayed for these DTPs.

We recommend that you set this indicator and activate the DTP.

What is your BW release and SPS level?

If it is release 7.0 SPS12 or lower, then activate the "Retrieve Until No More Data" indicator.

Otherwise, I suggest to delete all data in the target, re-activate the DTP and execute the DTP once again.

Best regards,

Sander

[RamanKorrapati]

Create a new dtp and select dtp settings request by request.TRy to load the data.

it may works