SAP Knowledge Base Article - Preview

1902336 - Error 313 during IMPORT_PROPER phase when importing service pack with transaction SPAM - BS on SAP ASE

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.