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

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 , SAP Business Suite on Sybase ASE Database Platform , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.