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.
- 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
- Real-Time Loading (RTL)
Product
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.