2427634 - ASE Error SQL102:42000 - Incorrect syntax near 'PCTFREE' during import | SAP Knowledge Base Article

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 ONE Support launchpad (Login required).

Search for additional results

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