I Can not delete a request in my ODS

[Former Member]

Hello,folks:

I upload a repair full request into my own ODS object and then I want to delete this request after activating it,but failed.Anyone can tell me how to handle this without deleting the content of the ODS object?

Martin Xie

[former_member188972 · Accepted solution]

Did you load other request after the full one?

If yes, remember that you can delete only the last request in ODS.

If not, do you have other message about your error?

Take a look at this:

/people/sergio.locatelli2/blog/2006/11/14/delete-records-in-data-target-of-bi-different-options-available

Regards,

Sergio

[Former Member]

Hi,

The request in ODS can't be deleted in the following cases

1) IF the data is already uploaded to furthur data targets ( Data mart status green in ODS).In this case you have to first delete the data in the furthur data target and uncheck the data mart status.

2) If active rquests available after the request you want to delete.

When activating data many request may get activated once, so you cann't delete that requst.

In this case you have to delete all the requests after the specific request which you want to delete.

Regards,

Vijay G.

[Former Member]

In addition to what Vijay mentioned.

You cannot delete when there is a active load going in to this ODS or any activation taking place.

The ODS will be locked and you can see this in SM12.

You will have to wait or delete the lock to delete the request.

Mey

[Former Member]

In addition to above all-

You can not delte a request if it is compressed.

Good luck.

[Former Member]

But we do not have an option to compress ODS data.... Compression can happen only in Infocubes.....

plz note!!

[Former Member]

Hi Martin,

Is your ODS updating data into any other info-provider. If so, then you would need to delete the data there and then remove the datamart symbol and then delete the request.

Bye

Dinesh