SAP Knowledge Base Article - Preview

2079491 - SQL Server error - Import of SAPSPROT package

Symptom

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:

SAPSPROT.log
(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'.


Read more...

Environment

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

Product

SAP NetWeaver all versions

Keywords

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-INS-NT , SAP Netweaver based Solutions on Windows , BC-DB-MSS-INS , SQL Server Installation for SAP NetWeaver Products , 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.