SAP Knowledge Base Article - Preview

1835575 - SAPSQL_ARRAY_INSERT_DUPREC dump in AGS_UPDATE when applying updates

Symptom

  • When running "Apply updates" via transaction AGS_UPDATE, a dump occurs.
  • Also the daily automatic run of Service Content Update with the job SM:SERVICE CONTENT UPDATE returns a daily dump with information like:

    • Runtime Errors         SAPSQL_ARRAY_INSERT_DUPREC
      Exception              CX_SY_OPEN_SQL_DB
      ABAP Program: "SAPLAGS_DSWP_GENERAL" or "LAGS_DSWP_GENERALU08"
      The exception, which is assigned to class 'CX_SY_OPEN_SQL_DB', was not caught in procedure "AGS_DSWP_APPLY_SERVICE_UPDATE" "(FUNCTION)", nor was it propagated  by a RAISING clause.

    • Runtime Errors         DBSQL_DUPLICATE_KEY_ERROR
      Except.                CX_SY_OPEN_SQL_DB
      Open SQL array insert produces duplicate records in the database.

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.


Read more...

Environment

  • SAP Solution Manager 7.20

Product

SAP Solution Manager 7.2

Keywords

SM:SERVICE CONTENT UPDATE, AGS_UPDATE, SAPSQL_ARRAY_INSERT_DUPREC , KBA , SV-SMG-SER , SAP Support Services , SV-SMG-OP , Solution Directory , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.