on 2011 Dec 23 2:26 PM
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?
Request clarification before answering.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@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.
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
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.
User | Count |
---|---|
90 | |
11 | |
9 | |
8 | |
6 | |
5 | |
4 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.