3028982 - Replication to IQ via RTL rowcount mismatch and duplicate - SRS

• 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.

• SAP Replication Server (SRS) 16.0
• SAP Adaptive Enterprise Server (ASE) 16.0
• SAP IQ 16.0

row count, repdef, repserver, RTL, IDENTITY, primary key , KBA , BC-SYB-REP , Sybase Replication Server (standalone) , Problem