Known Issues for Replicating to SAP IQ

Known issues concerning replication to SAP IQ from SAP ASE using real-time loading (RTL) in SAP Replication Server.

Replicating to SAP IQ Issues
CR#	Description
722797	The default SAP IQ `NUMERIC` and `DECIMAL` datatypes precision and scale do not match and are incompatible with the isql and the SAP ASE defaults. When using the default precision and scale in the replicate SAP IQ table definition for `NUMERIC` and`DECIMAL` datatypes, the SAP 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 SAP IQ `NUMERIC` and `DECIMAL` datatypes with precision less than or equal to 77. See Numeric Data Types in the SAP IQ Reference: Building Blocks, Tables, and Procedures.
695949	Connection to SAP IQ 15.4 fails when create connection using profile with UTF-8 character set. Workaround: Use SAP IQ 15.4 ESD #1.
620097	Data corruption when replicating data to SAP IQ 15.`x` in RTL. When RTL replicates data to SAP 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 SAP IQ 15.`x` and later.