SAP Knowledge Base Article - Preview

2389384 - Message: -1006000, State 0, Severity 23: IQ Internal error - SRS

Symptom

  •  Getting SQL Anywhere error -1006000 while replicating to IQ server:

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.

  • Replication Server was upgraded to 15.7.1 ONE-OFF EBF 26441 SP304.
  • Regrouping slows the RTL replication.
  • Turning on traceflags:

trace 'on', 'rsfeature', 'rsfeature_hq1'
trace 'on', 'rsfeature', 'rsfeature_hq2'
trace 'on', 'rsfeature', 'rsfeature_hq3'

  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 (RTL) 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

CR803429, CR#803429, 803429, CR797537, CR#797537, 797537, bigint, RepServer , KBA , BC-SYB-REP , Sybase Replication Server (standalone) , BC-SYB-REP-RTL , Rep Server Real-Time Loading Edition (RTLE) , Bug Filed

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.