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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.