SAP Note 140212 - SAPSQL_ARRAY_INSERT_DUPREC when creating an address

Composant : Address Management / Business Address Services -

Solution : https://service.sap.com/sap/support/notes/140212 (Connexion à SAP Service Marketplace requise)

Résumé :
SAPSQL_ARRAY_INSERT_DUPREC dump occurs when creating new addresses, such as customer or vendor master addresses, and can also affect private and user master addresses involving tables like ADRT and ADRP. To resolve, check number ranges using Transaction SA01 and realign them based on the highest number allocated in ADRC or ADRP tables, ensuring the assigned number range in SA01 exceeds this value. Additionally, inspect related SAP Notes 170907, 175154, and 445575 for overlapping number range issues in customizing addresses and historical number reset problems which may contribute to the error.

Mots Clés :
symptom short dump sapsql_array_insert_duprec occurs, prerequisites number range level, current address number interval, current number range status, number range status, delivered current number, overlapping number ranges, newly generated number, highest address number, predefined number range

Notes associées :

445575Report for determining the highest assigned address number
444154SAPSQL_ARRAY_INSERT_DUPREC during creation of a user
175154SAPSQL_ARRAY_INSERT_DUPREC for processing communication data
170907SAPSQL_ARRAY_INSERT_DUPREC when creating an address
25182Inconsistencies due to address transport