SAP Knowledge Base Article - Preview

2472827 - Error SQL5702 & SQL3073 reported during migration - SAP BW on ASE

Symptom

  • You are in process of migrating your BW system from a non-SAP database to SAP ASE
  • The import process is terminating with following error messages:

========================ERROR-1==========================
DbSlExecute: rc = 99  ( SQL error 5702 )  error message returned by DbSl:[ ASE Error SQL5702 ][SAP][ASE ODBC Driver][Adaptive Server Enterprise] ASE is terminating this process.
========================ERROR-1==========================

========================ERROR-2==========================
DbSlExecute: rc = 99  ( SQL error 30273 )  error message returned by DbSl:[ ASE Error SQL30273:08003 ][SAP][ASE ODBC Driver] Attempting to use a dead connection in Commit.
========================ERROR-2==========================

  • From import logs we can see errors reported when trying to create index, ie:

    (DB) ERROR: DDL statement failed
    ( CREATE UNIQUE INDEX "/BIC/<index_name>" ON "/BIC/<table_name>" ( "<column>") )
    DbSlExecute: rc = 99
    (SQL error 1972)
    error message returned by DbSl:
    [ASE Error SQL5702][SAP][ASE ODBC Driver][Adaptive Server Enterprise]ASE is terminating this process.
    (DB) ERROR: DDL statement failed
    (IF EXISTS(SELECT 1 FROM sysindexes i, sysobjects o WHERE ..........)
    DbSlExecute: rc = 99
    (SQL error 30273)
    error message returned by DbSl:
    [ASE Error SQL30273:08003][SAP][ASE ODBC Driver]Attempting to use a dead connection in Commit.
    (DB) ERROR: DDL statement failed
  • The "B. Preparation in the source system" from SAP Note 2103871 had been completed, but while executing report SMIGR_CREATE_DDL you get warning / error message "F fact tables with too many DB partitions

Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7 and 16.0 for Business Suite
  • SAP Business Warehouse - All versions 

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; SAP Business Warehouse all versions

Keywords

KBA , BW-SYS-DB-SYB , BW on Sybase ASE Database Platform , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.