on 2007 Jul 20 3:18 AM
Hi can anyone tell me how to monitor loads n explain common errors we come across n how to solve them. Thanks
HI,
If you monitoring the loads from process chain then go to T Code - RSPC. you can monitor from RSMO - Monitor, SM37 - Job overview, SM12 - Lock entries, sm66 - global work process overview. DB01 for database lock, ST04 for database overview.
Common errors
1. Short dump - go to st22 and check the error in runtime analysis screen
2. Lock error - go to sm12 and check lock entries
3. SQL error - check indexes for the same data target in performance tab if indexes OK then click statistics if its RED then create statistics or refresh statistics
4. Failed at Aggregate - go to se38 give program name RSDDK_CHECK_AGGREGATES and click execute , it will give details aggregate log file
5. Duplicate records - go to PSA delete duplicate record and repeat
Thanks
Cyagnik
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Arman,
We monitor several data loads using Process chain monitor. Execute tcode RSPC ->Locate your process chain-> click on it-> then click on Log button-> here select proper date interval-> you will be able to see the log of process chain for that time interval.
OR you can use tcode RSPCM to monitor daily process chains.
Please note that we do all above in 'real BW world scenario'.
And when Loading time you will get maximum these type os errors....
1. Time stamp error.
sol: activate the data source and replicate the data source and load.
2. Data error in PSA.
sol: Modify the in PSA error data and load.
3. RFC connection failed.
sol: raise the ticket to BASIS team to provide the connection.
4. Short dump error.
sol: delete the request and load once again.
AND
5. Data locking when loading in parallel.
6. ODS activation failures.
7. Unrecognised characteristics.
REGARDS
@JAY
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
You can monitor the loads from T.code RSMO, here you can see what are loads are running on the system, to see back ground jobs use SM37, to monitor process chains use tcode RZ20 or RSPCM.
Regards
Sankar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
69 | |
13 | |
11 | |
10 | |
9 | |
9 | |
6 | |
6 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.