SAP Knowledge Base Article - Preview

2346460 - ERROR 1027 and 5215 DSI EXEC: blk_rowxfer() and blk_rowxfer_mult() return FAIL - SAP SRS

Symptom

  • It is a warm-standby pair
  • The SAP Replication Server (SRS) errorlog shows the following error:

    ERROR #1027 DSI EXEC(104(1) StandbyDS.StandbyDB) - eneric/dsi/dsiutil.c(453)
     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 = 18 row = 1.'.
    ERROR #1027 DSI EXEC(104(1) StandbyDS.StandbyDB) - eneric/dsi/dsiutil.c(453)
    Open Client Client-Library error: Error: -99999, Severity 5 -- 'blk_rowxfer_mult() failed for table [Bulk_Copy_TB]'.
    ERROR #5215 DSI EXEC(104(1) StandbyDS.StandbyDB) - eneric/dsi/dsiutil.c(502)
    The interface function 'RCIMoreResults' returns FAIL for database 'OneASE157.SDB'. The errors are retryable. The DSI thread will restart automatically. See messages from the interface function for more information.
     
  • There is a timestamp column in the table:

    create table Bulk_Copy_TB
    (
    ........
    UpdateTS timestamp NOT NULL
    .......
    )
     
  • 'dsi_bulk_copy' and 'dynamic_sql' parameters of the standby connection are turned on


Read more...

Environment

SAP Replication Server all versions.

Product

SAP Replication Server all versions

Keywords

 1027, 5215, blk_rowxfer_mult, dsi_bulk_copy, dynamic_sql, warm standby,send_timestamp_to_standby , 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.