SAP Knowledge Base Article - Preview

2389384 - Message: -1006000, State 0, Severity 23 -- 'SQL Anywhere Error -1006000: IQ Internal error - SRS

Symptom

  • Getting -1006000 error while replicating to IQ server. The SAP Replication Server (SRS) was upgraded to this release:
    Replication Server/15.7.1/ONE-OFF EBF 26441 SP304 rs1571sp304
  • Error message:
    A grouped transaction of 1968 individual transactions has failed in database 'IQ_PRD.iq_prod'. It will be broken into smaller groups and retried.
    ERROR #1028 DSI EXEC(108(1) IQ_PRD.iq_prod) - neric/dsi/dsiqmint.c(4935)
    Message from server: Message: -1006000, State 0, Severity 23 -- 'SQL Anywhere Error -1006000: IQ Internal error.
    Please report this to SAP IQ support. -- (hqmlib/hqm_query.cxx 1045) '.
    A group of class 1 is to be dispatched, with size 4395947, num of tran 416, num of cmd 6074.
    Retry of a grouped transaction of 416 individual transactions has failed in database 'IQ_PRD.iq_prod'. It will be broken into smaller groups and retried.
  • Regrouping slows the RTL replication
  • Turned on traceflags:
    trace 'on', 'rsfeature', 'rsfeature_hq1'
    trace 'on', 'rsfeature', 'rsfeature_hq2'
    trace 'on', 'rsfeature', 'rsfeature_hq3'
  • The tracing log shows:
    (HQ Error) srv_xferdata failed for rows 1 status 0

Read more...

Environment

  • SAP Replication Server 15.7.1 ONE-OFF SP304 and earlier versions
  • SAP Replication Server Real Time Loading Edition 15.7.1 ONE-OFF SP304 and earlier versions

Product

SAP IQ 16.0 ; SAP IQ 16.1 ; SAP Replication Server 15.7

Keywords

CR 803429 , CR 797537 , RTL,  -1006000,  srv_xferdata, IQ, bigint null, SQL Anywhere Error, RepServer, repagent, RSSD, eRSSD , KBA , BC-SYB-REP , Sybase Replication Server (standalone) , BC-SYB-REP-RTL , Rep Server Real-Time Loading Edition (RTLE) , 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.