Chat now with support
Chat with Support

SharePlex 10.2 - Release Notes

Release Notes

SharePlex® 10.2

Release Notes

Revision: 8/5/2024

 

About SharePlex

SharePlex provides high-speed replication from Oracle database to different target databases and messaging containers on major Unix, Linux and Windows operating systems— both on-premises and in the cloud. SharePlex supports a wide variety of configurations to meet different and complex data availability needs.

SharePlex supports reliable Oracle high availability configurations where replication maintains a duplicate database in a different location that is ready for fast, seamless failover and failback in planned or unplanned mode.

You can also use SharePlex to replicate data from Oracle source to maintain a change history database in an Oracle target. Rather than updating or deleting target rows based on the source change, SharePlex inserts a new row on the target for every source change. The result is an archive that reflects the chronological history of every change made to the source database.

SharePlex also includes, at no extra charge, the compare and repair tools that you need to verify the accuracy of a target maintained by replication. These tools not only detect hidden out-of-sync conditions, but they also repair the target to restore parity of your source and target data.

SharePlex value and versatility continues to grow with the requirements and requests of our customers. Although SharePlex is a reliable, relatively low-maintenance solution, our top-rated support team is ready around the clock to help with any trouble you may have. To get you started with your deployment, our professional services team is highly experienced and readily available.

Join our community

For expert advice and the latest news about SharePlex, join the SharePlex Community at https://www.quest.com/community/products/shareplex. Take advantage of our forums, blogs, videos, and more from our own experts, as well as input from our customers and partners.

About this release

This is a minor release with new and enhanced functionality.

This is a minor release and includes new features and enhanced functionality.

Revision History

Document Version Date Change History
2 5th March 2024 Added an important note regarding OLS policy configuration in the Conditions of Support - OLS section.
3 19th March 2024 Updated the Oracle Solaris SPARC support information.
4 6th May 2024
5 5th August 2024 Added a limitation regarding the replication of data containing the ALTER statement during DDL operations.

New Features

New Features in this Release

SharePlex 10.2

Extended Data Types Support

SharePlex supports replication of data with Extended Data Types for the Oracle-to-Oracle replication. The following maximum sizes are now supported for the following data types:

  • VARCHAR2 (4000-32767)
  • NVARCHAR2 (4000-16383)
  • RAW (2000-32767)

Limitations: The following limitations apply to support for Extended Data Types:

  • Horizontal partitioning is not supported by tables containing the Extended Data Type columns.
  • Extended Data Types are not supported for the Copy command.
  • SharePlex does not support the Extended Data Type size on a key column.
  • SharePlex does not replicate data with Extended Data Type when target type is JMS Message Queues, File output (XML, JSON, SQL), Event Hubs, or Kafka.

Database Setup for Oracle in Silent Mode

Users can now run the Database Setup (ora_Setup) utility for Oracle in the background. This utility can be run in silent mode without user intervention. The ora_setup utility runs in an unattended mode by reading required parameter details from config file prepared in a specific format.

Note: Database setup for Oracle in silent mode supports only on the Linux platform.

Oracle Cloud Infrastructure Support

SharePlex now supports the following Oracle Cloud Infrastructure:

  • Oracle Exadata Cloud Service (ExaCS)
  • Oracle Exadata Cloud@Customer (ExaCC)*
  • Oracle Database Cloud Service (DBCS)

Note: *Issues on Oracle Exadata Cloud@Customer will be tested against Oracle Exadata Cloud Service for reproduction purposes.

JRE/JAVA Support

We have upgraded the JRE/JAVA version from 1.8.0_192 to 1.8.0_312.

Other New Features

  • This release includes support for data replication from Oracle to Azure SQL Managed instance.
  • DDL changes can now be captured during Activation from SCN.
  • Upgraded the log4j version to 2.17.1.

SharePlex 10.1.3

Kafka Support

Kafka 3.0: This release includes support for replication to Kafka 3.0 target.

SharePlex 10.1.2

Oracle Remote Capture Support

SharePlex running on Linux supports Remote Capture for all supported versions of Oracle.

MySQL and PostgreSQL Support

This release includes support for the below platforms:

  • Oracle to PostgreSQL
  • Oracle to MySQL
  • Cloud support for PostgreSQL and MySQL databases on Azure, Amazon RDS and AWS

SharePlex 10.1.1

SQL Server Support

This release includes support for the below platforms:

  • Azure SQL Database as a target
  • Oracle 19C to SQL Server
  • SQL Server 2019 as a target
  • Remote Post from Linux to SQL server

SharePlex 10.1

OLTP Compression Support

This release includes support for OLTP compression from and replication to Oracle 19c on the Linux, AIX, and Solaris platforms.

Kafka Authentication and Encryption Support

Support for mTLS Authentication in Kafka: This release includes support for replication from Oracle to Kafka using mTLS authentication.

Support for Kerberos Authentication in Kafka: This release includes support for replication from Oracle to Kafka using Kerberos authentication.

Support for SASL Authentication in Kafka: This release includes support for replication from Oracle to Kafka using SASL authentication.

Support for SSL encryption in Kafka: This release includes support for replication from Oracle to Kafka using SSL encryption.

Date formatting support: SharePlex supports date formatting for all the open targets (such as JMS, file, Kafka) for the XML and JSON record formats.

Azure Event Hubs Support

Support for Azure Event Hubs: This release includes support for replication from Oracle to Azure Event Hubs.

SharePlex 10.0

Database Support. This release of SharePlex includes support for the following database versions:

  • Oracle 19c. This release includes support for capture from and replication to Oracle 19c on all platforms(except HP/UX).
  • Oracle 19c on RDS. This release includes support for capture from and replication to RDS running Oracle 19c.

NOTE: Advanced Row (OLTP) Compression is not supported by SharePlex 10.0 for replication of objects using DML operations in Oracle 18c and 19c. This limitation applies to objects in the source database.

SharePlex 9.4

Database Support. This release of SharePlex includes support for the following database versions:

  • Oracle 19c on Linux. This release includes support for capture from and replication to Oracle 19c on Linux platforms.

NOTE: 9.4.0 is a Linux only release. To properly replicate from SharePlex 9.4.0 capture (source) to a non-9.4.0 target, set the SP_SYS_TARGET_COMPATIBLITY. See Interoperability between versions for how to use and set this parameter.

NOTE: OLTP compression is not supported by SharePlex for replication of objects using DML operations in Oracle 18c and 19c. This limitation applies to objects in the source database.

New Features for Oracle Source

Oracle Cloud Infrastructure as a Service (IaaS) Compute Virtual Machine is now supported as a target.

Support for Extended Data Types. SharePlex now supports the Extended Data Type sizes introduced in Oracle 12c. The following maximum sizes are now supported for the following data types in Oracle to Oracle replication:

  • VARCHAR2 up to 32767 bytes
  • NVARCHAR2 up to 32767 bytes
  • RAW up to 32767 bytes

Note: The following limitations apply to support for Extended Data Types:

  • Extended Data Types are not supported for the copy command.
  • SharePlex does not support the Extended Data Type size on a key column.

Support for Invisible Columns. SharePlex now supports replication of a column that has been defined as invisible, a feature that was introduced in Oracle 12c. Invisible columns are supported in DML and DDL replication for Oracle source to Oracle target.

Improved Performance in the Post Process for CLOB Data. Enhancements designed to improve Post performance when posting CLOB data to Oracle have been implemented in this release. These improvements are applicable to CLOB or BLOB data with a maximum size less than 32768 bytes.

Support for Kerberos Authentication in Kafka. This release includes support for replication from Oracle to Kafka using Kerberos authentication.

Other New Features

Database Support. This release of SharePlex includes support for the following database versions:

  • Kafka 2.0.x and 2.1.0. This release includes support for replication to Kafka 2.0.x and 2.1.0 targets.

Use Provision to Change IP Address Only. The provision command includes a new option which allows you to change the IP address only.

  • To change the IP address only, use the following syntax:

    provision -o old_ipaddress-s new_ipaddress [-p port ] [-n]

New Parameters

New Open Target Post Process Parameter. The new parameter SP_OPX_ONELINE_DEBUG_COLUMNS controls whether or not column values are logged when SP_OPX_ONELINE_DEBUG is enabled. This is useful for diagnosing out-of sync conditions. To log column values for the objects specified when online debug is enabled, set SP_OPX_ONELINE_DEBUG_COLUMNS to 1.

New Compare Parameter. You can use the new SP_DEQ_THREAD_SELECT parameter to generate an additional thread to keep the TCP/IP connection alive while SharePlex selects the rows for comparison. The selection process runs in the child thread while the parent thread is used to keep the TCP/IP connection alive. This is useful for a table with a very large number of rows where the selection process can run for an extended period of time.

Disable Replication of Add Comment DDL. The new parameter SP_OCT_REPLICATE_COMMENT controls whether or not SharePlex replicates ALTER TABLE to ADD COMMENT and COMMENT ON operations on tables that are listed in the configuration file. To disable the replication of these operations, set this parameter to 0.

SharePlex 9.2.3 to 9.2.10

SharePlex 9.2.3, 9.2.4, 9.2.5, 9.2.6, 9.2.7, 9.2.8, 9.2.9, and 9.2.10 are the patch releases and includes resolved issues. See Resolved Issues and Enhancements for a complete list.

SharePlex 9.2.4: Oracle Cloud Infrastructure as a Service (IaaS) Compute Virtual Machine is now supported as a target.

SharePlex 9.2.1

SharePlex 9.2.1 is a minor release and includes the following new features and enhanced functionality.

Other New Features

  • Oracle 18c. This release includes support for capture from and replication to Oracle 18c.

Note: SharePlex does not support replication of DML operations on objects compressed using OLTP Compression in Oracle 18c. This limitation applies to objects in the source database.

  • Kafka 1.1.x. This release includes support for replication to a Kafka 1.1.x target.

Operating System Support. This release includes support for SuSE SLES 15.

Installation

SharePlex installer packages for Linux/Unix. SharePlex installer packages for Linux/Unix are now database independent. You are no longer required to select an installer package based on the database for which SharePlex will be used (i.e., Oracle or Open Target). To install Quest® SharePlex™ or Open Target, simply select the installer package for your operating system.

The SharePlex installer packages now have a slightly different naming convention:

SharePlex-release#-build#-platform-chipset.tpm

For Oracle Solaris (Sun), the operating system version is included:

SharePlex-release#-build#-platform-version-chipset.tpm

SharePlex 9.2

SharePlex 9.2 is a minor release and includes the following new features and enhanced functionality.

New Features for Oracle Source

Oracle UROWID data type. Support has been added for the Oracle UROWID data type. This support applies to Oracle-to-Oracle configurations only.

Support for SCN metadata for HANA target. This release of SharePlex supports posting the Oracle SCN to a column in a HANA target table.

Oracle replication to MySQL 5.7. SharePlex supports replication from an Oracle source to a MySQL 5.7 target on-premises.

Oracle 12c R2 Support

Support for 128-byte table and column names. In Oracle capture, SharePlex now supports table and column names that are up to 128 bytes in length. Please note the following limitations applicable to this release.

  • UDT column names more than 30-bytes in length are not supported.
  • Type names for UDTs and VARRAYS with names more than 30-bytes in length are not supported.
  • IOT names more than 30-bytes in length are not supported.

Other New Features

Support for Windows Server 2016. Support for capture from and replication to databases on Microsoft Windows Server 2016.

Improved Performance in the Post Process.

The following enhancements were made to improve performance of the Post process.

  • Implemented multi-threading for SQL Server and PostgreSQL targets: The Transaction Concurrency component of Post Enhanced Performance has been extended to support SQL Server and PostgreSQL targets. A new parameter, SP_OPX_THREADS, controls this feature. When set to a value of 2 or greater, Post runs with the specified number of threads (concurrent operations).
  • Batch similar operations: To maximize its performance when applying SQL operations to the target, the Post process groups smaller replicated operations into one larger batched operation. Post groups replicated operations when the operations are identical and the SQL is similar. A new parameter, SP_OPX_BATCH_ENABLE, controls this feature and is enabled by default. Another new parameter, SP_OPX_MAX_BATCH_MBYTES, controls the maximum size of the batched DML operation that Post applies to the target. This supports databases, such as Teradata, that have a maximum transaction size and can be used for other purposes where batch size must be changed.

New jobs status database

  • This release includes a new jobs status database. This database resides in the data sub-directory of the SharePlex variable-data directory. The parameter SP_SYS_JOB_HISTORY_SIZE allows you to control the size of this database. Use this parameter to specify the maximum size (in kB) allowed for the database.

Simplified SharePlex Installation Process on Windows

  • When installing on Windows, you are no longer required to specify the Oracle database version or specify whether or not you are installing in a non-Oracle environment.
  • You no longer need to manually 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.

Data Type Mapping

This release of SharePlex includes a new typemap command, as well as changes to the default data type mappings. Review the following details.

  • Use the typemap show command to display all default data type mappings. Use typemap show source-target to display the mapping for the specified source-target combination, for example oracle-sqlserver. See the SharePlex 9.2 Reference Guide for more information about using the typemap command.
  • Use the typemap command instead of the data type option of the target command. (The data type option of the target command has been discontinued in this release.)
  • For a list of supported data types, see Supported Data Types: Oracle to Open Targets or .

Other Changes in SharePlex

TLS 1.2 (or later) required for TLS connections. If you intend to use TLS connections in SharePlex, TLS 1.2 or later is required.

Resolved Issues and Enhancements

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

Note: All Resolved Issues and Enhancement from SharePlex 10.2 and older are included in this release.

NOTE: SharePlex 10.2 contains all of published bug fixes from 10.0 and older. Several issues addressed by one-off releases in 10.1.0, 10.1.1, and 10.1.2 were not accumulated in this release, but will be included in the upcoming release. For any queries related to upgrading from 10.1 or 10.1.1 or 10.1.2 to 10.1.3 or bug fixes or documentation, please contact Quest Technical Support.

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.

SharePlex 10.2

Issue ID Description
SPO-23511/ SPO-22963/ SPO-22960/ SPO-22794 A huge memory consumption by the sp_opst_mt (Poster) process is affecting the performance of the Oracle database.
SPO-23168 Object cache is displaying the status of the object as Not in Replication after activating a config file.
SPO-23166 SharePlex Poster is not able to delete few records from a table without PK/UK.
SPO-23130

Added the below replication parameters as internal parameters in the param capture list.

  • SP_OCT_REPLICATE_COMMENT
  • SP_OCT_REPLICATE_GRANT
  • SP_OCT_REPLICATE_SYNONYM
  • SP_OCT_REPLICATE_TRIGGER
SPO-22934 SharePlex is not able to connect to Azure Database using pg_setup while replicating data from Oracle to Azure PostgreSQL Flexible-Server. This issue is observed because the @ character is not used in the username of Azure's flexible server.
SPO-22925 SharePlex Poster dumps core when users perform the Array Delete operation on a table that has the null data for one of the columns. This issue is observed when the conflict resolution is enabled and the SP_OPO_SUPPRESSED_OOS is parameter set to 0.
SPO-22923 Poster object cache is displaying the 'Internal error: Poster exit on 9i ddl error due to ORA-00955' error when running the DDL operation on the source database.
SPO-22877 Replicating Binary LOB data with special characters is causing tables go out of sync on target. This issue is observed intermittently.
SPO-22792 When users run the Compare command on the DML logs, the Compare Status report provides incorrect information as a few rows are out-of-sync even when source and target are in sync.
SPO-22777 SharePlex Poster is displaying an error when users add a column with the default value in an Alter table.
SPO-22732 Poster is not checking the information for foreign key after setting the SP_OPO_DEPENDENCY_CHECK parameter to 1.
SPO-22521 SharePlex is displaying an error when the SP_ctrl command is run on Windows with host or password containing the @ character.
SPO-22429 SharePlex is displaying the 'ERROR: invalid byte sequence for encoding "UTF8": 0xfd;' error related to character mapping while replicating data from an Oracle database to a PostgreSQL database.
SPO-22356 Users are not able to monitor latency in SharePlex 10.0 and 10.1 environments using SharePlex Manager 3.0.
SPO-22355 SharePlex Poster stops with an Invalid Column error when the DDL Alter operation is performed on the replicated table on the SQL file target.
SPO-22354 SharePlex is displaying the 'IP address not found in host file' error while running the provision utility on the target.
SPO-22315 Poster queue is getting stuck with frequent locking in the database and creating a huge backlog when the SP_OCT_REDUCED_KEY parameter is set to 0 and the SP_OPO_REDUCED_KEY parameter is set to 1.
SPO-22284 SharePlex Capture is failing when trying to read data from an archive log. When Capture is not able to find the archive log, it tries only one more time and if not found, it stops the process. The issue is observed while replicating data from the Dataguard Standby instance.
SPO-22276 SharePlex is displaying the Incomplete Key Set error while replicating data from a source to a target. After SharePlex is upgraded to version 10 and Oracle is upgraded to 19c, some of the updates are missing on the target.
SPO-22210 SharePlex Poster process intermittently displays the 'ORA-12805: parallel query server died unexpectedly' error while performing the DDL task.
SPO-22085 SharePlex displays if failing when users run the Compare Using command with the config file. The issue is observed when the config file has lines with a trailing comment after the routing map field.
SPO-22075 SharePlex Compare or Repair process stops while connecting to the target side message with the Connection timed out error.
SPO-21946 When there are multiple ODR_DEACTIVATE_POST messages in the Export queue, the Import process is failing when it is trying to write a second ODR_DEACTIVATE_POST message.
SPO-21720 Poster queue stops with the 'missing commits detected' warning.
SPO-21685 SharePlex Capture is failing with an error while reading the archive log on the dload operation.
SPO-21664 SharePlex Poster stops with object ID related error when recreating sequences for data replication.
SPO-21635

SharePlex Poster is facing the memory leak issue with SQL Cache in the following conditions:

  • Change history target
  • SP_OPO_SQL_CACHE_DISABLE = 0 (default:0)
  • SP_OPO_TRACK_PREIMAGE = U (default:none)
  • UPDATE operations from source
SPO-21512

SharePlex Capture stops with an error when reading the archive log for an object that has XML datatype. This issue is observed when the XML datatype has the namespace tag as part of inner child tags.

SPO-21454 The Compare and Repair process is failing when comparing large tables with NCHAR columns using the Key option.

SharePlex 10.1.3

Issue ID Description
SPO-22794

SharePlex Poster is getting stuck and causing performance issues as the sp_opst_mt Poster process consumes a large amount of memory.

SPO-22315

Poster queue is getting stuck while performing the batch delete operation and causing a high backlog. This issue is observed intermittently.

SharePlex 10.1.2

Issue ID Description
SPO-21934

The issue is observed while creating a new SharePlex user in Azure SQL DB from the mss_setup database setup utility.

SPO-21998

When the "storage in row" clause is enabled on the source table, Poster stops with an error while replicating a large CLOB data from RDS System to MS SQL 2019.

SharePlex 10.1.0

Issue ID Description
SPO-21590

While replicating the table that has the INTERVAL DAY TO SECOND Type columns, the compare/repair process fails for comparison with an Oracle hashing error.

Workaround: Enable the SP_DEQ_USE_SP_CKSUM parameter on both source and target database. (sp_ctrl> reset param SP_DEQ_USE_SP_CKSUM)

SPO-21550

SharePlex displays an error when a user runs a provision command on the source database in the existing replication. This issue is observed when the queue name in the rim directory has the "RS" characters.

Workaround: Rename the queue names inside the rim directory such that it does not have the "RS" characters in it.

SPO-21513 SharePlex displays the "JSON columns not supported" warning when activating tables with a specific constraints, even when there are no JSON columns in the table that are added to activation.
SPO-21508 SharePlex replicates the Grant commands for the definition table to the target database even when the SP_OCT_REPLICATE_GRANT parameter is set to "0".
The issue is resolved by using the below workaround.
Workaround: Configure the SHAREPLEX_DDL_CONTROL table to exclude the replication for the grant command.
SPO-21342 SharePlex displays out of synchronized tables even after performing the repair operation. The issue is observed on the source and the target database, both.
SPO-21465 After performing an INSERT operation, the CDC table displays the INSERT BEFORE row twice instead of displaying two different rows, INSERT BEFORE and INSERT AFTER with the same value on the SHAREPLEX_SOURCE_OPERATION column. This issue is observed when the SP_OPO_TRACK_PREIMAGE parameter is set to I/U/D.
SPO-21463 sp_ctrl fails to start and displays an error when auth_hosts is implemented and SSL is enabled using sp_security on both source and target database.
SPO-21168 The memory usage of the SharePlex sp_copsrv.exe process started increasing before expected timeline. This issue is observed on the Windows operating system.
SPO-21076 SharePlex capture process stopped due to a memory leak issue. This issue is observed on the SharePlex 9.2.8, 9.2.9, and 10.0 versions.
SPO-20957

In Oracle database 12C, OLTP compressed data/table encountered an out-of-sync issue.
In Oracle database 19C , OLTP compressed data encountered NULL columns.

Oracle has introduced a new patch (32522300) that resolves the above OLTP compression related issues in Oracle 12c and 19c databases.

SPO-20440/ SPO-19931 SharePlex supports the data replication from Oracle to Kafka using the SASL plaintext authentication parameters. For more information, refer to SharePlex 10.1 Administrator Guide.
SPO-18517 SharePlex supports date formatting for all the open targets (such as JMS, file, Kafka) for the XML and JSON record formats.

SharePlex 10.0

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.
SPO-20780 Fixed issue getting stale data capturing remotely where both SP_OCT_OLOG_USE_OCI and database ASYNC mode is enabled. Under this condition, when stale data is detected SharePlex will automatically force a log switch by issuing the ALTER SYSTEM SWITCH LOGFILE command and begin reading from the archive log until it is current. The workaround is automatic and no manual intervention is needed.

SharePlex 9.4

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

SharePlex 9.2.10

Issue ID Description
SPO-21181 Compare/Repair could report a false OOS. This issue is more likely to occur when comparing a single column table without keys.
SPO-21081 SharePlex is unable to compare the tables that are not in the active configuration file using the Compare Force option.
The issue is resolved now. The functionality of comparing data that is outside of the replication was removed from SharePlex 9.0 version onwards. However, now, we have added this functionality back into the product for the 9.2.10, 10.0.1, 10.1 versions.
NOTE: The limitation of comparing tables outside of replicated scheme still applies.
SPO-21076 The memory usage of the SharePlex capture process named "sp_ocap" started increasing after running for a month due to the allocation / de-allocation of the typecheck object.
SPO-21072 SharePlex poster stopped while replicating the data from the source database to the target database due to an invalid length in a column. The issue is observed in the CDC environment.
SPO-21058 SharePlex capture process stops due to an Oracle error whenever the RAC database is restarted. Users need to start the capture manually.
SPO-21054 SharePlex stopped while replicating the Oracle heap organized tables that are altered with the external tables after renaming the table name. The capture was discarding the external table as invalid. This issue was observed intermittently after upgrading from 8.1.6 to 9.2.6.
SPO-21050 SharePlex poster dumped core due to the column data set inappropriately in the key cache. This issue is observed only when the supplemental logging is not set on the source.
SPO-21047 SharePlex capture displayed a full disc space error on a NAS drive immediately after initiating the database replication process, even when there is enough space on the disc.
SPO-21042 Using non-ASCII characters as part of horizontal partitioning column conditions are not accepted via sp_ctrl. SharePlex reader process fails to evaluate such conditions. This issue exists for SharePlex versions 9.x up to 9.2.9.
Reader evaluation issue is now resolved if the below workaround for mentioned sp_ctrl issue is performed.
Workaround: Edit horizontal_partitioning.yaml file to input the non-ASCII characters since sp_ctrl rejects non-ASCII character input.
SPO-20946 SharePlex is unable to display before and after images for the deleted records/rows in the CDC environment even when the sp_opo_track_preimage D parameter for delete is set. This issue is observed after upgrading from SharePlex 9.1.4 to 9.2.8.
SPO-20942 SharePlex poster stopped while performing the cascading replication from source database to target database due to invalid columns and invalid objects in the cache. This issue is observed when bulk updates are being applied such as multiple table creation, peer-to-peer replication, and performing the DDL and DML activity.
SPO-20939 sp_utils does not display the license information for the SharePlex product in the license tab but the customer is able to fetch the license information using splex_get_key. This issue is specific to the windows operating system.
SPO-20931 SharePlex is giving reader core dump in a horizontally partitioned table.
SPO-20929 SharePlex poster dumps core when PEP tries to obtain a row ID for the NOP messages.
SPO-20921 SharePlex capture dumps core and gets memory corruption issue when handling Multi-Block Undo records for 12C or above version of the Oracle database.
SPO-20916 Tables get out of synchronization when a user tries to replicate a horizontally partitioned HP table without a primary key on a dependency check enabled setup. This issue is observed specifically after upgrading from the SharePlex 9.1.4 to 9.2.6 version even after a user performs the full repair.
SPO-20914 SharePlex reader displays an error when a table is dropped without a table name on the source database after updates are accumulated on the capture queue. This issue is observed intermittently while running an internal upgrade application process in the database after upgrading to SharePlex 9.2.7 on a database where PK/UK is not enabled. .
SPO-20911 In the peer-to-peer configuration, SharePlex is unable to replicate the updated information in a row from the source to the target database due to the conflict found in the target database. In the debug process, SharePlex is not able to find the pre-image record to resolve the conflict.
SPO-20780 SharePlex encounters stale blocks in the online log during data replication when the SharePlex was in the remote-connection capture mode.
The issue is resolved. When a stale block is detected a switch command is sent to Oracle to switch the log from online log to archive log and the capture reads the data from the archive log.
SPO-20663 SharePlex declines the transaction, which has only LMN records without any HRID value, with 'NULL HRID' warning message.
This issue is resolved now. SharePlex now declines the transaction without generating the 'NULL HRID' warning message.
SPO-20623 SharePlex capture process dumps core while trying to read an archive log from a perpetually down node on a RAC environment.
SPO-20330 While cross replicating the data from Oracle to the Windows SQL server, the SharePlex poster is performing the delete operation very slow on tables and most of the tables are displayed out of synchronized. Due to this, a heavy backlog is observed for a particular queue.
SPO-20012 SharePlex poster stopped while executing an insert statement on an object in the target database. It stopped due to an invalid length of the variable character string even when the source and target are having the same structure. This issue is observed while processing the corrupt data specifically the special characters.
SPO-19967 SharePlex capture's parser dumps core while decompressing the OLTP compressed DLOAD records. This issue is observed when the data size of the DLOAD record exceeds the size of the standard message.
SPO-19927 SharePlex is getting an issue while accessing a VARDIR installed on a network drive on Windows environment.
SPO-19318 SharePlex capture process stopped with an error when the DB max sessions per node (5 nodes) was set to 4000 each.
Maximum number of concurrent Oracle sessions for DDL and DML are now increased to 5000 per node.
SPO-17695 SharePlex was unable to replicate data from source database to target database when the table data has UDT (User Defined Data Type) and LOB data. This issue was observed on the SharePlex 9.2.1 version.

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
SPO-19872 Fixed performance issue with large partial rollbacks.

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.
Self Service Tools
Knowledge Base
Notifications & Alerts
Product Support
Software Downloads
Technical Documentation
User Forums
Video Tutorials
RSS Feed
Contact Us
Licensing Assistance
Technical Support
View All
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating