Sybase 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 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 Replication Server connects and issues the lock table command, the connection from the Replication Server to Sybase IQ in a Multiplex environment must be made to the coordinator node.

Solution

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

See the Replication Server Heterogeneous Guide > Replicating into Sybase IQ.