Delta request is not available in manage---> requests tab

[Former Member]

Hi All,

By mistake process chain trigger automatically in that process chain data loading delta form CRM to ODS (1st data target) it went fine and request is available in manage tab in 1st level ODS. From 1st ODS to 2nd ODS request is not available in manage tab.

When we try to load the data from 1st ODS to 2nd ODS load is getting failed with error message. REQXXXXXXXXXXXX(request is number ex- 12345) delete or please edit.

Those system giving message requests I can see only by using RSRQ tcode.but it is not available in manage under requests tab.

Now I want delete this request how it will possible.

Is there any table I can go and delete then I can do the delta from 1st ODS to 2nd ODS.

Please help on this issue.

Thank in advance (Points will be assign)

Kumar.p

[Former Member]

Hi Kumar,

if u r loading delta thro PSA, you can find that request in PSA list. right click on datasource of 1st ODS and manage.

[Former Member]

Hi Kumar ,

Hope these tables help you :-

1 . RSTSODSREQUEST

2. RSTSODSREQUESTPG

3. RSREQICODS

4. RSBODSLOG

5. RSBODSLOGSTATE

These are some of the tables for ODS in Bw 3.5 .

Regards,

Lokesh

[Former Member]

Hi Kuamr,

You can check if the request is avilable in RSBKREQUEST table in SE11 tran.

Hope it helps!

Regards,

Pavan

[Former Member]

Hi

Thanks for your quick responds.

when i try to check this table in SE11 i am getting message like RSBKREQUEST does not exist.

this table is available in BI7 but we are using BW 3.5

Can you please let me know table name.

Thanks.

Kumar

Edited by: kumar reddy on Feb 10, 2011 6:08 AM

[Former Member]

Hi Kumar,

If its BW3.5, then check the table RSICCONT.

Regards,

Pavan