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.
SAP Knowledge Base Article - Preview