SAP Knowledge Base Article - Preview

2705689 - ASE Error SQL2760 "Column name does not exist" during heterogeneous system copy - SAP BW on ASE

Symptom

  • During migration from Oracle to ASE Error SQL2760 is reported in the SAPDFACT log:

(IMP) ERROR: Task failed with error: (SYB) DDL statement failed
(IMP) ERROR: (CREATE INDEX "<table_name>~010" ON "<table_name>" ( "SID_0SMD_GRDA", "SID_0SMD_GRTI") WITH consumers = 5)
(IMP) ERROR: DbSlExecute: rc = 99
(IMP) ERROR: (SYB) (SQL error 2760)
(IMP) ERROR: Error message returned by DbSl:
(IMP) ERROR: (SYB) SQL error = 2760
(IMP) ERROR: (SYB) [ASE Error SQL2760][SAP][ASE ODBC Driver][Adaptive Server Enterprise]Column name 'SID_0SMD_GRDA' does not exist in target table.

  • The table has no column like the one mentioned in the error message, neither on the source definition.
  • This is the unique error reported.
  • All the required SAP Notes SYB* are implemented in the source system, following all instructions from SAP Note 2103871 - SYB: Migrating SAP BW to SAP Adaptive Server Enterprise.
  • Checking the RS_BW_PRE_MIGRATION output it appears that the table is flat infocube.

Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7 for Business Suite
  • SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
  • SAP Business Warehouse - All versions

Product

SAP Solution Manager 7.2

Keywords

flat infocube, 2760, conversion, BW , KBA , BW-SYS-DB-SYB , BW on Sybase ASE Database Platform , 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.