Known issues concerning replication to Sybase IQ from Adaptive Server using real-time loading (RTL) in Replication Server.
CR# |
Description |
---|---|
722797 | The default Sybase IQ NUMERIC
and DECIMAL datatypes precision and scale do
not match and are incompatible with the isql
and the Adaptive Server defaults. When using the default precision and scale in the replicate Sybase IQ table definition for NUMERIC andDECIMAL datatypes, the Sybase Replication Server DSI thread shows: ct_results(): protocol specific layer: external error: There is a tds protocol error.
An invalid numeric precision was received.
Workaround: Define the target Sybase IQ
NUMERIC and DECIMAL datatypes
with precision less than or equal to 77. See Numeric Data
Types in the SAP Sybase IQ Reference: Building
Blocks, Tables, and Procedures. |
695949 | Connection to Sybase IQ 15.4 fails when create connection using profile with UTF-8 character set. Workaround: Use Sybase IQ 15.4 ESD #1. |
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)'. |
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:
|