Symptom
- Due to some reason, a reorg rebuild process needs to be terminated manually in the middle of its processing.
- However, when run reorg rebuild again after it's terminated, it keeps reporting "Msg 1505" as below.
Beginning REORG REBUILD of table 'xxx'.
Non-clustered index (index id = 2) is being rebuilt.
Msg 1505, Level 16, State 2:
Server 'xxx', Line 1:
Create unique index aborted on duplicate key. Primary key is '"xxx"'
- Checking the Primary Key reported in the error above, but do not find the duplicated rows.
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 15.7 SP132 and higher
Product
SAP Adaptive Server Enterprise 15.7
Keywords
Reorg rebuild, Msg 1505, primary key, statistics , 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 for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.