on 05-05-2018 4:33 AM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
78 | |
9 | |
8 | |
6 | |
6 | |
6 | |
6 | |
6 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.