SAP Knowledge Base Article - Preview

2214323 - TEXT column replication fails with ASE Error 233 'The column... in table ... does not allow null values.'. - RepServer

Symptom

  • Getting the following error when replicating a table with a text column:

    ERROR #1028 DSI EXEC(9470(1) MYREPDS.repdb) - dsiqmint.c(3221)
    Message from server: Message: 233, State 2, Severity 16 -- 'The column mycolumn in table mytable does not allow null values.'.
     
  • This text column is defined as NOT NULL in the source and target tables.
  • The error started post synchronizing data and marking the table for replication using the sp_setreplicate system stored procedure.


Read more...

Environment

  • SAP Replication Server 15.0 or any 15.x version
  • SAP Adaptive Server Enterprise 15.7 or any 15.x version

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Replication Server 15.7 ; Sybase Replication Server 15.5 ; Sybase Replication Server 15.6

Keywords

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.