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 , 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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.