SAP Replication Server Not Found

SAP IQ failed to connect to the replicate SAP Replication Server.

Symptom

The Data Server Interface (DSI) shuts down and SAP SQL Anywhere Error -1003002 is recorded in the SAP Replication Server error log:

E. 2010/09/20 16:24:33. ERROR #1028 DSI EXEC(103(1) mrpserver.mrp) - dsiqmint.c(4218)
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. 
OS Error: 0, OS Message:

Explanation

Replication to SAP IQ using real-time loading (RTL) replication has not been properly configured. SAP IQ must be able to connect to SAP Replication Server and retrieve data each time SAP Replication Server sends an INSERT ... LOCATION statement to SAP IQ.

Solution

Create an entry for the replicate SAP Replication Server in the interfaces file of the replicate SAP IQ server. This allows SAP IQ to connect to SAP Replication Server using the user name and password specified in the database connection. The maintenance user must be a valid user in SAP Replication Server with system administrator privileges and whose password matches the password that SAP Replication Server uses to log in to SAP IQ.