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.
SAP Knowledge Base Article - Preview