SAP Knowledge Base Article - Preview

3032544 - RTL- DSI EXEC WARNING #5091 & SQL Anywhere Error -1003002 when replicate large xact from ASE table with Identity column - SRS

Symptom

  •  Replication from ASE to IQ using RTL.
  • A column is defined as identity in ASE, but integer in IQ and replication definition (repdef).
  • When processing a large transaction with more than 70K data rows, DSI EXEC thread 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.


Read more...

Environment

  • SAP Replication Server (SRS) 16.0 
  • Adaptive Server Enterprise (ASE) 16.0
  • SAP IQ 16.1 SP04.04
  • Real-Time Loading (RTL)

Product

SAP Replication Server 16.0 ; SAP Sybase Replication Server 15.7, heterogeneous edition

Keywords

CR824252, CR#824252, 824252, "identity map to int" , KBA , BC-SYB-REP , Sybase Replication Server (standalone) , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-SYB-IQ , Sybase IQ , Bug Filed

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.