SAP Knowledge Base Article - Preview

3202594 - Heterogenous copy - DB2 to SYBASE - ASE Error SQL99987 - SAP ASE

Symptom

  • Heterogenous system copy FROM 'AIX/DB2' to 'Linux/SAP ASE'
  • During the import in Sybase, a sql error appears on 3 tables: Zxxxxxx 

    A2 ETSK 000 Starting import for object "Zxxxxxx" of type "table" #20220512115709
    A1 EDMP 003 Export data is unsorted.
    A1EEIMP 008 Task failed with error: (DBS) 'DBExeFastload' failed
    A1EEIMP 008 (IMP) DbSlExeModify failed in insert for table 'Zxxxxxx' with #9
    A1EEIMP 008 (IMP) SQL error = 99987
    A1EEIMP 008 (IMP) [ASE Error SQL99987]ERROR: length value (20004) greater than specified data (1600).
    A3 ETSK 017 Throughput: 1.56 MB in 1 chunks, 17666.67 rows/sec, 173.00 MB/sec
    A2EETSK 007 Finished import for object "Zxxxxxx" of type "table" with error in 0.01 sec #20220512115709


Read more...

Environment

SAP Adaptive Server Enterprise Edition (ASE) 16.0

Product

SAP Adaptive Server Enterprise 16.0

Keywords

SQL99987, 99987, length value greater than specified data, Heterogenous system copy, Heterogenous, system copy, R3load, DBExeFastload, DBSL , KBA , BC-DB-SYB , Business Suite 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.