SAP Knowledge Base Article - Preview

2427634 - ASE Error SQL102:42000 - Incorrect syntax near 'PCTFREE' during import

Symptom

During the import phase of a system copy/migration of an AS ABAP system, R3load fails with an error.
You start to analyze the problem according to SAP Note:

2146357 - How to start analyzing ‘Migration Monitor’ issues during execution of Software Provisioning Manager tool (SWPM)

and find the error in the package log file SAPNTAB.LOG:

"(DB) ERROR: DDL statement failed
 (   CREATE TABLE "SVERS"       ("VERSION" VARCHAR2 (000216)         DEFAULT ' ' NOT NULL)       PCTFREE 10       PCTUSED 00       INITRANS 001       TABLESPACE &SDIC&    NOCOMPRESS    STORAGE (INITIAL     0000000520 K                NEXT        0000000040 K                MINEXTENTS  0000000001                MAXEXTENTS  UNLIMITED                PCTINCREASE 0000                FREELISTS   001                FREELIST GROUPS 01) )
 DbSlExecute: rc = 99
  (SQL error 102)
  error message returned by DbSl:
[ASE Error SQL102:42000][SAP][ASE ODBC Driver][Adaptive Server Enterprise]Incorrect syntax near 'PCTFREE'.

(SYB_IMP) ERROR: DbSlPrepare/BegModify
  failed rc = 103, table "SVERS"
  (SQL error 208)
  error message returned by DbSl:
[ASE Error SQL208:42000][SAP][ASE ODBC Driver][Adaptive Server Enterprise]SVERS not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output).

(IMP) ERROR: InitFastload: rc = 2
(DB) ERROR: failed to load table "SVERS", index "SVERS~0" is not created."

 

 


Read more...

Environment

  • Software Provisioning Manager (SWPM)
  • SAP Adaptive Server Enterprise
  • SAP NetWeaver, AS ABAP based system

Product

SAP Adaptive Server Enterprise 12.5 ; SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

migration, Sybase, SQL error 208,  rc = 103, SVERS, DbSlExecute: rc = 99, SQL error 102, Error SQL208:42000, system copy, import , KBA , BC-INS-MIG , OS/DB Migrations with SWPM and DB refresh , 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.