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 for Me (Login required).

Search for additional results

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