SAP Knowledge Base Article - Preview

2824509 - RTL - SQL Anywhere Error -1003002 Requested server name not found - SRS


  •  Replication from ASE to IQ with Real-Time Loading (RTL) enabled. 
  •  Bulk Insert failed with the following msg

  ERROR #1028 DSI EXEC(233(1) iqserver.iqdb) - neric/dsi/dsiqmint.c(5039)
  Message from server: Message: -1003002, State 0, Severity 14 -- 'SQL Anywhere Error -1003002: CtLibrary Error: 3, Severity: 0, Origin: 8, Layer: 6
  Error Message: ct_connect(): directory service layer: internal directory control layer error: Requested server name not found.

  •  Enable HQ1 trace from SRS(i.e  trace 'on', 'rsfeature', 'rsfeature_hq1') & see the following output:

(HQ Error) Flush FAILED for stmts :
(HQ Error) (stmt 1) 'insert into #rs_dt_<iqtable>_101_1 location '<RepServer_name>.iqdb_101_780' { select * from rs_dt_<iqtable>_101_1 }'
(HQ Info) HQ Executor FAILED to apply change-db content
HQ execution failed, user 'iq_maint' ...
HQCPL: cleanup table (iqtable) 56 commands
(HQ Info) Free CDB (56 CMDs - CDB SIZE 2 Mb)
Retry of a grouped transaction of 28 individual transactions has failed in database 'iqserver.iqdb'. It will be broken into smaller groups and retried.

  • Slow performance with replication going to IQ



  • SAP Replication Server (SRS) 16.0 
  • SAP Replication Server Real Time Loading (RTL) 16.0
  • SAP IQ 16.x


SAP IQ 16.0 ; SAP Replication Server 16.0 ; SAP Replication Server, real-time loading edition 16.0


INSERT LOCATION; -1003002; 1003002; IQ interface , KBA , BC-SYB-REP-RTL , Rep Server Real-Time Loading Edition (RTLE) , BC-SYB-REP , Sybase Replication Server (standalone) , BC-SYB-IQ , Sybase IQ , How To

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.