SAP IQ Invalid Permission in a Multiplex Environment

Occurs when connection to coordinator node is not happening. Because in an IQ Multiplexed system, the coordinator node is the only node that can do the lock table command.

Symptom

These messages are reported in the SAP Replication Server error log:
E. 2010/09/14 08:51:13. ERROR #1028 DSI EXEC(104(1) pocmpx.iqdb) -
dsiqmint.c(4234) Message from server: Message: -1004015, State 0, Severity 14 -- 'SQL
Anywhere Error -1004015: Permission denied: Command not allowed on
Multiplex Writer servers. (saint_iqthresholdddl.cxx 14936)'.

Explanation

Because SAP Replication Server connects and issues the lock table command, the connection from the SAP Replication Server to SAP IQ in a Multiplex environment must be made to the coordinator node.

Solution

Change the interfaces file entry for SAP IQ that the SAP Replication Server uses, to connect to the coordinating node.

See SAP IQ as Replicate Data Server in the Heterogeneous Replication Guide.