SAP Knowledge Base Article - Preview

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

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 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

SQL1505, create index, duplicate, migration, heterogenous , 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 for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.