Error deleting data from ODS

[Former Member]

Hi experts,

I'm tryng to delete incorrect request from a ODS (the only request that existed - a INIT), and I'm getting a message:

Performing check and potential update for status control table

Message no. RSM1490

Diagnosis

If data is loaded into an InfoCube, or existing data is edited (aggregated/compressed/deleted/got from a DataMart), then there is a change in  the potential reportability of the data , or the possibility of deleting data by request, or of aggregating or compressing.

This status of each one of these Cubes is stored in a status table, that is updated when there is any change to the status of a request in the Cube.

The system now analyzes the requests in the Cube and compares the calculated status with the status table.

If deviations from the status table arise then you are given the option of adjusting the status table.

System Response Procedure Procedure for System Administration

- I have checked that the requests in all objects (cubes), that take data from this ODS are already deleted

- I have checked and there were no dumps

Can you please help me fix this? I'm need to reload urgently

Many Thanks

Joana

[Former Member · Accepted solution]

Hi Joana,

if you only have one request in the DSO you can delete all the data using RSA1 transaction with option Delete Data in DSO instead of deleting the request in manage menu.

Regards.

Nacho

[Former Member]

Hi

As you have only one request in DSO, directly delete the data from DSO.

RSA1 --> search for your DSO --> right click --> Delete Data

or you can use process step in process chain to delete the data.

Regards,

Venakatesh

[Former Member]

first check in requests tab if status is shown as a updated to datamarts...

[Former Member]

Hi Ganesh

No, request was not updated to datamart, according to the status.

What do I have to do, now, that I have already try to delete that request (is marked for deletion)

Many thanks

Joana

[Former Member]

Hi Joana,

As you said its marked for deletion, check in SM37 for deletion job (BIDEL*) and make sure it completes successfully. Check if its cancelled or still in released state. Also if it is the only request in the DSO and you want to delete it, you may try to delete using Delete Data option.

"Call RSA1 > Search for your DSO, right click and Delete data."

Hope this helps.
Regards
Sai