SAP Knowledge Base Article - Preview

2444329 - ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found

Symptom

After applying an Enhancement Package (EhP), the following error messages are seen at DB02 logs:

  • ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found
  • The SQL statement was not executed
  • Index   could not be created completely in the database
  • Index RSECSESSION_CL-0 could not be created

A SELECT in the table RSECSESSION_CL shows that there are duplicate entries with the same SESSIONID.


Read more...

Environment

SAP NetWeaver

Product

SAP NetWeaver all versions

Keywords

KBA , BW-BEX-OT-OLAP-AUT , Authorizations , BW-BEX-OT , OLAP Technology , 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.