SAP Knowledge Base Article - Preview

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

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.