Replication Server Not Found

Sybase IQ failed to connect to the replicate Replication Server.

Symptom

The Data Server Interface (DSI) shuts down and SQL Anywhere^® Error -1003002 is recorded in the 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 Sybase IQ using real-time loading (RTL) replication has not been properly configured. Sybase IQ must be able to connect to Replication Server and retrieve data each time Replication Server sends an INSERT ... LOCATION statement to Sybase IQ.

Solution

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