Activation Queue Data not getting deleted

[rajat_agrawal2]

Hi all,

1) For one chain, since past one month, the data gets activated successfully without any request failures but then chain gets stuck and doesnt move forward to next step. Then I have to cancel the running Job and repeat the activation step, then it completes without any problem.

2) I checked the U table and found that the data has never been deleted from it ever since the chain started running inspite of the message that "U table for dataStore Object sucessfully deleted" shown in message logs. It has now 60 million records.

3) But since the problem started one month back, there is no message of "U table for dataStore Object sucessfully deleted"

after "Activation of records from DataStore object successfully finished". Even, Process Monitor option is no longer working.

Could anyone please suggest why ODS activation stucks after the message "Activation of records from DataStore object successfully finished" and does not proceed further? What is the possible solution for this?

Also, how come the data from U table never got deleted? Is it safe to delete the entire data now?

[Former Member]

hi,

please have a look at the following tables RSICCONT, RSREQICODS, RSBODSLOGSTATE

you can delete bad entries from RSODSACTREQ and RSREQICODS tables, care should be be taken while deleteing them else it is going to effect your daily loads in chain

SAP note 680480 can be helpful for you

regards

laksh

[rajat_agrawal2]

@laksh - I have already checked these tables and there are no failed requests, if that's what you mean by bad entries

@Kiran - carried out the RSRV test as well, runs fine, no problems whatsoever.

@Anindya - there is no such parameter in RSADMIN in ver 7.10. the note only mentions ver upto 3.5

When I checked the logs, there were no failed requests for the day the problem started or even before that.

Weird thing is even after getting the message "U table deleted successfully" (when there wasnt any problem), data from U table never got deleted. Now I dont even get this message.

[rajat_agrawal2]

I deleted entire data from the New Table of that DSO, but it didn't help.... from next day onwards, data again started getting stored in New Table. Any more ideas ??

[Former Member]

Hi Rajat

Can you please check your DSO is not Write Optimised as there is no U table deleted successfully log there. Also is there automatically activation option is checked or un checked. Moreover can you please post the whole displaying messages, Go to RSPC-Right click on your DSO and select Display Messages.

Looks like it not a major problem but we are unable to understand from the information provided by you so please provide bit more information and I am sure someone will help you out it.

Regards

Sunny

[rajat_agrawal2]

Hi Sunny,

DSO is a Standard one and the automatic activation option in unchecked (has always been like that)

Also, the displayed messages are as below -

Job started

Step 001 started (program RSPROCESS, variant &0000003626050, user ID ALEREMOTE)

Start process ODSACTIVAT ZPV_ACT_O02 in run 4OEE5FICDZQ0AC501QN69G90I of chain ZPCD_SR_0001

Activation is running: Data target ZBBPPO02, from 1,847,010 to 1,847,010

Overlapping check with archived data areas for InfoProvider ZBBPPO02

Data to be activated successfully checked against archiving objects

Program RSBATCH_EXECUTE_PROZESS successfully scheduled as job BIBCTL_4OEKDQYQA4KG9GSEBEOQ5WLNM with ID 02122900

.

.

Parallel processes (for Activation); 000005

Timeout for parallel process (for Activation): 006000

Package size (for Activation): 010000

Task handling (for Activation): Backgr Process

Server group (for Activation): No Server Group Configured

Activation started (process is running under user ALEREMOTE)

Not all data fields were updated in mode "overwrite"

Process started

.

Process completed

.

.

Activation ended

Data pkgs 000001; Added records 1; Changed records 0; Deleted records 0

.

.

Data pkgs 000154; Added records 1; Changed records 0; Deleted records 0

Log for activation request ODSR_4OEKDQR1R5YQQU8Y5KMDVUMXU data package 000001...000154

Activation of records from DataStore object ZBBPPO02 sucessfully finished

The problem is, Chain hangs after this last message and New table data doesn't get deleted.

See if you can make something out of these messages.

[Former Member]

Hi Rajat,

We face similar issue

Could you kindly let me know who you handle this situation at last?

Best regards

Alex yang