SAP Knowledge Base Article - Preview

3080259 - How to prevent indexes to be deleted during system update

Symptom

The following indexes found deleted after system update on Commerce Cloud

  • automatically adds useful indexes
  • customer admins manually creating indexes

There is a SQL Azure feature that automatically adds useful indices, but those indexes are dropped by system update,

it leads to errors shown for automatically created indexes which were in 'validation' phase, workaround is re-created in Commerce Cloud.

Customer added index also found dropped, workaround is manually creating indexes by customer admins.


Read more...

Environment

SAP Commerce Cloud

Product

SAP Commerce Cloud all versions

Keywords

index dropped system update , KBA , CEC-SCC-CLA-ENV-EMG , Environment Management , How To

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.