Skip to Content

Column name missing error during hetrogenous migration to Sybase

Hi Experts,

I am moving my database from Oracle to Sybase using Heterogeneous system copy method. I had generated DDL statements and taken source system export which was running on Oracle. Now during system import of ABAP in Sybase I am facing issue as 1 job is failing in Import_abap phase.

From Import_monitor.log we have

INFO: 2018-05-04 02:23:20 run_report
Monitor jobs: running 2, waiting 60, completed 26, failed 1, total 89 error processing of package SAPDFACT_1

ERROR: 2018-05-04 02:23:20 run
Loading of 'SAPDFACT_1' import package is interrupted with R3load error.
Process '"C:\Program Files\sapinst_instdir\SOLMAN72SR1\SOLMAN72SR1\SYB\COPY\SYSTEM\STD\AS-ABAP\R3load.exe" -i SAPDFACT_1.cmd -dbcodepage 4103 -k 1gUfd5M50DL01eqtdA5w0am0 -l SAPDFACT_1.log -c 100000 -loadprocedure fast' exited with return code 2.
For mode details see 'SAPDFACT_1.log' file.

From SAPDFACT_1.log we have

(SQL) INFO: index /BI0/F0CCMVRKF~010: SQL overridden by 'H:\DSM_Migration_dumps\Exports\ABAP_exports\ABAP\DB\SYB\DFACT.SQL', line 146546-146557
(IMP) ERROR: Task failed with error: (SYB) DDL statement failed
(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.

Kindly help me to solve this issue as I am stuck in this phase.

Thanks in advance.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • May 10, 2018 at 08:39 AM

    Hello Kaushal,

    Can you check the following KBA if it helps resolve the issue?

    2041693 - SYB: [ASE Error SQL2760]Column name '...' does not exist in target table



    Add comment
    10|10000 characters needed characters exceeded