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 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.