Solution : https://service.sap.com/sap/support/notes/1541243 (SAP Service marketplace login required)
Summary :
This SAP Note addresses the runtime error DBIF_DSQL2_DEFAULT_CR_ERROR in SAP systems that might occur during transaction commit or rollback processes due to the improper definition of the synchronization table DDLOG. Specifically, the error is encountered when the SEQNUMBER field of the DDLOG table on MSSQL databases is not set as an IDENTITY column, leading to potential duplicate key errors. The resolution involves using SE14 to redrop and recreate DDLOG with the correct IDENTITY property for SEQNUMBER and then refreshing or restarting all application server buffers.
Key words :
113column_name type computed length prec scale nullable, start sql server management studio connect, owner type created_datetimeddlog sid user table 2010-10-06 12, primary key field seqnumber, application server local caches, sql server execute, sidexec sp_help 'sid, application server read, duplicate key errors, synchronistaion table ddlog
Related Notes :
| 1259011 | Hom./Het.System Copy for SAP Systems Based on SAP NW 7.11 |
| 1238351 | Hom./Het.System Copy SAP NW 7.0 incl. Enhancement Package 1 |
| 1120872 | Hom./Het.System Copy SAP NetWeaver 7.0 SR3 |
| 1042437 | Hom./Het.System Copy for SAP NetWeaver Based on Kernel 7.10 |