SAP Knowledge Base Article - Preview

2111554 - BW migration to ASE fails with Error SQL1505 - Create unique index aborted on duplicate key.

Symptom

  • You are performing a heterogenous migration of Business Warehouse or Solution Manager to SAP ASE
  • R3Load fails whith this error on log: 
(DB) ERROR: DDL statement failed
 (CREATE UNIQUE  INDEX "</BIx/indexname>" on "</BIx/F_E_tablename>" ...... with sorted _data )
DbSlExecute: rc = 99
  (SQL error 1505)
  error message returned by DbSl:
[ASE Error SQL1505][SAP][ASE ODBC Driver][Adaptive Server Enterprise]Create unique index aborted on duplicate key ....

 


Read more...

Environment

  • SAP Adaptive Server Enterprise 15.7 for Business Suite
  • SAP Adaptive Server Enterprise 16.0 for Business Suite
  • SAP Business Warehouse - All versions
  • SAP Solution Manager - All versions

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; SAP Business Warehouse all versions ; SAP Solution Manager all versions

Keywords

KBA , BW-SYS-DB-SYB , BW on Adaptive Server Enterprise , 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.