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.