SAP Note 18079 - Rollup: SAPSQL_ARRAY_INSERT_DUPREC

Symptom:

When trying to carry out a rollup, the system terminates with a runtime error: 'SAPSQL_ARRAY_INSERT_DUPREC' (duplicate records).

Cause and prerequisites

There might be several causes:

• If the system terminates when writing line items, it might be that the number intervals for rollups (number range object GL_ROLLUP) were reset.

• Another cause (irregardless of whether line items are to be written or not) could be that rollup records which are created through summarization, only differ from one another with respect to the additional unit of measure. Since the additional quantity unit (AUNIT) is only available in the data part of the database, the above described error occurs.
  Example:
  Account Business area RUNIT AUNIT ASL
  400000 M001 KG BAR 50
  400000 B001 KG LITER 30
  
  By leaving out the dimension 'Business area', the above case occurs.

Solution

• The error with the reset number range interval can be eliminated by setting the rollup number interval (see table T889, transaction GL20) for the number range object GL_ROLLUP using the transaction SNRO back to its old status.

• The error with the additional units can really only be solved by the customer because a standard SAP solution for the problem is not provided due to the DB design.
  Possible solutions for the customer are, leaving out the additional units in the rollup ledger (see Customizing) or converting the different additional units of meaasure within a user exit.