Chat now with support
Chat with Support

SharePlex 9.2.7 - 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.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.

SharePlex 9.2

Issue ID Description
SPO-920 Add reminder: to bounce sp_cop once new key is added
SPO-1208 Enhancement to have double quote around the SharePlex cop service path
SPO-2647 Redo GMT adjustment only works on Linux - provides inaccurate latency any other platform
SPO-3196 Rollback of errors not working
SPO-3198 Prevent unsupported DDL from being transmitted to the open target post
SPO-3267 Enhancement: SharePlex now searches for archive logs in the subdirectories as well as the main directory of the path specified by SP_OCT_ARCH_LOC.
SPO-4592 Suppressed out of sync not being called for deletes
SPO-4643 Poster memory leak in full rollback
SPO-4665 Setting parameter sp_opo_cont_on_err to 2 will instruct poster to treat table errors the same as other errors and stop unless they are in the oramsglist file.
SPO-10305 Show capture detail and "show post detail" should have same LSN
SPO-10337 Enhancement: For a SQL Server capture, "show capture detail" now includes log number, log offset, and timestamp of last transaction processed.
SPO-10441 SQL Server Supportability through Utilization Timers
SPO-10623 SQL Server activation will activate SharePlex tables
SPO-10671 High CPU usage when colcache grows
SPO-10812 Poster won't stop on an ora-00942 error during DDL operation
SPO-10820 Qstatus reports incorrect size
SPO-11102 Enhancement: Added a message to event_log indicating that there is encrypted data in redo.
SPO-11647 Enhancement: Added support for Extended Statistics for Oracle 12c to correct an issue that caused a post error if extended statistics were gathered on source and target table.
SPO-12112 Autoadd of Materialized View created with certain syntax caused capture to core
SPO-12269 Capture did not replicate CreateUser/Gratn/AlterUser DDLs issued using DataPump
SPO-12286 XML varray Out of row dumps core and varray replication results in bad data (extra characters appended to values) in XML file.
SPO-12322 Suppressed out of sync core dumps - probably when update has empty columns
SPO-12404 Added restart logic for Kafka based on error
SPO-12407 Oracle Poster core dumping in PEP
SPO-12442 QMI (Array insert) on tales with ROW-DEPENDENCIES on Oracle 12cR2 failed
SPO-12578 Compare numeric partition/subpartition name failed
SPO-12602 Advice message wrong for SP_OPO_STOP_ON_DDL_ERR
SPO-12887 OT skip continue negative error number does not work
SPO-12924 ORA-22053 converting sys.tab$.property to 64 bit integer
SPO-13034 Missing ' in sql error file for '|| string data
SPO-13055 Compare fails with table name that includes Japanese characters.
SPO-13080 Poster to use default ddl schema for create synonym
SPO-13177 Minimize 2 pass with horizontal partitioning enabled
SPO-13198 Factor in possible 0 value for min sequence# in min query to prevent core capture
SPO-13337 Post fails applying varray od SDO_GEOMETRY
SPO-13385 Multi-OCI mode failure on HP-UX IA64 platform. Added LogParallelism debug to track Out-Of-Order records.
SPO-13534 On Windows, "show statusdb detail" command causes sp_ctrl to exit.
SPO-13556 Improved compare performance when the source and target character sets are different.
SPO-13596 The Poster core dumps when connecting to Postgres with SSL.
SPO-13622 Improved performance of CDC (in change-history environment)
SPO-13673 Poster core dump in batch of update on a table with many columns (over 500)
SPO-13829 Enhancement: Enhance manner used to save reader's ccache to reduce memory usage and physical size.
SPO-13872 Enhancement to truncate tranx file assuming only 1 open transaction based on class/slot.
SPO-14050 Addressed issue of missing DDLs in DDL log.
SPO-14058 Simplified installing SharePlex on Windows: When installing on a Windows platform, you are no longer required to specify Oracle version or whether or not it is a non-Oracle installation.
SPO-14059 You no longer need to change the default setting for Global Resources memory in the MKS Toolkit after you install SharePlex on a Windows system. The setting is now modified automatically during installation.
SPO-14060 When you uninstall SharePlex software in a Windows environment, MKS Toolkit and NuTCRACKER are now removed automatically.
SPO-14124 Corrected an issue that caused a "no such file" or "directory rename failed" error when there are multiple imports.
SPO-14184 Compare/Repair hangs while waiting for lower case lock file when ora_setup is using lower case tns alias.
SPO-14196 Corrected an issue that caused the following Oracle error: ORA-01740 missing double quote in identifier.
SPO-14207 Address issue with Oracle error 942 when rename causes reader to query tables before the rename
SPO-14401 Import should exit when the connection fails
SPO-14437 A particular sequence of operations in IOT caused capture to generate a ''10651 - op ID failed'' message in the event_log.
SPO-14541 Allow custom "FROM" in sp_nt_mon
SPO-14585 Replication to Kafka with JSON without quotes for numeric data type
SPO-14744 Capture intermittently generates ODR message for Drop Sequence DDL with a bad SQL option
SPO-14768 Fixed licensing for empty HostID on Windows
SPO-14779 In a peer-to-peer environment, after Drop/Create Sequence was issued on source host, issuing 'show config' command resulted in a mismatch between hosts.
SPO-14785 Ensure debug in key cache is only logged if debug is set.
SPO-14898 Discard messages which need complete keys if debug setting is set.
SPO-14901 In the SharePlex Reference Guide, the compare command option nolock has been removed and replaced by the correct options: nolocksource | nolocktarget | nolockboth.
SPO-14918 Improve the performance when a transaction has a lot of rollbacks
SPO-14932 Handle Oracle error 2396, IDLE time exceeded
SPO-15057 Sybase issue with number in exponent format such as 8330e-2
SPO-15132 Address issue with ccache corruption with DML filters. Regressed from ccache size fix.
SPO-15210 Compare is slow over WAN
SPO-15243 Allow the user in connections.yaml to be changed via the connection command in sp_ctrl
SPO-15280 SCN is zero on CDC update after record
SPO-15340 Unchanged column with non-NULL default value could be updated to NULL value.
SPO-15462 Resolved an issue that caused Compare to run longer in 9.1.3 over 8.6.3
SPO-15597 Cop does not load all auto-open wallets when there are multiple datastores with auto-open mode in connection.yaml file.
SPO-15600 Poster core dump on horizontal partition table insertN
SPO-15782 Resolved an issue which caused object cache break up to be forwarded with a hardcoded size of 1000 bytes.
SPO-15817 Corrected an issue which resulted in missing or incorrect Change History data.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating