SAP Knowledge Base Article - Preview

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

Symptom

  •  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.


Read more...

Environment

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

Product

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

Keywords

INSERT LOCATION; -1003002; 1003002; IQ interface , KBA , BC-SYB-REP-RTL , Rep Server Real-Time Loading Edition (RTLE) , BC-SYB-IQ , Sybase IQ , 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.