Symptom
You are running SAP Business Suite on SAP Sybase ASE 15.7 and during import of SAP_BASIS or SAP_ABAP service pack with SPAM the following error is raised during phase 'IMPORT_PROPER':
4 EGT850XBeginning of Step "TDDAT-STEP2" ( "12:15:43" )
4 EGT281 sql:
4 EGT231 "DROP TABLE 'QCMTDDAT'"
4 EDA093 "DDL time(___1):" "........53" milliseconds
4 EGT281 sql:
4 EGT231 "CREATE TABLE 'QCMTDDAT'"
4 EGT231 "('TABNAME' varchar(000090) NULL ,"
4 EGT231 "'MCLASS' varchar(000012) NULL ,"
4 EGT231 "'CCLASS' varchar(000042) NULL ,"
4 EGT231 "'FLAG' varchar(000003) NULL )"
4 EDA093 "DDL time(___1):" ".......158" milliseconds
4 EGT281 sql:
4 EGT231 "DELETE FROM DDSTORAGE"
4 EGT231 "WHERE DBSYSABBR = 'SYB'"
4 EGT231 "AND TABNAME = 'QCMTDDAT'"
4 EGT231 "AND INDEXNAME = ' '"
4 EDA093 "DDL time(___2):" ".........2" milliseconds
1AETR012XProgram terminated (job: "RDDGEN0L", no.: "12134300")
1AEPU320 See job log"RDDGEN0L""12134300""<SID>"
A RABAX with the following database error message is raised:
[ASE Error SQL313] The optimizer could not find a unique index which it could use to perform an isolation level 0 scan on table '<name>'
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 15.7 for SAP Business Suite (BS)
- SAP Enterprise Resource Planning (ERP) 6.0
Product
SAP Adaptive Server Enterprise 15.7 ; SAP ERP 6.0
Keywords
TBATG CONVERSION OF DD-OBJECTS; ASE Error SQL313; DB-Fehler; Datenbankfehler; Konfigurationseinstellungen; "datarows"; "lock scheme" , 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.