SAP Knowledge Base Article - Preview

2949988 - Msg 233 - The column <col1> in table yyyy does not allow null values - SRS

Symptom

  • Replication is from Warmstandby to the 3rd MSA target DB.
  • Replication from the Active to Standby db is fine, but failed with the MSA DSI connection:
    •  ERROR #1028 DSI EXEC(204(1) RDS.RDB) - neric/dsi/dsiqmint.c(5172)
    •  Message: 233, State 2, Severity 16 -- 'The column col1 in table yyyy does not allow null values.
    •  Set identity_insert yyy on insert into yyyy (col1) values (21102800)set identity_insert yyy off
  •  Table yyyy contains many other columns with "not allow NULLs" on both warmstandby & MSA db.


Read more...

Environment

  •  SAP Replication Server (SRS) all versions
  •  SAP Adaptive Server (ASE) 15.7 and up

Product

SAP Replication Server 15.7

Keywords

error 233, Warm standby, MSA, table repdef , KBA , BC-SYB-REP , Sybase Replication Server (standalone) , 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.