SAP Knowledge Base Article - Preview

2079491 - SQL Server error - Import of SAPSPROT package


During a fresh installation/target system installation (system copy), the Software Provisioning Manager tool fails during the import of the package SAPSPROT with the following error:

(DB) ERROR: DDL statement failed
(CREATE TABLE [DDLOG] ( [SEQNUMBER] int NOT NULL default 0 , [TIMESTAMP] nvarchar(26) NOT NULL default N' ' , [SYSTEMID] nvarchar(22) NOT NULL
default N' ' , [NBLENGTH] smallint NOT NULL default 0 , [NOTEBOOK] varbinary(MAX) NULL  )  WITH ( DATA_COMPRESSION = PAGE ) )

DbSlExecute: rc = 99
(SQL error 1754)
error message returned by DbSl:
[Microsoft][SQL Server Native Client 11.0][SQL Server] Defaults cannot be created on columns with an IDENTITY attribute. Table 'DDLOG', column 'SEQNUMBER'.



  • SAP Systems based on SAP NetWeaver;
  • Software Provisioning Manager tool (SWPM);
  • Operating System: Windows;
  • Database: MS SQL Server.


SAP NetWeaver all versions


Installation, System Copy, Import, SAPSPROT, IDENTITY, DDLOG, SEQNUMBER, MSSQL, Column, Exception, SWPM, Software Provisioning Manager, Kernel, Outdated, SWPM, SPM, Migration, Migrating, OS/DB, OS, DB, Copying, Installer, Install, Migration Monitor, Importing, Export, Exporting, MSSQL, SAP NetWeaver, NW , KBA , BC-INS-MIG , OS/DB Migrations with SWPM and DB refresh , BC-INS , Installation Tools (SAP Note 1669327) , BC-DB-MSS , SQL Server in SAP NetWeaver Products , BC-INS-NT , SAP Netweaver based Solutions on Windows , 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.