Known Issues for Replicating to Sybase IQ

Learn about known issues and apply workarounds when replicating to Sybase IQ from Adaptive Server using Real-Time Loading (RTL) in Replication Server.

Replicating to Sybase IQ Issues from Adaptive Server Using RTL

CR#

Description
643578 Automatic materialization to Sybase IQ fails.

If you use atomic and nonatomic materialization methods, materialization of tables to Sybase IQ using RTL fails for multiple datatypes.

Workaround: Either:
  • Use the no materialization or the bulk materialization methods when replicating to Sybase IQ using RTL
  • Upgrade to Replication Server 15.6 ESD #1
642212 rssetup.sql is missing from the scripts directory within the Sybase IQ installation directory on Sun Solaris AMD x64 platforms.

Workaround: Obtain this script from another platform or contact Technical Support.
641373 Lock table failure when replicating in Sybase IQ multiplex environment.

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)'.
Workaround: Change the sql.ini file entry for Sybase IQ that the Replication Server uses, to connect to the coordinator node.
620097 Data corruption when replicating data to Sybase IQ 15.x in RTL.

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.

Workaround: Select one of:
  • 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.
619358 Text and image column values are truncated when inserted into a Sybase IQ 15.1 database. This problem occurs in Sybase IQ 15.1 GA, ESD #1, and ESD #2.

Workaround: Apply Sybase IQ 15.1 ESD #3 or use Sybase IQ 12.7 ESD #4 and later.
594620 When inserting data from Replication Server to Sybase IQ 15.0 and later using the insert-location, you may encounter the right truncation of string data error.

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.
Parent topic: Known Issues