Known Issues for Replicating to Sybase IQ

Workaround: Upgrade Sybase IQ user database objects, such as stored procedures, tables, and so on, to Replication Server version 15.7.1.

See Upgrades to RSSD or ERSSD and User Databases in the Replication Server Configuration Guide.

Workaround: Use Sybase IQ 15.4 ESD #1.

When you manually materialize a replicate table using the Sybase IQ INSERT ... LOCATION statement, retrieving the result set directly from the primary database causes the last three digits of the microsecond in TIMESTAMP columns to use the values 000, 333, or 666. For example:

insert test_datetime_iq4 location 'zeus.primaryDB4' 
     { select c1,c2,c3,c4,c5 from test_datetime_iq4 }

where c2 is datetime and c4 is time.

• Manually materialize the Sybase IQ tables by enforcing explicit conversion of the TIMESTAMP datatype to string:

   insert test_datetime_iq4 location 'zeus.primaryDB4' 
        { select c1,convert(varchar,c2,109),
                 c3,convert(varchar,c4,20),c5 
                 from test_datetime_iq4 }

• Or, do not modify TIMESTAMP columns on Sybase IQ tables.

Because Replication Server connects and issues the lock table command, you must make the connection from the Replication Server to Sybase IQ in a multiplex environment to the coordinator node. Otherwise, you see:

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)'.

When RTL replicates data to Sybase IQ 15.x, data inserted into time and timestamp columns may be corrupted. There is no warning nor error message indicating that the data is corrupted.

• If there is no text or image in the table, mark the table to not be compiled. RTL uses the function string to process instead of insert-location. Issue this command:

  alter connection to data_server.database for replicate table named table_name set dsi_compile_enable "off"

  This will effectively slow down the process.

• If there is text or image in the table, apply Sybase IQ 15.1 ESD #3 or use Sybase IQ 12.7 ESD #4 and later.

Workaround: Apply Sybase IQ 15.1 ESD #3 or use Sybase IQ 12.7 ESD #4 and later.

Workaround: In Sybase IQ, apply this command:

set option public.STRING_RTRUNCATION = “OFF”

By default, the STRING_RTRUNCATION option is set to on in Sybase IQ 15.0 and later.