SAP Knowledge Base Article - Preview

3032544 - RTL- DSI EXEC WARNING #5091 & error(#-1003002) when replicate large xact from ASE table contains Identity column - SRS

Symptom

  • Replication from ASE to IQ using RTL.
  • A column is defined as identity in ASE, but integer in IQ  & replication definition (repdef).
  • When processing a large transaction contains more than 70K data rows, DSI reports the following HQ error: 
    • (HQ Error) Received replicate server error: 'SQL Anywhere Error -1002003:
      Tried to insert a duplicate value into a unique index <owner>.<IQ_table> ASIQ_IDX_T1723_I63_HG on row 67133612.-- (slib/s_ohcins.cxx 964)
    • WARNING #5091 DSI EXEC(103(1) IQ160.DB) - neric/dsi/dsiqmint.c(5345)
      A transaction for database 'IQ160.DB' failed. It will be retried 3 times. The data server error received (#-1002003) is mapped to RETRY_LOG or RETRY_STOP.
  • SRS configuration parameter memory_control set to ON.


Read more...

Environment

  • SAP Replication Server (SRS) 16.0 
  • Adaptive Server Enterprise (ASE) 16.0
  • SAP IQ 16.1 SP04.04

Product

SAP Sybase Replication Server 15.7, heterogeneous edition

Keywords

RTL, 5091, WARNING #5091, SQL Anywhere Error -1002003 , KBA , BC-SYB-REP , Sybase Replication Server (standalone) , BC-SYB-IQ , Sybase IQ , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed

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.