Symptom
- Replication from ASE to IQ via RTL
- Primary table has IDENTITY column as primary key in ASE
- Replicate table has the corresponding column declared as int and as primary key in IQ
- The corresponding column is declared as int in table replication definition
- DSI raises following errors:
WARNING #5185 DSI EXEC(120(1) iq_server.IQ_DB) - generic/dsi/hqexec.c(6086)
Row count mismatch for the command executed on 'iq_server.IQ_DB'.
The command impacted 578 rows but it should impact 1578 rows
....................................................
THREAD FATAL ERROR #5189 DSI EXEC(120(1) iq_server_test.IQ_DB) - eneric/dsi/dsiutil.c(1006)
The DSI thread for the 'iq_server.IQ_DB' database is being shut down.
....................................................
ERROR #1028 DSI EXEC(120(1) iq_server.IQ_DB) - neric/dsi/dsiqmint.c(5201)
Message from server: Message: -1002003, State 0, Severity 14 -- 'SQL Anywhere Error -1002003: Tried to insert a duplicate value into a unique index schema.TBL.ASIQ_IDX_T18743_I9_HG on row 376347.
-- (slib/s_ohcins.cxx 964) '.
A grouped transaction of 5 individual transactions has failed in database 'iq_server.IQ_DB'. It will be broken into smaller groups and retried.
..................................................
WARNING #5091 DSI EXEC(120(1) iq_server.IQ_DB) - neric/dsi/dsiqmint.c(5498)
A transaction for database 'iq_server.IQ_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
- SAP Adaptive Enterprise Server (ASE) 16.0
- SAP IQ 16.0
Product
SAP Sybase Replication Server 15.7, heterogeneous edition
Keywords
row count, repdef, repserver, RTL, IDENTITY, primary key , KBA , BC-SYB-REP , Sybase Replication Server (standalone) , Problem
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.