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