The following is a list of issues addressed and enhancements implemented in this release of SharePlex.
NOTE: All Resolved Issues and Enhancement from SharePlex 9.2.9 and older are included in this release.
NOTE SharePlex has put bug fixes into a cumulative update rollup (denoted by third digit in the version number) — starting with the 9.2.3 release. Customers that require bug fixes which are already available in a patch update rollup will be required to apply that patch release to get the bug fix.
| Issue ID | Description |
|---|---|
| SPO-20762 | Fixed 'show export detail' statistics to be more accurate. |
| SPO-20453 | Fixed table name greater than 30 characters not replicating in Windows 2019. |
| SPO-20452 | Fixed copy issues where target database name contains a period. |
| Issue ID | Description |
|---|---|
| SPO-19998 | Fixed overflow processing DLOADs from OLTP table |
| SPO-19920 | Fixed Capture error using ASM disk with udev |
| SPO-19919 | Fixed Capture error using ASM partition with AFD |
| SPO-19910 | Fixed Post issues replicating compressed LOB data |
| SPO-19882 | Fixed Post exits due after executing reconcile |
| SPO-18858 | Fixed columns ignored when positioned after UDT column |
| SPO-18529 | Fixed CLOB data not replication to XML & JSON |
| Issue ID | Description |
|---|---|
| SPO-20665 | Fixed inconsistent processing of trailing NULL on chained row preventing it from properly replicating to Kafka. |
| SPO-20651 | Replication of comments on DDL can be disabled by setting SP_OCT_REPLICATE_COMMENT to 0. DDL replication is enabled by setting SP_OCT_REPLICATE_DDL to 1, 2, or 3. |
| SPO-20562 | Fixed cleanup of routing files to after activation is successful. |
| SPO-20524 | Fixed CREATE TABLE AS SELECT DDL not replicating correctly when DDL user is different from schema owner. |
| SPO-20454 | Fixed logic in Compare to work properly even when character set between endpoints are superset or subset of each other when SP_DEQ_CONV2UTF8 is enabled. |
| Issue ID | Description |
|---|---|
| SPO-20426 | Fixed Capture DDL replication of grant on commit refresh |
| SPO-20139 | Fixed Capture DDL processing of chained row in system table |
| SPO-20125 | Fixed Post XML missing trailing null columns |
| SPO-20033 | Fixed Windows issue with stopping SharePlex processes from Services |
| SPO-20024 | Fixed Post memory leak due to rollbacks |
| SPO-19633 | Fixed Compare/Repair issue where invalid duplicate checksums reports OOS |
| SPO-17868 | Fixed Post conflict resolution existing win log message output for most and least recent |
| SPO-19872 | Fixed performance issue with large partial rollbacks. |
| Issue ID | Description |
|---|---|
| SPO-19907 | Fixed ignored DDL when source and target database endianness are different |
| SPO-19834 | Fixed Post stopping when object cache missing from previous activation |
| SPO-19734 | Fixed Chinese NCHAR & NVARCHAR2 characters not showing up correctly in Kafka |
| SPO-19722 | Fixed Capture core when processing DLOAD from OLTP tables |
| SPO-19563 | Fixed Capture core when issuing DDL alter table modify on XML type column |
| SPO-19494 | Fixed Chinese NVARCHAR2 characters no showing up in Kafka |
| SPO-19468 | Fixed commits not routing to Post due to bad bitmaps in Read |
| SPO-19458 | Fixed compare ignoring nolocksource and nolocktarget parameters |
| SPO-19448 | Fixed Reader redundant processing rollback updates when using horizontal partition |
| SPO-19070 | Fixed VARRAY corrupting XML in Kafka |
| SPO-19003 | Fixed extra data appearing in XML from bad VARRAY parsing in Kafka.NOTE: VARRAY element in XML is fixed to now correctly be a child element of the parent column. VARRAY will no longer appear as a sibling to the column. |
| SPO-18985 | Fixed out-of-sync when operations are related using distributed transactions |
| SPO-18931 | Fixed Post DDL error creating table using materialized views |
| SPO-18875 | Fixed Post stopping when JMS not responding. Post will now retry automatically. |
| SPO-18800 | Fixed Linux endianness posting to Kafka causing invalid characters |
| SPO-18405 | Fixed posting bad records when using OLTP |
| SPO-18157 | Fixed Capture to correctly skip filtered out DDL |
| SPO-18154 | Fixed invalid numeric data by setting the value to zero when condition met in Capture |
| SPO-18146 | Fixed Open Post stopping when DDL messages are only updating object cache |
| SPO-18138 | Fixed CTAS issues when using non-qualified schema |
| SPO-17856 | Fixed Post error ORA-29877 on update table containing SDO_GEOMETRY column but not part of the update |
| SPO-17693 | Fixed upgrade issues from 9.2.1 when processing older DDL cache version |
| SPO-16944 | Fixed Post to properly update LOBs when using CDC |
| SPO-15820 | Fixed errors using Oracle Filter Driver with ASM disks in native mode |
| SPO-5032 | Fixed Poster error ORA-1805 using time zone |
| Issue ID | Description |
|---|---|
|
SPO-19151 |
Resolved capture performance issues when data not ready in log |
|
SPO-18872 |
Fixed post issues with delete-n where some columns contains NULL |
|
SPO-18866 |
Resolved corruption using alter table DDL on long name table |
|
SPO-18850 |
Resolved offset calculation on SecureFiles CLOB with Japanese CharSet |
|
SPO-18838 |
Resolved issue with alter table DDL using dbms_job package |
|
SPO-18798 |
Fixed SP_OPX_REDUCED_KEY=2 using update containing keys and non-keys |
|
SPO-18628 |
Fixed issue with create public synonym |
|
SPO-18625 |
Fixed conversion issues with SJIS Ⅱ symbol |
|
SPO-18615 |
Fixed SQL Server ODBC driver issues using float |
|
SPO-18501 |
Fixed post inserting CLOB with ORA-64204 error |
|
SPO-18402 |
Fixed corruption issues in object cache on tables with UDT |
|
SPO-18169 |
Compare now properly supports configurations that use compound routes |
|
SPO-18029 |
Fixed issue with converting exponential number with some SQL Server ODBC drivers |
|
SPO-17592 |
Fixed conversion issues with UTF16 Chinese |
|
SPO-17318 |
Fixed installation issues as root on Red Hat |
|
SPO-17005 |
Fixed issue replicating insert operation on compressed tables |
|
SPO-10528 |
Resolved issue with parsing SecureFiles LOB where data object ID not extracted |
|
SPO-10282 |
Fixed capture to better handle alter table shrink table |
|
SPO-3828 |
Changed read update of SharePlex marker to once per second |
| Issue ID | Description |
|---|---|
| SPO-10592 | Fixed post failure when executing 'alter index' with a fully-qualified index name for table replicating to a different schema on target. |
| SPO-15132 | Fixed messages not getting sent when using DML filtering. |
| SPO-16402 | Fixed XML/JSON document types to format null & empty data as attributes. |
| SPO-17528 | Fixed XML document emitting extra tags for CDC. |
| SPO-17863 | Fixed network issue when using SSL. |
| SPO-17991 | Fixed sp_utils not properly showing port numbers. |
| SPO-18202 | Fixed post error recovery accessing row of a record after insert error. |
| SPO-18224 | Fixed read error when using DML filtering |
| SPO-18259 | Fixed better recovery handling after encountering SSL error. |
| SPO-18321 | Fixed export using SP_SYS_HOSTNAME IP when set |
| SPO-18419 | Enhanced capture performance. |
| SPO-18487 | Fixed post shutdown due to ORA-01458 after upgrade and SQL cache is enabled. |
| SPO-18501 | Fixed automatic detection of UTF16 CLOB data. |
| SPO-18527 | Fixed internal routing data to better handle non-UTF8 characters. |
| SPO-18617 | Fixed parsing of DLOAD record with OLTP. |
| SPO-18794/4506554 | ON CASCADE DELETE constraints are now supported. |
| Issue ID | Description |
|---|---|
| SPO-16402 | Corrected XML messages not properly tagging NULL or EMPTY columns |
| SPO-17528 | Resolved XML messages including extraneous metadata |
| SPO-17991 | Fix Windows 'SharePlex Utilities' not showing correct port number for associated processes |
| SPO-18321 | Fix export not using SP_SYS_HOST_NAME parameter value |
| SPO-18419 | Resolved capture performance issues |
| SPO-18487 | Fix post stopping due to ORA-1458 after upgrading when SQL cache is enabled |
| SPO-18501 | Fix post stopping due to ORA-600 or ORA-64204 when using CLOB caused by incorrect character set parsing |
| Issue ID | Description |
|---|---|
| SPO-17377 | Corrected an issue that caused the Post process to stop with the following error: "ORA-01741: illegal zero-length identifier." |
| SPO-17384 | Corrected an issue in which a DDL transaction (alter table to add partition) was not processed successfully after a database upgrade. |
| SPO-17507 | Resolved an issue which caused the Repair process to fail because the SQLite marker table used in the Compare process was not successfully created. |
| SPO-17668 | Resolved an issue that caused remote Capture to stall when reading online logs and disk_asynch_io was enabled on the remote database. |
| SPO-17681 | Corrected an issue which caused the following error when replicating to JMS: "No such file or directory - bridge.ini." |
| Issue ID | Description |
|---|---|
| SPO-10567 | Improved error-handling and advice for the following errors: SP-OCT01004 and SP-OCT01005. |
| SPO-10836 | Corrected an issue in which having a schema/object DDL filter causes all DDL that has no schema/object name to be filtered. |
| SPO-11221 | Oracle Poster core dumping in Breaklines |
| SPO-11443 | Post Enhanced Performance (PEP) improvement. |
| SPO-11501 | PEP (dependency checking) should skip objects that are disabled |
| SPO-13894 | A description of the copy cache command is now included in the SharePlex 9.2 Reference Guide. |
| SPO-14638 | Allow Comment on Table to pass through as non-recursive DDL |
| SPO-15088 | Corrected an issue in which Capture generated the incorrect Update operation that updates a non-NULL column with NULL value. |
| SPO-15449 | Corrected an issue in which detecting Kafka supported versions fails for SUSE Linux. |
| SPO-15452 | Corrected an issue which caused a core dump when Capture processed autoadd on a table with complex/nested UDT columns. |
| SPO-15455 | Corrected an issue that caused an error in SQL Server to SQL Server replication when the source database uses BIN or BIN2 binary collations. |
| SPO-15519 | When DDL greater than 319K is encountered, discard it and log an error instead of dumping the core. |
| SPO-15523 | Corrected an issue which caused a failure when posting the DDL for a interval-partitioned table created with an unnamed partitioned in create table statement. |
| SPO-15553 | Corrected an issue in which upgrading Oracle from 11.2 to 12.2 caused Capture to erratically drop the replicated tables. |
| SPO-15685 | Corrected an issue in which issuing a non-replicated create sequence with SP_OCT_AUTOADD_SEQ=1 and SP_OCT_REPLICATE_ALL_DDL=0 (default) caused a defunct entry in 9iDDLcache file. |
| SPO-15856 | Improved Processing of CLOBS. |
| SPO-15937 | Corrected an issue involving OCI calls being called on non-ASM RAC is setup without enabling OCI parameter. |
| SPO-15952 | Corrected an issue that caused Poster core dumping in keycache. |
| SPO-15959 | Corrected an issue in which compare SQL statement missing user-provided Oracle partition for the SP hz partition table. |
| SPO-16076 | Corrected an issue that caused an activation error upon reactivating the same configuration after a rename. |
| SPO-16114 | Certain redo-record with compressed data caused Capture to core. |
| SPO-16161 | Capture failed to parse certain redo-records generated from Oracle 12cR2. |
| SPO-16257 | When changing the SharePlex User password using the ora_chpwd utility, the "alter user" privilege is required instead of the DBA role. |
| SPO-16264 | During SharePlex installation on Windows, if the MKS installation fails, the SharePlex installation does not proceed. |
| SPO-16474 | Renaming sets of tables on peer-to-peer setting could cause ODR message to loopback causing failure in Post process. |
| SPO-16486 | Open Target logs invalid WHERE clause column_name = null in sqlerror.log |
| SPO-16700 | Removed the limitation of 8192 bytes for SQL text. The limitation caused a "SQL too large" error message during Capture. |
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center
