on 03-11-2010 1:46 PM
There are too many short dumps occurring which have the description: SAPSQL_ARRAY_INSERT_DUPREC
Itu2019s been generated by two background jobs:
SWWDHEX: used for deadline monitoring
SWWERRE: used for Restarting Work Items with Temporary Errors
Please guide why this is occurring & how to resolve it.
1. Run Transaction SM65
2. Select Goto ... Additional tests
3. select these options: Perform TemSe check
Consistency check DB tables
List
Check profile parameters
Check host names
Determine no. of jobs in queue
All job servers
and then click execute.
4. Once you get the results check to see if you have any inconsistencies
in any of your tables.
5. If there are any inconsistencies reported then run the "Background
Procesing Analyses" (SM65 .. Goto ... Additional Tests) again.
This time check the "Consistency check DB tables" and the
"Remove Inconsistencies" options.
6. Run this a couple of times until all inconsistencies are removed from
the tables.
When execute in producitive system, recommend to check with your basis colleauges (responsible component should be
BC-CCM-BTC)
Best Regards
Lauren
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.