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

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