Unable to delete request

[Former Member]

Hi All,

I am loading the data from R/3 system to BW 3.5 system.

While loading i am receiving short dump so i make the reuest red and tried to delete it from ODS.

But i am not able to delete that request.

The same thing is happening in 3 other ODS.

Please provide any pointers.

Regards,

Ritesh

[Former Member · Accepted solution]

Did you look at the Short dump? Please check DB02 and see if there is enough space left to load or even perform deletion.

We get such errors due to table space as well as archive logs... checking the basis team will help

[Former Member]

Hi Ritesh,

The problem is due to the Oracle database. The maximum number of extents of the table has been reached and hence the dump.

In order to avoid the dump, try to load the data based on selection criteria in info package. By doing this, instead of a extracting the entire data at once you can split the data into segments and bring to BI system.

-- Selva

[Former Member]

It might be possible that the deletion job itself giving the short dump. Pleease check in ST22. If that is the case, then there is issue with tablespace. Ask the Basis person to help you on this.

If dletion job is not giving the dump, then check the error message in SM37 to see why the deletion job is failing. Action accordingly.

Thanks.

Shambhu

[Former Member]

Hi,

The status of request is red.

Below given is the error i am getting (for deletion job):

Database error text........: "ORA-30036: unable to extend segment by 8 in undo

tablespace 'PSAPUNDO'"

Database error code .......: 30036

Thanks & Regards,

Ritesh

Edited by: Ritesh Bansal on Nov 15, 2010 4:57 AM

[MartinMaruskin]

According the dump it seems that it is a problem with underlaying ORACLE's table spaces. Check following note:

1045320 - ORA-30036 despite high number expired/unexpired undo extents

Or better to get in touch with your basis team they would need to extent this table space.

[Former Member]

this is table space issue ask Basis guys to extend or free some table space in BI

[Former Member]

What is the error message it is showing when you are trying to delete the request? and also please check once again the QM status of the request is set to RED or not