sap import abap phase ended with Package loading error

[Former Member]

Hi Experts,

I am at import ABAP phase, but i have received the package loading error , past here the error log.

Latest kernel 742:300 Patch level already updated in the system.

SAP NW 7.40, MSSQL DATABASE 2014, WINDOWS 2012 R2 O/S

Error log:

Import Monitor jobs: running 1, waiting 28, completed 0, failed 0, total 29.

Loading of 'SAPNTAB' import package: ERROR

Import Monitor jobs: running 0, waiting 28, completed 0, failed 1, total 29.

Import Monitor jobs: running 1, waiting 27, completed 0, failed 1, total 29.

Loading of 'SAPSSEXC' import package: ERROR

Import Monitor jobs: running 0, waiting 27, completed 0, failed 2, total 29.

Import Monitor jobs: running 1, waiting 26, completed 0, failed 2, total 29.

Loading of 'SAPSPROT' import package: ERROR

Package log:

E:\usr\sap\FDV\SYS\exe\uc\NTAMD64\R3load.exe: job completed

E:\usr\sap\FDV\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20160326014434

E:\usr\sap\FDV\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20160326014434

(BLD) INFO: sccsid "@(#) $Id: //bas/742_STACK/src/R3ld/R3load/R3ldmain.c#2 $ SAP"

(BLD) INFO: kernel release 742 [NON-UNICODE]

(BLD) INFO: data format 1.8

(BLD) INFO: patch number 328

(BLD) INFO: compiled on "Mar 23 2016 17:45:56"

(PRC) INFO: working directory "C:\Program Files\sapinst_instdir\NW740SR2\MSS\INSTALL\STD\ABAP"

(PRC) INFO: called "E:\usr\sap\FDV\SYS\exe\uc\NTAMD64\R3load.exe -i SAPSPROT.cmd -dbcodepage 4103 -l SAPSPROT.log -loadprocedure fast"

(PRC) INFO: process id 2448

(DB) INFO: connected to DB

(RDI) WARNING: E:\FIORI\51048524_1_exp1\DATA_UNITS\EXP3\DATA\SAPSPROT.STR: cannot find version token "ver:" at line 1

(RDI) WARNING: E:\FIORI\51048524_1_exp1\DATA_UNITS\EXP3\DATA\SAPSPROT.STR: unknown file format, assuming version 2

(IMP) INFO: starting create for object "/SDF/DB6ALRTCFG" of type "table" #20160326014434

(DB) ERROR: DDL statement failed

(CREATE TABLE [/SDF/DB6ALRTCFG] ( [COLLECTOR] varchar(40) NOT NULL default ' ' , [OBJECT] varchar(40) NOT NULL default ' ' , [ATTRIBUTE] varchar(40) NOT NULL default ' ' , [ALRTVALUE] int NOT NULL default 0 , [ALRTMSGNO] varchar(3) NOT NULL default '000' , [REACTMSGNO] varchar(3) NOT NULL default '000' , [OPERATOR] varchar(2) NOT NULL default ' ' , [PARAMLIST] varchar(100) NOT NULL default ' ' , [PARAMUNIT] varchar(4) NOT NULL default ' ' , [ATTRTYPE] varchar(3) NOT NULL default ' ' , [COMPONENT] varchar(5) NOT NULL default ' ' , [PARTITN] int NOT NULL default 0 , [PATH] varchar(100) NOT NULL default ' ' , [ACTIVE] varchar(1) NOT NULL default ' ' , [CUSTOMIZE] varchar(1) NOT NULL default ' ' , [REACT] varchar(1) NOT NULL default ' ' , [MODDATE] varchar(14) NOT NULL default ' ' , [MODUSER] varchar(12) NOT NULL default ' ' , [MODCOMMENT] varchar(255) NOT NULL default ' '  )  WITH ( DATA_COMPRESSION = PAGE ) )

DbSlExecute: rc = 99

  (SQL error 7738)

  error message returned by DbSl:

Cannot enable compression for object '/SDF/DB6ALRTCFG'. Only SQL Server Enterprise Edition supports compression.

(IMP) INFO: starting create for object "/SDF/DB6ALRTCFG~0" of type "primary index" #20160326014434

(DB) ERROR: DDL statement failed

(ALTER TABLE [/SDF/DB6ALRTCFG] ADD CONSTRAINT [/SDF/DB6ALRTCFG~0] PRIMARY KEY CLUSTERED ( [COLLECTOR], [OBJECT], [ATTRIBUTE], [ALRTVALUE] ) )

DbSlExecute: rc = 99

  (SQL error 4902)

  error message returned by DbSl:

Cannot find the object "/SDF/DB6ALRTCFG" because it does not exist or you do not have permissions.

(IMP) INFO: starting import for object "/SDF/DB6ALRTCFG" of type "table" #20160326014434

(IMP) INFO: processed 0 rows for table /SDF/DB6ALRTCFG #20160326014434

(IMP) INFO: finished import for object "/SDF/DB6ALRTCFG" of type "table" in 0 sec #20160326014434

(IMP) INFO: starting create for object "/SDF/DB6PMCD" of type "table" #20160326014434

(DB) ERROR: DDL statement failed

Regards

Karthik.M

[manish_singh13]

Hi Karthik,

Have you done SQL Server Enterprise Edition Installation? As below error shows that it's related to compression mode which you might have selected during Installation steps and it is supported only by Enterprise Edition.

Thanks,

MPS

[v_veeramalla]

Can you check the below notes

1581700 - PAGE compression support for DDIC & Hom./Het. System Copy

And  note 1488135 - Database compression for SQL Server

Verify both the notes

[AtulKumarJain]

Hi,

Are you runing this on a Unicode or non -Unicode system?

As your log shows

"kernel release 742 [NON-UNICODE"

Please check are you using the correct kernel ?

BR

Atul

[Former Member]

Hi,

I am running SAP KERNEL 7.42 Non-unicode system.

Regards

Karthik

[AtulKumarJain]

Hi Karthik,

As shown in logs

"Cannot enable compression for object '/SDF/DB6ALRTCFG'. Only SQL Server Enterprise Edition supports compression."

please verify

1488135 - Database compression for SQL Server

Also as per sap note

62988 - Service packs for MS SQL Server

Supported editions

All supported SQL Server versions are tested by SAP in the Enterprise Edition only. Therefore, only the Enterprise Edition is supported. The SAP support may not be able to solve problems that occur with other editions.

BR

Atul