delele Open Hub DTP



I create a Open Hub to test the functionnality and extracted data out of a cube with it without any problem. Now, I'd like to remove that Open Hub as I'm not gonna use it. The problem is that I can't since it seems it kept the request I executed somewhere (Delta extraction from Open Hub to Flat File). The thing is that I can't find any place where to delete that request so I can remove my DTP and Open Hub afterwards....

Sorry for the stupid question but I've been looking everywhere (apparently not...) and can't find anything.

Thanks for any help.

(1)

Hi John,

in SE38, RSBKDTPDELETE, execute this program and give DTP, technical name and execute.

DTP will be deleted.

Regards

Daya Sagar

(2)

Ok, it worked but now I get a short dump while trying to remove my Open Hub object.....

Seems like there's still some trace of that DTP or the requests somewhere. I guess I should not have used this program to delete the DTP

An exception occurred that is explained in detail below.

The exception, which is assigned to class 'CX_SY_REF_IS_INITIAL', was no

caught in

procedure "HANDLE_REQUEST_NO_NAV" "(METHOD)", nor was it propagated by a

RAISING clause.

Since the caller of the procedure could not have anticipated that the

exception would occur, the current program is terminated.

The reason for the exception is:

You attempted to use a 'NULL' object reference (points to 'nothing')

access a component (variable: "L_R_MAINTAIN").

An object reference must point to an object (an instance of a class)

before it can be used to access components.

Either the reference was never set or it was set to 'NULL' using the

CLEAR statement.

(3)

Maybe this could help:

[FAQ: Deletion of a Delta DTP with target as Open Hub |https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/oss_notes/sdn_oss_bw_whm/~form/handler]

(4)

Hi,

You need to delete all DTP requests previously loaded to the Open Hub.

First, you will need the Open Hub technical name and the last REQUID

2 ways:

-> Open the DTP and choose 'Last Request'. There will be a 5 or 6 digit ID for the last request.

-> Go to SE11, table RSBKREQUEST and search using the DTP technical name in the DTP field

Once you have the REQUID, go to SE38 and run program RSBK_DEL_DTP_REQ_FROM_OHD.

You will have to enter the technical name of the open hub, and the last request ID.

You can choose to do a test run first, and the system will retrieve all the previous request IDs.

Execute the program.

To check that it worked, you can try to reopen the DTP and select 'Last Request'. The system should not take you to the monitor window for the last request since there are none left.

Now, you should be able to manually delete the DTP from the modelling workbench as well as the Open Hub itself if required.

If the DTP was used in a process chain, you should get an error message with the technical name of the process chain. Once you delete this variant from the process chain, the DTP can be deleted.