cancel
Showing results for 
Search instead for 
Did you mean: 

Short Dumps Occurring with description SAPSQL_ARRAY_INSERT_DUPREC

Former Member
0 Kudos

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.

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

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