SAP Knowledge Base Article - Preview

2688939 - Error 2601: Attempt to insert duplicate key row in object 'syspartitions' with unique index 'nc2syspartitions' - SAP ASE

Symptom

  • "alter table dbo.mytable add partition (part89 VALUES (227))” fails with Error 2601:

Number (2601) Severity (16) State (6) Server (my ASE) Attempt to insert duplicate key row in object 'syspartitions' with unique index 'nc2syspartitions'

  • dbo.mytable is a list partitioned table with no partition named "part89".
  • The partition key is defined on a smallint column and 227 is valid value.
  • There is also no partition with the partition key 227.
  • The "alter table" command is executed via isql.

Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 16.0

Product

SAP Adaptive Server Enterprise 16.0

Keywords

syspartitions, mismatch, name, partitioned, local , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem

About this page

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

Search for additional results

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