cancel
Showing results for 
Search instead for 
Did you mean: 

Error Activating the ODS data

majeed_mohammedabdul
Active Participant
0 Kudos

Hi Guys,

I am facing an error while activating the data in the ODS.

The data is loading perfectly fine but when activating the ODS data the following error is coming

<b>Request REQU_3ZI9CZ369HR6SM49OL9ULRVKM, data package 000031 incorrect with status 5 in rsodsacstreq

System error occurred (RFC call)

No confirmation for request ODSR_3ZI9DUVOMM02L1I777X5YX9QU when activating the ODS object PA_ODS1

There is no PSA for InfoSource 8PA_OA001 and source system BWPCLNT641 ( The data laod is without PSA )</b>

This is happening after we had a BWQ refresh .

I thought this has something to do with the BASIS guys but they say they checked everything.

Need Help

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

Sorry I'm unable to give u these details as my server not working now..

Any have u got solved ur problem I i think..

Regards

Siddhu

Reward points if it helps & close the thread

Message was edited by: sidhartha

majeed_mohammedabdul
Active Participant
0 Kudos

Thanks anyways Man,

u r the man .

I guess i have , I started the activation it might take a bit of time.

I will keep u posted .

I figured that out , there is a button set status on the top , we have to select the program class and click that button.

it gives us the warning . we have to select yes

Hope this solves my problem

full points to u buddy

Thanks a ton

Majeed

majeed_mohammedabdul
Active Participant
0 Kudos

Hey Sidhu,

It did work man.

thanks a lot

Former Member
0 Kudos

Hello guys,

I'd faced with the same problem and your solution has help me. Thank you.

But I am still wondering how you found out this transaction RSSGPCLA

Answers (4)

Answers (4)

Former Member
0 Kudos

Hi,

Solution

Execute transaction "RSSGPCLA".

Set the status of the programs belonging to program classes "RSDRO_ACTIVATE", "RSDRO_UPDATE" and "RSDRO_EXTRACT" to "Generation required".

To do this, select the program class and then activate the "Set statuses" button. IMPORTANT: Reset the three named program classes only.

Refer oss note: <b>518426</b>

Regards

Siddhu

majeed_mohammedabdul
Active Participant
0 Kudos

Thanks Sidhu,

Seems like solution made for my error.

But what do mean by Generation required

In my Program class it is selested as "T"

can u help me in this.

And probably we are facing this because we did a refresh jsut a few days ago and it is having problems from then only.

Thanks again

Majeed

Former Member
0 Kudos

Hi,

Can u give error messeage from SM21, ST22.

What is error message in the detail tab and step by step analysis..

From the error message it is clear that data is recieved.

Regards

Siddhu

majeed_mohammedabdul
Active Participant
0 Kudos

Hi Sidhu

I dont have any messages in SM22 but Sm21 have lot of error messages

Here are some of them

RSDRO: Error RSAODS 203 raised

RSDRO: 1:8PA_OA001 2:BWPCLNT641

These are the messages which are repeated many times

and many are ALEREMOTE message performing roll back

but I am not sure whether they are for my ODS

Regards

Majeed

majeed_mohammedabdul
Active Participant
0 Kudos

And In the step by step analysis there are nothing everything is green

and in the details tab under subsequent processing there are error messages which i posted in the very first post

hope this helps

Regards

Majeed

Former Member
0 Kudos

Hi,

<i>data package 000031 incorrect with status 5</i>

Have checked the datapacket size..

<i>No confirmation for request ODSR_3ZI9DUVOMM02L1I777X5YX9QU</i>

And also check is there any old request which r not active

If so activate it by finding that request in RESREQDONE table..

Regards

Siddhu

majeed_mohammedabdul
Active Participant
0 Kudos

Hi Sidhu,

There were red requests in the ODS but I deleted them and tried activating the green requests , even when there are only 4 records it is not activating the data.

I checked the RESREQDONE table but I dont see these requests in there.

I checked the SM58 there I saw a lot of errors

<u><b>ALEREMOTE RSAR_TRFC_DATA_RECEIVED BWQCLNT641 10/17/2005 18:50:48 ERROR REQU_3ZHNIS265F9F6HJQ8PY838046 PG# 21 In BW</b></u>

one line in that is this . can u throw some thought on this. when I try to execute this LUW it says that function module RSAR_TRFC_DATA_RECEIVED doesnot exist or exception raised message. I got these yesterday but today I got only one and when I executed that LUW it gave me the same message but that error message is not showing now

Regards

Majeed

Former Member
0 Kudos

Hi,

I think while loading to ODS u must use the option via PSA, ods objects use 0RECORDMODE values to implement the delta update..

Check RFC connection by right on the source system..

If u didnt set activate automatically in the settings of ODS.. u have to activate it by manually by selecting particular request in the data target manage..

Regards

Siddhu

majeed_mohammedabdul
Active Participant
0 Kudos

Thanks Sidharta for the reply.

1. I think while loading to ODS u must use the option via PSA....

We are doing a ODS to ODS Full load ( self feed ). that is the reason we did not a load thru PSA. It was working fine for many years now.

2. check RFC connection .... I checked it it is fine.

3. As for setting the activate automatically in the settings , we are doing this in the process chains