SAP Knowledge Base Article - Preview

2515186 - Text column replication fails in Warmstandby environment when inserting data with bcp - SAP SRS

Symptom

Text column replication fails with following conditions:

  • Warmstandby environment
  • Text column is NOT NULL
  • dsi_bulk_copy is enabled
  • use bcp utility

ERROR #1027 DSI EXEC(104(1) SASE.test) - /dsiutil.c(355)
        Open Client Client-Library error: Error: 16908568, Severity 1 -- 'blk_rowxfer(): blk layer: internal BLK-Library error: No value or default value available and NULL not allowed.  col = 2 row = 1.'.
ERROR #1027 DSI EXEC(104(1) SASE.test) - /dsiutil.c(355)
        Open Client Client-Library error: Error: -99999, Severity 5 -- 'Unable to transfer bulk rows.  blk_rowxfer failed.'.
ERROR #5215 DSI EXEC(104(1) SASE.test) - /dsiutil.c(358)
        The interface function 'SQLExecute' returns FAIL for database 'SASE.test'. The errors are retryable. The DSI thread will restart automatically. See messages from the interface function for more information.


Read more...

Environment

  • Sybase Replication Server 15.6
  • Adaptive Server Enterprise (ASE) 12.5.4

Product

Sybase Adaptive Server Enterprise 12.5 ; Sybase Replication Server 15.6

Keywords

bcp, blk_rowxfer, rs_update, rs_writetext , KBA , BC-SYB-REP , Sybase Replication Server (standalone) , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , 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.