Known Issues for Replication Server

In a warm standby environment, if you set text and image columns of a table to do_not_replicate on the active database, and you create a table replication definition for this table without send standby replication definition columns, the replication definition does not include the text and image columns. As a result, the standby database gets incorrect value for the text and image columns.

1. Create the table replication definition with send standby replication definition columns clause.
2. Drop the table replication definition if it is not necessary.

Workaround: Add table owner name in the alter connection command. For example:

alter connection to zeus_ds.omega {
[for replicate table named dbo.alpha] ...}

• All Replication Servers involved in the previous topology are quiesced. Verify with admin quiesce_check.
• RepAgent starts reading from the end of the primary database log.

E. 2011/10/23 23:23:01. ERROR #5216 DSI EXEC(109(1) ost_rqalnxsuse2_15.rdb1) - /dsiutil.c(432)
        The interface function 'SQLBindParameter' returns FAIL for database 'ost_rqalnxsuse2_15.rdb1'. See messages from the interface function for more information.
E. 2011/10/23 23:23:01. ERROR #1027 DSI EXEC(109(1) ost_rqalnxsuse2_15.rdb1) - /dsiutil.c(432)
        Open Client Client-Library error: Error: 16843024, Severity 1 -- 'ct_param(): user api layer: external error: This routine cannot be called while results are pending for a command that has been sent to the server.'.
I. 2011/10/23 23:23:01. The DSI thread for database 'ost_rqalnxsuse2_15.rdb1' is shutdown

Workaround: Execute resume connection.

Replication Server fails when a replication definition contains more columns than the source table and when the replicate minimal columns is set to on. This occurs when an update or a delete is compiled first into the in-memory database, prior to an insert statement.

• replicate minimal columns from the replication definition, or,
• Columns that do not exist in the source table from the replication definition.

Workaround: Set HVAR to off.

If you create multiple replication definitions for a specified primary table and you subsequently alter a column without an LOB datatype to be an LOB column in one of the replication definitions, the LOB-related function strings are not created automatically for one of the replication definitions at the replicate Replication Server. The replicate Replication Server log shows:

Cannot find a matching function string for function 'alltypes.rs_writetext' and function string class 
'rs_sqlserver_function_class'.

1. Clear the failed Data Server Interface (DSI) connection queue by executing resume/skip tran until the DSI connection resumes.
2. Drop the subscription to the problem replication definition at the replicate Replication Server, then drop the replication definition at the primary Replication Server, then re-create both.

Message from server: Message: 2601, State 6, Severity 14 -- 'Attempt to insert duplicate key row in object 'rs_translation' with unique index 'rs_key_translation'

The rs_translation system table has unique index on (classid, source_dtid). The two translation (ASE binary to rs_oracle_binary and ASE timestamp to rs_oracle_binary) generates the duplicate key insert error.

Workaround: For Replication Server versions 15.5 and later, you have to manually remove the translations when you encounter this error. Open the SQL scripts and search for timestamp to find the related SQL statements.

delete from rs_profdetail where profid = 0x000000000e000000 and pdetailid = 0x000000000e00003f
delete from rs_systext where parentid = 0x000000000e00003f and sequence = 1
delete from rs_profdetail where profid = 0x000000000e000000 and pdetailid = 0x000000000e000040
delete from rs_systext where parentid = 0x000000000e000040 and sequence = 1

delete from rs_profdetail where profid = 0x000000000e010000 and pdetailid = 0x000000000e010042
delete from rs_systext where parentid = 0x000000000e010042 and sequence = 1
delete from rs_profdetail where profid = 0x000000000e010000 and pdetailid = 0x000000000e010043
delete from rs_systext where parentid = 0x000000000e010043 and sequence = 1

delete from rs_profdetail where profid = 0x000000000e020000 and pdetailid = 0x000000000e02003f
delete from rs_systext where parentid = 0x000000000e02003f and sequence = 1
delete from rs_profdetail where profid = 0x000000000e020000 and pdetailid = 0x000000000e020040
delete from rs_systext where parentid = 0x000000000e020040 and sequence = 1

delete from rs_profdetail where profid = 0x000000000e00000c and pdetailid = 0x000000000e000c27
delete from rs_systext where parentid = 0x000000000e000c27 and sequence = 1
delete from rs_profdetail where profid = 0x000000000e00000c and pdetailid = 0x000000000e000c28
delete from rs_systext where parentid = 0x000000000e000c28 and sequence = 1

delete from rs_profdetail where profid = 0x000000000e000012 and pdetailid = 0x000000000e001231
delete from rs_systext where parentid = 0x000000000e001231 and sequence = 1
delete from rs_profdetail where profid = 0x000000000e000012 and pdetailid = 0x000000000e001232
delete from rs_systext where parentid = 0x000000000e001232 and sequence = 1

timestamp columns are sent to the replicate database even if High Volume Adaptive Replication (HVAR) is set to on, send_timestamp_to_standby is set to off, and there is no replication definition defined.

Workaround: Either:

When configuring Replication Server 15.5 or later using the rs_init with an existing RSSD, an error occurs in rs_init.

If you increase the number of client connections and did not increase the number of Open Server™ threads that the Replication Server can use, Replication Server may shut down.

1. Log in to RSSD.
2. Increase the value of num_threads.
3. Restart Replication Server.

If the sort order is not set correctly in the [collate] section of %SYBASE%\ini\objectid.dat, a stack trace error occurs during Replication Server start-up.

1. Make sure that the character set and set order have been set correctly in Rep_Server_name.cfg file. For example:
   • RS_charset=cp850
   • RS_sortorder=scannocp
2. Go to %SYBASE%\charsets\character set; for example, %SYBASE%\charsets\cp850.
3. Locate and open corresponding sort order file; for example, scannocp.srt.
4. Check the line that has an “id” and find the sort order ID, for example,

   id = 0x30; Unique ID # (48) for the sort order

   The sort order ID is 48.

5. In %SYBASE%\ini\objectid.dat, check that there is a line for that sort order under the [collate] section:

   1.3.6.1.4.1.897.4.9.3.48 = scannocp

   The last number is the sort order ID (48), all other numbers are identical for all lines. If you have a custom sort order, add this line for it.

6. Restart Replication Server.

This may impact your replication performance.

Workaround:

• Use single quote (‘) or double quote(“) around the long repdef_name.
• Use a truncated repdef_name. Truncate the repdef_name to the first 29 characters when issuing the rs_helprep request. The rs_helprep then appends the % wildcard at the end when it queries the RSSD tables.
• Upgrade RSSD data server to Adaptive Server 15.x.

Workaround: Create the subscription without a quoted constant or create the subscription without materialization.

Workaround: Set the environment variable SACHARSET to GBK before starting the Replication Server.

Workaround: Suspend and resume the DSI connection. If the DSI thread does not suspend, restart the Replication Server.