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
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.