Repeat delta gets 0 records

[Former Member]

Hi Gurus,

Further update to Infocube from DSO was taking long time in the process chain. I killed the Process manually.Set the QM status to red in Process monitor and also red in the Infocube and deleted the request from infocube. I have unfortunately also deleted the request in the PSA and the repeated the delta. I got zero records.

2. So to get the records from the ODS. I have to delete the init request from DSO to Infocube. Then I did init without data.I removed the datamart symbol from the ODS and now I did delta. I got more number of records then expected. Can someone please help me in getting the exact delta from the ODS.

[Former Member]

Hi mohan,

Using IP we can do the request based loading. Use the full ip and in selections give your delta load request id.

Make this full load as repair full request.

Once this is done. Now delete your init and do re-init with out data transfer.

From next day onwards your delta will run correctly.

Next time when you do repeat delta, apart from making request red and delete make sure datamart status is removed for the request.

Regards,

Venkatesh

[Former Member]

Hi Venkatesh,

I need few clarifications before I proceed with the solution you have provided.

1. Before doing the repair full request do i have to removed the datamart status.

2. In selection tab I am not able to see the request field, so that i can do repair full based on request.

3. If I am doing the repair full I gues the delta's are not disturb.So I may not have to delete the init and then set the init again.

Thanks

--Mohan

[Former Member]

Hi mohan,

1) no need to remove the data mart status.

2) generally we will have that field.

3) as a good practice i told, no need to run the init again.

Regards,

Venkatesh.