Known Issues for ExpressConnect for Oracle

Incorrect function string for Oracle database resynchronization causes the DSI to shut down.

E. 2012/09/06 17:47:40. ERROR #5046 DSI(myds.mydb) - /dsioqid.c(xxxx)
When executing the rs_get_lastcommit function in database 'myds.mydb', 
received data server errors. See logged data server errors for more 
information.

Workaround: If your DSI uses an Oracle function string class, apply these commands directly to the RSSD, and restart Replication Server:

delete rs_systext where parentid= 0x000000000ffffd2a
insert into rs_systext values(0, 0x000000000ffffd2a,
'O',1,'delete from rs_lastcommit where origin = 
?rs_origin!sys? ; insert into rs_lastcommit values 
(?rs_origin!sys?, HEXTORAW(''0000000000000000000000
00000000000000000000000000000000000000000000000000''
),')
insert into rs_systext values(0, 0x000000000ffffd2a,
'O',2,'HEXTORAW(''0000000000000000000000000000000000
00000000000000000000000000000000000000''), sysdate, 
sysdate) ; commit')

If your DSI uses a user-defined function string class, use the create function string command to update the function string. For example:

create function string rs_reset_lastcommit
for private_function_class with overwrite
output language 'delete from rs_lastcommit where 
origin = ?rs_origin!sys? ; 
insert into rs_lastcommit values (?rs_origin!sys?, 
HEXTORAW(''0000000000000000000000000000000000000
00000000000000000000000000000000000''),
HEXTORAW(''0000000000000000000000000000000000000
00000000000000000000000000000000000''), sysdate, 
sysdate) ; commit'

Replication Server fails to load the ExpressConnect for Oracle (ECO) library files on Windows x86 32-bit system due to missing Microsoft Visual C++ 2005 Service Pack 1 Redistributable Package MFC security update.

Workaround: Download and install the Microsoft Visual C++ 2005 security update:

http://www.microsoft.com/en-us/download/details.aspx?id=26347

ExpressConnect for Oracle does not support opaque datatypes.

The Replication Server opaque datatype is not supported by ExpressConnect for Oracle 15.7.1, which means that this version of ExpressConnect for Oracle cannot support user-defined datatypes and the Oracle anydata function.

Workaround: None.

ExpressConnect for Oracle fails when bulk copy is enabled and the bulk copy threshold is set to 1.

ExpressConnect for Oracle fails when you set dsi_bulk_copy to on and dsi_bulk_threshold to 1. Setting dsi_bulk_threshold to 1 deteriorates and suspends the Data Server Interface (DSI).

Workaround: Set dsi_bulk_threshold to 2 or higher.

LOB value not being applied to existing row.

When replicating an LOB column, ExpressConnect for Oracle first determines the ROWID value for the Oracle row that should contain the LOB. The row for that ROWID is updated with the LOB value. However, if the table in the replicate Oracle database is a reference table, and the parent table is partitioned across multiple tablespaces, then the ROWID returned for the reference table may be incorrect, resulting in the LOB value not being applied to the expected row. The Oracle bug ID for this incorrect ROWID problem is 8417690.

Workaround: None.