SAP Knowledge Base Article - Preview

2457926 - sp_post_xpload and CREATE UNIQUE INDEX report Error 1505 "Create unique index aborted on duplicate key ..." - SAP ASE

Symptom

  • Cross-Platform Dump and Load (XPDL)
  • sp_post_xpload reports Error 1505:

Msg 1505, Level 16, State 2:
Server 'myASE', Procedure 'sp_post_xpload', Line 257:
Create unique index aborted on duplicate key.  Primary key is '"E55908  ", "Dec  1 2003 12:00:00:000AM"'

  • Manually dropped and recreated the index -- the same error: 

1> DROP INDEX mytable.x01
2> go
1> CREATE UNIQUE NONCLUSTERED INDEX x01 ON dbo.mytable(POOLNO,SOME_DATE)
2> go
Msg 1505, Level 16, State 2:
Server 'myASE', Line 1:
Create unique index aborted on duplicate key.  Primary key is '"E55908  ", "Dec  1 2003 12:00:00:000AM"'


Read more...

Environment

  • Sybase Adaptive Server Enterprise 15.0
  • Sybase Adaptive Server Enterprise 15.5
  • SAP Adaptive Server Enterprise 15.7
  • SAP Adaptive Server Enterprise 16.0

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; Sybase Adaptive Server Enterprise 15.0 ; Sybase Adaptive Server Enterprise 15.5

Keywords

aborted, cross, platform, crossplatform, table, scan , 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.