The following is a list of issues addressed and enhancements implemented in this release of SharePlex.
| 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. |
| 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. |
