cancel
Showing results for 
Search instead for 
Did you mean: 

Unable to delete Request in Infocube

Former Member
0 Kudos

Hi All,

I am Unable to delete request from my info cube . the info cube is not allowing me to delete request .

When ever i am trying to delete request It is Displaying ABAP DUMP Error.

Short text

The ABAP/4 Open SQL array insert results in duplicate database records

regards

Harish

Accepted Solutions (0)

Answers (5)

Answers (5)

Former Member
0 Kudos

Thanks alot for the information.....

former_member182470
Active Contributor
0 Kudos

Hi,

With the help of an ABAPer, pls analyze the dump.

If you have Aggregates on top of your Cube, you need to deactivate them first. Then you can delete from the Cube. If your request has already been compressed, it will not allow you to delete.

As suggested by others, you can try deleting through RSICCONT table.

Regards,

Suman

Former Member
0 Kudos

Hi

If particular request is already loaded further, then system will not allow you to delete the request. If you have any aggregates first deactivate them before you delete request in cube.

check the dump in ST22 and analyze it. if it is failed request first make the request red in DTP monitor and cube manage tab, then delete the same request.

Regards,

Venkatesh.

Former Member
0 Kudos

Hi,

You can delete request from the cube by using the program RSSM_ZOMBIE_REQUEST_DELETE if the cube has zombie request.

Or

You will need to first change the status of the request to RED. If you are not able to change the status use function module RSBM_GUI_CHANGE_USTATE to change the status of request to RED and then delete it.

Navesh

fatihanil
Participant
0 Kudos

This is useful. Function module solved my problem which request can not delete from cube despite its status was red.

Former Member
0 Kudos

If you loaded data using DTP then first mrak your request status in RED then click on Monitor which is just beside request status, It's goes to your DTP request then click on Delete symbol just beside Error Stack.

From here you can delete your request.

This issue occur due to insufficient authorization

Regards,

Sushant

Former Member
0 Kudos

Hi,

You can delete the request from RSICCONT.

1. Goto SE16

2. Select the Table name RSICCONT

3. Select the request and and click on Delete from Table entry Option from Menu bar.

It will permenently delted from Cube.

Regards