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, like this sample:

(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 ABAP report RS_BW_PRE_MIGRATION output from source system 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 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.