Skip to Content
0

Column name missing error during hetrogenous migration to Sybase

May 05 at 03:33 AM

74

avatar image

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 com.sap.inst.migmon.LoadTask 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 com.sap.inst.migmon.LoadTask 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: (CREATE INDEX "/BI0/F0CCMVRKF~010" ON "/BI0/F0CCMVRKF" ( "SID_0SMD_GRDA", "SID_0SMD_GRTI"))
(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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Mehrab Bucktowar
May 10 at 08:39 AM
0

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

https://launchpad.support.sap.com/#/notes/2041693

Regards

Mehrab

Share
10 |10000 characters needed characters left characters exceeded