Problem when I want delete requeste.

[Former Member]

Hello expert

I want to delete requeste in the ODS.

I have this message when I delete one package and it did not delete this requeste.

No records found for request ODSR_CC0M0648MKWW0FFR9M04W1VMG in change log /BIC/B0001208000 in ODS

Best regards,

Farchid

[Former Member · Accepted solution]

Hi,

Some more Notes: 919133, 443334 (2001)

I too agree with Sergio, you have to make the code corrections.

Is data available in the the change log table?

and also check in Active table.

Can you check and let me know....

Regards,

Vijay Malyavantham

[Former Member · Accepted solution]

Hi Vijaya Kumar Malyavantham

the change log table is empty

How I can check the table ( if the transaction is rsrv : the ODS is OK)

Best regards.

Farchid

[former_member188972 · Accepted solution]

If the change log is empty you cannot delete a single request.

If you need to delete some data, you must take other ways like selective deletion or upload of data with negative image, but these methods doesn't give you any assurance to delete the same data of the request.

reagrds,

Sergio

[Former Member · Accepted solution]

how i have delete the datain the change log table.

best regard

Farchid

[former_member188972]

I suspect that you have defined the ODS also as export datasource and you have deleted the related PSA (i.e. the change log of the ODS) so is not possible to delete a single request.

If that is not true I think the problem is about the programs and you'll find other in OSS notes.

Regards,

Sergio

[Former Member]

Hi Farchid,

Is the ODS request which you want to delete is reportable? then you can't change the QM status.

Delete the request directly in the manage datatarget screen, check the job BI_DELR* with your user in SM37.

*Be careful if it is delta upload and no PSA exists.

Regards,

Vijay Malyavantham.

[Former Member]

Hi Vijaya Kumar Malyavantham

with the transaction i have see :

Request '28.488'; DTA 'TEPRO07'; action 'D'; with dialog ''

Leave RSM1_CHECK_DM_GOT_REQUEST in row 70; Req_State ''

No records found for request ODSR_6AMIWA3OPNCHCWUHKFOQZ2994 in change log /BIC/B0001069000 in ODS TEPRO07

Deletion of request REQU_3BKTOW8ZCC9Y9BMIEZ4PI32OO from data target TEPRO07 failed

Data to be deleted successfully checked against archiving objects

regards

farchid

[Former Member]

Hi Farchid,

From the error message i came to know about ODS information:

ODS Name:TEPRO07

ODS Table:/BIC/B0001069000

Request #: REQU_3BKTOW8ZCC9Y9BMIEZ4PI32OO

As per my admin's suggestion :

If you are working or BI NW 2004s you have to implement SP-7

Check this note: 907454

Regards,

Vijay Malyavantham.

[former_member188972]

Which is the status of the request?

[Former Member]

the status of the requestis green.

[former_member188972]

Is possible that message occurs when you make a second attemp to delete the request and the first was interrupted or not properly finished?

[Former Member]

i don't think because this request is an old request.

[former_member188972]

YOur release and patch of BW?

[Former Member]

SAP_BW 30B 0027