Chat now with support
Chat with Support

SharePlex 9.2.9 - Upgrade Guide for Oracle Source

Resolved Issues and Enhancements

The following is a list of issues addressed and enhancements implemented in this release of SharePlex.

SharePlex 9.2.9

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.

SharePlex 9.2.8

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

SharePlex 9.2.7

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

SharePlex 9.2.6

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

SharePlex 9.2.5

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.

SharePlex 9.2.4

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

SharePlex 9.2.3

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."

SharePlex 9.2.1

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.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating