cancel
Showing results for 
Search instead for 
Did you mean: 

Data deleted in data targets

Former Member
0 Kudos

Hi Gurus,

By mistake I have deleted the data in production from some data targets

all the data is still available in PSA (for 9 months).

This happened in two data targets from two data sources.

No. of records are not even 1 million.

Total no. of request for each PAS is 279.

Is there a way I can load the data in parallel or something.

which can complete the task faster. Right now I am selecting each request

and loading one by one.

Regards

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi

Are you in BI 7.0?

I am assuming this is a delta, in which case you can load to two targets at a time. Also since you have deleted from the data target you dont have to pull request by request. Just pulling one delta will bring all your requests into the target.

Regards,

Former Member
0 Kudos

You mean to say If i pull the latest request, it will bring all the data from Jan 1 till Oct 5?

Former Member
0 Kudos

Yes it would.

Regards,

Former Member
0 Kudos

No it did not. I tried.

Former Member
0 Kudos

Hi,

I guess you are in BW 3.5 system. In that case you need update one by one.

Regards

Akhan

Former Member
0 Kudos

HI,

If you are in 3.5 goto reconsturction and select all requet you need to load and go for reconstruction which will reconstruct all request one after the another. No manual intervention necessary.

incase of 7.0 do a init without datatransfer from PSA and give a full update request for 3 months and load all the data which will help you in completing the data load faster.

Hopet this helps for you.

Thanks,

Arun

Former Member
0 Kudos

Thanks...really apprecaite.

Regards

SAPWorkerL
Participant
0 Kudos

If the reload will take an extremely long time and you have a recent system backup, the other option is to retrieve the data from the system backup at the Oracle level and import it into your produciton system also at the Oracle level.

We did this once successfully for a single ODS that would have taken weeks to reload. The approach should really only be used in an extreme scenario such as this. If you are interested, respond and I can try to find the directions.

Answers (0)