Bug 37393918 - Oracle GoldenGate for Distributed Applications and Analytics instance is replicating to Azure, leading to multiple timeouts per hour in the replicats

This issue has been fixed.

Bug 37214005 - GGS: NoSuchMethodError: 'void com.azure.core.credential.AccessToken' after upgrading to 21.15.0.0.4

This issue has been fixed.

Bug 37248010 - DB2 z/OS to Kafka: delete-insert || operation type header always "U"

This issue has been fixed.

Bug 37097430 - Delivery to Ctree via JDBC - Database error: Table/View/Synonym not found.

This issue has been fixed.

Bug 37191175 - SYNAPSE replicat fails with merge: Exception: com.microsoft.sqlserver.jdbc.SQLServerException: Parse error at line: 7, column: 81: Incorrect syntax near '[ORDER_DATE]'

This issue has been fixed,

Bug 37598899 - Upgrade netty to 4.1.118

Bug 37483946 - Anchor finding in oggbigdata-v21-slim .

This security vulnerability has been fixed. Oracle recommends that you upgrade to this patch to include this security fix.

Bug 36958458 - 3rd party dependency: Upgrade Jackson to 2.17.2

This security issue was fixed. Oracle recommends that you upgrade to this patch to include this security fix.

Bug 36873931 - Upgrade Azure Identity

Bug 37203419 - Upgrade Avro version .

Bug 37296009 - Upgrade GGS dependencies

Bug 37289702 - Upgrade GGS hadoop dependencies

Bug 37149408 - Upgrade GGS dependencies

Bug 35715223 - Stage Merge: Ensure no collisions in internal columns (optype, position) used in staging table.

This issue has been fixed.

Bug 37214005 - GGS: NoSuchMethodError: 'void com.azure.core.credential.AccessToken' after upgrading to 21.15.0.0.4

This issue has been fixed.

Bug 37127061 - Syntax error: Missing whitespace between literal and alias

This issue has been fixed.

Bug 37126958 - GGS: Replicat to JSON ADB abends with OGG-15051

This issue has been fixed.

Bug 37076184 - Error loading Zstd native binary in GGS

This issue has been fixed.

Enh 36709925 - Support for retaining the column types of source tables in the target tables.

The column type of the source table is now getting retained in the target table. For more information, see Metacolumn Keywords in the Oracle GoldeGate for Distributed Applications and Analytics Documentation.

Bug 36873413 - Replicat throws the following error: java.lang.NoClassDefFoundError: javax/xml/bind/DatatypeConverter

This issue has been fixed.

Bug 36859827 - Snowflake | Enable FIPS compliant JDBC Driver

This issue has been fixed.

Bug 36836497 - Changes to S3 Event Handler to support different credential scenarios

This issue has been fixed.

Bug 36836411 - Upgrade Jipher to latest version

This issue has been fixed.

Bug 36832778 - Redshift - Enable case sensitive object names

This issue has been fixed.

Bug 36821361 - Security issue found in Parquet dependency.

This bug has been fixed.

Bug 36732531 - RestartAbend event handling is not handled properly.

This bug has been fixed.

Bug 36731720 - OCI Event Handler - Does not work with 3.x versions of the OCI client

This issue has been fixed.

Bug 36716265 - Redis Handler - Fix setting of socket timeout

This issue has been fixed.

Bug 36619828 - UserExitDataSource::hasMissingColumns is not set in the operation record for some cases

This issue has been fixed.

Bug 36607305 - Changes to AWS versions for risk mitigation.

Bug 36603708 - Changes to Hadoop version.

Bug 36573783 - Stage/Merge | Additional check for pk update batching

This issue has been fixed.

Bug 36563658 - Unable to download Goldengate Bigdata Dependency Libraries, Maven is not accessible.

This issue has been fixed.

Bug 36525134 - Filter part of message string while delivering to Kafka

This issue has been fixed.

Bug 36504292 - Kafka Extract is missing to capture the messages from the Kafka Topics

This issue has been fixed.

Bug 36496342 - Oracle GoldenGate for Big Data Numeric Overflow to BigQuery

This issue has been fixed.

Bug 36466018 - JMS Rep: JMS-00191 JMS Headers are not supported in transactional mode

This issue has been fixed.

Bug 36460624 - Rows missing after initial load replicate completes processing

This issue has been fixed.

- MongoDB Capture - Fix ClassCastException: org.bson.BsonString cannot be cast to org.bson.Bson

This issue has been fixed.

Bug 36442602 - BigQuery MDP error when dataset and the BigQuery reside in different GCP projects

This issue has been fixed.

Bug 36429973 - DELETE is not replicated in bi-directional

This issue has been fixed.

Bug 36420985 - Not able to generate Partition Key at the Message header while delivering message to Solace using JMS

This issue has been fixed.

Bug 36379293 - CVEs in 21.13.0.0.0_240301.0927_feature-GGS-11916_Uptake_BigData_2

This issue has been fixed.

Enh 36307168 - If the Avro formatter property enableTimestampLogicalType is set to true, then it is required that gg.format.timestamp also be configured to a timestamp mask such as yyyy-MM-dd HH:mm:ss.SSS in order for the feature to work.

The behavior has been changed to abend if enableTimestampLogicalType is set to true on the Avro formatter and gg.format.timestamp is unset.

Bug 36422079 - Added parameter to control the processing of backlog staged files by the File Writer Handler: gg.handler.name.processBacklogOnShutdown

For more information, see Configuring the File Writer Handler in the Oracle GoldenGate for Big Data Documentation.

Enh 36242318 - Support for Datastax DSE Capture with version 6.8.31

Enh 36253307 - BigQuery Streaming Handler - Add support for JSON types

The BigQuery Streaming Handler has been modified to support the BigQuery column type JSON. Source data must be a valid JSON else a runtime exception will result. For more information, see Google BigQuery Datatypes in the Oracle GoldenGate for Big Data Documentation.

Enh 36206718 - BigQuery MDP - Google API Support for private endpoint access

Support has been added to allow the user to configure the URL for connecting to Google BigQuery. The default is https://googleapis.com. For more information, see Google BigQuery Metadata Provider Documentation.

Enh 36196617 - BigQuery Stage & Merge - Google API Support for private endpoint access

Support has been added to allow the user to configure the URL for connecting to Google BigQuery. The default is https://googleapis.com. For more information, see Google BigQuery Stage and Merge Event Handler Configuration in the Oracle GoldenGate for Big Data Documentation.

Enh 36196570 - GCS Event Handler - Google API Support for private endpoint access

Support has been added to allow the user to configure a URL for a private endpoint to connect to Google Cloud Storage. The default is https://storage.googleapis.com. For more information, see Google Cloud Storage - Configuration in the Oracle GoldenGate for Big Data Documentation.

Enh 36100355 - BigQuery Streaming Handler - Google API Support for private endpoint access

Support has been added to allow the user to configure the URL for connecting to Google BigQuery. The default is https://googleapis.com. For more information, see Understanding the BigQuery Handler Configuration in the Oracle GoldenGate for Big Data Documentation.

Bug 36124720 - Change behavior to call system.exit if the Stage & Merge event handlers are identified in a hung state.

This issue has been fixed.

Bug 36220438 - Mongo Bi Cap: Mongo replicat is abending with Updating the path 'oggApply' would create a conflict at 'oggApply' error

This issue has been fixed.

Bug 36194483 - Log the Oracle Doc ID number when encountering the exception: Unable to deserialize table metadata so user has the reference explaining how to fix.

This issue has been fixed.

Bug 36166314 - Mongo Bi Cap: Extract timeouts upon issuing STOP command

This issue has been fixed.

Bug 36193831 - Mongo 6x: java.lang.IllegalArgumentException: Field names in a replacement document can not start with '$' but '$unset' does

This issue has been fixed.

Bug 36185493 - OGGBD | Address CVEs from OSCS scan on OGGADP_21.13.0.0.0_20240111190312

This issue has been fixed.

Bug 36183618 - Upgrade GCS and BigQuery Versions to latest

This issue has been fixed.

Bug 36179230 - CVE-2023-35116 in jackson-databind

This issue has been fixed.

Bug 36179042 - CVE-2023-42503 in commons-compress

This issue has been fixed.

Bug 36167143 - Mongo Bi Cap: org.bson.BsonInvalidOperationException: Value expected to be of type BOOLEAN is of unexpected type STRING

This issue has been fixed.

Bug 36395858 - REPLACEBADNUM fix in Oracle GoldenGate for Big Data.

This issue has been fixed.

Bug 36395887 - Positioning to RBA other than 0 leading to ignoring the metadata provider.

This issue has been fixed.

Bug 36375145 - CVEs in 21.13.0.0.0_240301.0927_feature-GGS-11916_Uptake_BigData_2

This security vulnerability has been fixed. Oracle recommends that you upgrade to this patch to include this security fix.

Bug 36124956 - MongoDB Bi-Directional Replication -- Extract and Replicat Java side changes

This issue has been fixed.

Bug 36206718 - BigQuery MDP - Google API Support for private endpoint access

This issue has been fixed.

Bug 36196617 - BigQuery Stage & Merge - Google API Support for private endpoint access

This issue has been fixed.

Bug 36196570 - GCS Event Handler - Google API Support for private endpoint access

This issue has been fixed.

Bug 36100355 - BigQuery Handler - Google API Support for private endpoint access

This issue has been fixed.

Bug 36010156 - Additional property for NoSQL GGS default properties

This issue has been fixed.

Bug 36048423 - Oracle NoSQL JSON Type

This issue has been fixed.

Bug 36022907 - snappy*.so files filling up /tmp in OCI GoldenGate Big Data Deployment

This issue has been fixed.

Bug 36083206 - GoldenGate Replicat for Bigdata Classic on Redshift database ABEND Randomly

This issue has been fixed.

The following security vulnerabilities have been fixed:

Bug 36083631 - Stage and merge | Optimize MERGE CASE statement for full images

This issue has been fixed.

Bug 36063054 - Not able to login adminclient using USER Role in microservices

This issue has been fixed.

Bug 36060019 - Snowflake Performance improvement | Internal storage Merge Query

This issue has been fixed.

Bug 36060017 - Snowflake | Remove override parameter to run operation aggregation with SQL without full images

This issue has been fixed.

Bug 36050573 - Fixes for CVEs from OSCS scan on OGGADP_21.12.0.0.0BP_PLATFORMS_231117.1408

This issue has been fixed.

Bug 36037945 - Upgrade Avro dependency in Hadoop

This issue has been fixed.

Bug 36029828 - Fix vulnerabilities identified in GGS Bigdata Docker images due December 2023

This issue has been fixed.

Bug 36022907 - snappy*.so files filling up /tmp in OCI GoldenGate Bigdata Deployment

This issue has been fixed.

Bug 35961696 - Fix vulnerabilities identified in GGS Bigdata | GGS-10588 | Due November 2023

This issue has been fixed.

Bug 35757262 - Log an actionable error message on Event handler timeout

This issue has been fixed.

Bug 35752685 - Event handler timeout should be configurable

This issue has been fixed.

Bug 35728712 - REP: DT: Wrong date format replicating from DB2

This issue has been fixed.

Bug 35552414 - MONGO REP: org.bson.codecs.configuration.CodecConfigurationException: The uuidRepresentation has not been specified, so the UUID cannot be encoded

This issue has been fixed.

Bug 35871344 - REG:MONGO REP: java.lang.IllegalArgumentException: The connection string contains options without trailing slash

This issue has been fixed.

Bug 35805937 - Pick better MongoDB error codes for not-found and duplicate errors

This issue has been fixed.

Bug 35805441 - Handle upsert mode behavior where it does not report rows affected

This issue has been fixed.

Bug 35900576 - Change Event Handler configuration back to strict

This issue has been fixed.

Bug 35606570 - MicroServices Snowflake - unable to restart replicat | java.io.InvalidClassException: oracle.goldengate.datasource.meta.TableMetaData; local class incompatible

This issue has been fixed.

Bug 35746970 - Redis ERROR 2023-08-25 20:06:37.000168 [main] - An exception occurred creating index [idx:TCUSTMER] description [Hash index [idx:TCUSTMER] using prefix [TCUSTMER:] with the following fields: Field [CUST_CODE] Type [TEXT] Sortable

This issue has been fixed.

Bug 35702310 - Update operation is performed as DELETE at snowflake target Oracle GoldenGate for Big Data 21.10

This issue has been fixed.

Bug 35409483 - Snowflake Replicat restart/recovery when INSERTALLRECORDS is enabled results in Duplicate row error

This issue has been fixed.

Bug 34948936 - Memory leak in Oracle GoldenGate for Big Data Replicat processes

This issue has been fixed.

Bug 35294514 - Mongo: REG: java.nio.charset.MalformedInputException: Input length = 1

This issue has been fixed.

Bug 35608372 - Snowflake initial load failure with additional unmapped target columns

This issue has been fixed.

Bug 35688039 - SNOWFLAKE and BIGQUERY template changes

This issue has been fixed.

Bug 35692758 - Revert changes related to masking the password fields for JMS and Kafka in credentials page.

This issue has been fixed.

Enh 35132820 - Big Data Replicat Abended With java.net.SocketTimeoutException: connect timed out

This issue has been fixed. The Oracle GoldenGate replication to Kinesis is now working.

Enh 35276440 - Snowflake | Stage and Merge | SQL optimisation | Remove CAST function on key columns that are not nullable

This is a performance fix for the Snowflake MERGE statement. The ON-clause used in the MERGE statement will not use CAST functions in case the key columns are nullable.

Enh 35288885 - The functionality of the File Writer Handler has been changed to roll over any open data files upon restart of the replicat process and not to append to them.

If files are appended, then it can result in duplicate operations in the same data file if operations are replayed which does not work with stage and merge integrations.

Enh 35275115 - Monitoring functionality has been added on the event handler functionality.

If the event handler hangs, then the monitor thread with interrupt the event handler thread after a timeout period and the replicat process will abend.

Enh 35269457 - A configuration property has been added to enable info level logging of successfully executed event handles for troubleshooting purposes.

The gg.handler.name.logEventHandlerStatus has been added to enable info level logging of successfully executed event handles for troubleshooting purposes.

Enh 35308593 - Operation Aggregator | Improve diagnostic messages for inline LOB processing

Improve error messages related to LOB processing. For more information, see Snowflake Event Handler Troubleshooting and Diagnostics in Oracle GoldenGate for Big Data articles.

Enh 35286599 - Operation Aggregator | Validate Primary Key UpdatesParameter: gg.operation.aggregator.validate.keyupdate. The default value is set to false.

A parameter to validate a primary key update record. In case the record does not modify key column values, the primary key update record is converted to a non-primary key update record. This check and conversion is done during Operation Aggregation, used by all the stage and merge targets. Th primary key update operations cannot be batched during stage and merge replication. Enabling this parameter will improve performance of the Replicat process. For more information, see Snowflake Event Handler Configuration - Configuration Table in Oracle GoldenGate for Big Data articles.

Bug 35136302 - The Google Cloud Storage event handler can hang when loading files to GCS.

This issue has been fixed.

Bug 35192087 - The block to wait for a task manager task to complete could result in a hang.

This issue has been fixed.

Bug 35207499 - ABEND handlers/Event handlers if the Java system property GROUPNAME is unset

This issue has been fixed.

Bug 35142393 - Snowflake | Stage and Merge | Abend if Replicat name is not set.

Oracle GoldenGate for Big Data Replicat will ABEND if the GROUPNAME Java system property is not set.

Bug35157005 - REPLICAT to Snowflake Handler - net.snowflake.client.jdbc.SnowflakeSQLException: Error parsing JSON

This issue has been fixed. Use conversion function TO_VARIANT() during processing of primary key update operations if the target Snowflake column is a VARIANT type.

Bug 35310840 - Replicat should shutdown immediately when there are exceptions in the EventHandler execute call

The issue has been fixed.

Bug 35282535 - Operation Aggregator | Flushed operations are not ordered as per operation position

The issue has been fixed.

Bug 35242541 - Snowflake | Changes to prevent Security issue SNOW-770796 in the JDBC driver

The issue has been fixed.

Bug 35266699 - Stage and Merge | Target controlled checkpoint (.cpj) update was incorrect

The issue has been fixed.

Bug 35425203 - Problem with data file naming not unique when coordinated apply is used with Redshift stage and merge.

This issue has been fixed.

Bug 35089651 - Allow users to encrypt credentials inside of the Kafka producer properties file using Oracle Wallet.

This bug has been

Bug 35181750 - Kafka Capture Error on restart

This issue has been fixed.

Bug 35065416 - Oracle Goldengate for Bigdata to Synapse is missing some updates and therefore impacting many tables

This issue has been fixed.

Bug 35187763: Oracle GoldenGate for Big Data snowflake key pair replicat log file is displaying password

Enh 33235178 - Support XAG Integration

Support has been added for enabling XAG for Non-Oracle databases with Microservices builds.

Bug 34798902 - File Writer Handler may generate duplicate data file names when file rolling on primary key updates is enabled.

This issue has been fixed.

Enh 34816133 - The Avro formatter has been modified to allow the user to configure maximum precision for decimal logical types.

For more information, see gg.handler.format.name.maxPrecision in Avro Row Configuration Properties in Oracle GoldenGate for Big Data.

Enh 34974951 - The template mapper functionality has been enhanced.

The keyword ${uuid} was added to resolve a universally unique identifier. This is useful when naming uniqueness is absolutely required. For more information, see Template Keywords in Oracle GoldenGate for Big Data.

Enh 34855804 - OGGBD | Synapse | Enable MERGE statement as the default setting.

The enhancement has been implemented.

Bug 35107919 - The file handle to the state file is not closed immediately after the corresponding data file is rolled. The result could be file handle exhaustion in the case where data file generation is occurring much more quickly than the event handers can process the data files.

This issue has been fixed.

Bug 35078942 - Replicat startup fails because of inconsistent state in the File Writer Handler. This is generally caused by force stop or killing the replicat process.

This scenario has been downgraded to a warning.

Enh 34964443 - BigQuery Stage and Merge: Replication to Datasets in multiple Google Cloud Platform (GCP) projects

BigQuery Stage and Merge handler now supports replication to datasets that reside in multiple GCP projects. The table catalog name can be mapped to the GCP projectId.

MongoDB driver upgraded to version 4.6.0

The MongoDB driver version was upgraded to 4.6.0 from 3.x. For more information, see MongoDB Handler Dependencies the Oracle GoldenGate for Big Data Documentation.

Enh 34765203 - The metacolumn functionality has been enhanced.

The keyword ${groupname} was added to resolve the replicat group name and inject it into output. See Metacolumn Keywords in the Oracle GoldenGate for Big Data User Guide.

Bug 34572611 - The BigQuery Handler was incorrectly creating Date typed columns in the source trail as columns typed as Timestamp in BigQuery. This was causing problems when the data was loaded.

This issue has been fixed to create Date source types as columns typed as Date in BigQuery.

Bug 34703823 - The BigQuery Handler was incorrectly creating Time typed columns in the source trail as columns typed as Timestamp in BigQuery. The result was an exception when data was loaded.

This issue has been fixed to create Time source types as columns typed as Time in BigQuery.

Enh 34061024 - Snowflake: Stage and Merge: Initial load throughput improvement using COPY SQL

Snowflake Initial load uses the COPY SQL statement to insert records into the target table. This improves the initial load throughput.

Enh 34472509 - BigQuery Stage and Merge INSERTALLRECORDS support

The INSERTALLRECORDS Oracle GoldenGate parameter is now supported for BigQuery target.

Enh 34097475 - OGGBD: Support multiple sources in a single deployment

Oracle GoldenGate for BigData now supports capture from multiple sources (JMS/Cassandra/MongoDB/Kafka) in a single deployment without the need to restart microservices or configuration of the GLOBALS file.

Bug 34665273 - Snowflake internal stage | Primary key update | 'FileNotFoundException'Fix for primary key update operation when using Snowflake internal stage.

This issue has been fixed to provide a correction for primary key update operation when using Snowflake internal stage.

Bug 34609774 - Restarting JMS extract after processing records leads to ABEND.

This issue has been fixed.

Bug 34265778: Upgrade Maven version to 3.8.5

The packaged version of Maven for the dependency downloader utility has been upgraded to version 3.8.5 to resolve CVE-2021-37714.

Bug 34014027: File Writer Handler may generate the following error if pluggable operation filtering is enabled: GGBD- java.lang.IllegalArgumentException: Cannot set target checkpoint to null or GGTranID.UNSET

This issue has been fixed.

Bug 33964720 - Oracle to Snowflake Golden gate slow replication - data overflow error for data type number(23).

This issue has been fixed by providing a JDBC Metadata Provider fix for BIGINT.

Bug 34366687: Stage and Merge targets - Missing deletes.

This issue has been fixed for a scenario where the same row is deleted and inserted multiple times within a 30 seconds window.

Bug 34332954: Initial load from Oracle to Snowflake using Oracle GoldenGate for Big Data doesn't load complete data.

This issue has been fixed.

Bug 34477194: Case of object name is not preserved when using fully qualified table name.

This issue can be fixed by adding gg.schema.preserveObjectName=true​ in the corresponding properties file.

Bug 34481377: When mapping a target column from a constant value or a return value from column functions, that corresponding target column is not propagated downstream.

This issue has been fixed

Enh 31771160: HBase Handler - Added support for metacolumns

The HBase Handler has added functionality whereby configurable metacolumn data can be propagated.

Enh 29610404: Delimited text formatter has been modified.

The delimited text formatter has been modified to allow file headers to be created. A file header is a delimited row which names each field in the delimited text output.

Enh 2941786: JSON formatter has been modified to allow files created in JSON format to be represented as a JSON array.

The JSON formatter has been modified to allow files created in JSON format to be represented as a JSON array. This allows the generated file to be represented as a single JSON document whereby the JSONs representing the operation data are elements within the JSON array.

Enh 33969301 - Auto-detect "insert-only" load to avoid having to configure the Java module.

Stage and merge targets automatically detect initial load trail files to perform batch insert operation. The automatic detection requires trail files generated by the Oracle GoldenGate 21c extract processes.

Enh 34392764 - OGGBD | Snowflake | Internal Stage | PUT SQL | customisation of compression settings

Snowflake compression settings can be tuned to improve initial load performance.

Enh 33571654 - Batch Insert support for Redshift.

INSERTALLRECORDS support has been added for Redshift target.

Enh 33457599 - ADW support Batch INSERT.

INSERTALLRECORDS support has been added for Autonomous Data warehouse target.

Enh 34191410 - Simplify OCI Object Storage configuration

Auto-configuration can be used to simplify configuration for the OCI Object Storage target.

Enh 34226598 - Use S3-Transfer acceleration while replicating to AWS S3

Amazon S3 Transfer Acceleration can be enabled to transfer files quickly and securely over long distances to an S3 bucket.

Enh 33969301 - INSERTALLRECORDS support

INSERTALLRECORDS support has been added for Synapse and Snowflake targets.

Bug 34028430: Snowflake - Truncate Operation Locks table

This issue has been fixed.

Bug 33980860: Parquet Event handler failing with "Can't get Kerberos realm" when configured to write to local file system.

This issue has been fixed.

Bug 34009442: DDL changes/Table metadata changes lead to issue in Stage and Merge processing

This issue has been fixed.

Bug 33964720: Oracle to Snowflake Golden gate slow replication - data overflow error for data type number (23).

This issue has been fixed.

Bug 33979013: BigQuery: Stage and Merge: Replication Issue with solitary DELETE operation

This issue has been fixed.

Bug 33107284: Azure Synapse handler replicat gives sqlserver.jdbc.SQLServerException: on identity column

This issue has been fixed.

Bug 33817426: Big Query stage and merge replicat gives error on latest Bigquery dep of version 2.x

This issue has been fixed.

Enh 33894309: Snowflake: Support for Snowflake key pair authentication

This issue has been fixed. Support for Snowflake public/private key pair authentication has been added.

Enh 34012817 - Certify OGG 21c for Confluent version 7.0 (Apache Kafka Version 3.0)

Avro version has been upgraded to 1.10.2. This fixes the following runtime error when integrating with the Confluent schema registry in Confluent 6.2 and higher:

java.lang.NoSuchMethodError: org.apache.avro.Schema.toString(Ljava/util/Collection;Z)Ljava/lang/String;

Enh 34023340 - Kafka Connect Handler add support to propagate non-nullable fields.

Support has been added to set all fields as nullable in the generated Kafka Connect handler. For more information, see gg.handler.name.enableNonnullable in Kafka Connect Handler Configuration in the Oracle GoldenGate for Big Data User Guide.

Enh 34071624 - Snowflake - Ingest CLOB-JSON data directly into VARIANT data type instead of VARCHAR

Support has been added to map the JSON and XML source column types in the Oracle GoldenGate trail to Snowflake VARIANT. For more information, see Snowflake Event Handler Mapping Source JSON/XML to Snowflake VARIANT in the Oracle GoldenGate for Big Data User Guide.

Bug 33665694 - In the Microservices configuration, the Redshift integration incorrectly contained additional properties which were not relevant to Redshift.

This issue has been fixed.

Bug 33546820 - In certain scenarios, configured Event Handlers can fail on initialization but processing continues.

This issue has been fixed.

Enh 3322101 - BigQuery Handler added support for the BigQuery Bignumeric data type.

The BigQuery Handler has added support for the BigQuery Bignumeric data type. The BigQuery Bignumeric data type provides support for larger scale and precision than the BigQuery Numeric data type.

Bug 33734218 - BigQuery Handler can propagate Oracle Number types as exponential notation when mapped to String fields in BigQuery.

This issue has been fixed.

Upgrade to log4j 2.17 to address Security Vulnerability

The following security vulnerabilities have been fixed: CVE-2021-45105.

Oracle recommends that you upgrade to this patch to include this security fix.

Bug 33364860 - Admin Client Cannot connect to OCI GoldenGate when Administration Server Health API Returns Unhealthy

This issue has been fixed.

Bug 33531900 - 429 - Too Many Requests - Any process marked as critical to health makes the entire Oracle GoldenGate UI hang

This issue has been fixed.

Upgrade to log4j 2.16 to address Security Vulnerability

The following security vulnerabilities have been fixed: CVE-2021-45046 and CVE-2021-44228.

Oracle recommends that you upgrade to this patch to include these security fixes.

Enh 33271830 - BigQuery Handler - Need to support encryption of user credentials

BigQuery Handler has been modified to allow setting of the credentials through the handler configuration properties. This allows Oracle Wallet to be used to secure the credentials.

Enh 33309496 - Avro Formatter added configuration to allow special handling of Oracle Number source types as strings.

This issue has been fixed.

Bug 33314537 - File Writer Handler failing to delete data files on Windows due to process based file locking.

This issue has been fixed. File Writer Handler now implements retries on file delete operations.

Bug 33298943 - Azure Data Lake File exists error

This issue has been fixed. Parquet Event Handler change to overwrite target files if file already exists.

Enh 32797018 - JDBC Handler functionality changed to explicitly rollback any in process transaction before closing the JDBC connection.

Enh 32887009 - Dependency Downloader - Maven version was upgraded to 3.8.1.

Bug 32816606 - BigQuery Handler - Error occurs when new primary key column is added in source database

This issue has been fixed. Columns added to an existing BigQuery table must be nullable, otherwise the BigQuery DDL fails.

Enh 32804778 - Added metacolumn keyword to provide indication that the metadata for associated table has changed.

This issue has been fixed. The metacolumn ${metadatachanged} has been added. This metacolumn has a boolean value and when true, it indicates that the metadata of the table has changed as of the current record.

Enh 32615479 - Kafka Connect Handler - Support added for Confluent Protobuf Converter.

This issue has been fixed. The Confluent Protobuf Converter does not support standalone primitive types. The Kafka Connect Handler generates the key as a string thereby causing the key serialization to fail.

Enh 32555807 - Delimited Text Formatter - Escaping automatically disabled when a multi-character field delimiter is configured.

Enh 32551577 - ORC Event Handler - Added support for timestamp logical types.

Added support to map from Avro timestamp logical type to ORC timestamp logical type.

Enh 32441213 - Added parameters to the ${columnValue[][][]} templating functionality to enhance user control.

Second parameter is the resolved value if the column value is null. Third parameter is the resolved value if the column value is missing.

Bug 32431377 - JDBC Handler fails on a NOOP update.

This issue has been fixed.

Enh 32415987 - The template keyword ${staticMap} has added a second parameter for a default value.

If the value is not resolved through the map lookup, then the default value will be used if configured.

Enh 32379356 - Added Stage and Merge support for Microsoft Azure Synapse.

Enh 32343513 - File Writer Handler - Change behavior of control file to write the file name even if finalize action is to delete the file.

Bug 31979798 - JDBC Handler - Fixed integration to Apache Impala

This issue has been fixed

Bug 31620193 - Elasticsearch Handler SSL connectivity fails with unable to authenticate user

This issue has been fixed.

Enh 31940679 - Oracle NoSQL Handler has been changed to use the new NoSQL SDK client.

The new NoSQL SDK client supports connectivity to both on-premise and Oracle Cloud Infrastructure instances of Oracle NoSQL.

Enh 31480798 - Elasticsearch Handler has removed support for Elasticsearch 5.x as it is beyond the EOL.

Enh 31815601 - HDFS Handler - Sync Partitioning Functionality to File Writer Handler

The partitioning functionality of the HDFS Handler has been modified to use the templating strings. You now have much more control over how data is partitioned into HDFS. For more information, see the HDFS Handler - Partitioning in the Using Oracle GoldenGate for Big Data guide.

Bug 31554644 - GoldenGate Big Data Adapter parameter gg.handler.name.omitNullValues=true affects updates

JSON Formatter added new property gg.handler.name.format.omitNullValuesSpecialUpdateHandling for special handling of null values when gg.handler.name.format.omitNullValues is set to true. For more information, see JSON Formatter Configuration Properties in the Using Oracle GoldenGate for Big Data guide.

Bug 31518128 - Kinesis Handler - Enable working with STS

Kinesis Handler added functionality for connectivity to AWS using the Security Token Service. For more information, see Kinesis Streams Handler Configuration in the Using Oracle GoldenGate for Big Data guide.

Bug 31316766 - HDFS Event Handler - Log the HDFS configuration at the debug level

HDFS Event Handler added functionality to log the HDFS configuration at the DEBUG log level.

Enh 30272210 - OCI Event Handler added functionality to explicitly set the encryption key

A new property gg.handler.name.SSEKey now allows you to control the encryption of data files loaded to OCI. For more information, see Configuring the Oracle Cloud Infrastructure Event Handler in Using Oracle GoldenGate for Big Data guide.

Bug 31215115 - OGGBD JDBC Replicat error on gg.mdp.ConnectionUrl property

JDBC metadata provider throws an error when the case of the configuration property gg.mdp.connenctionUrl is not exact. This issue has been fixed.

Enh 31200109 - File Writer Handler - Add support for partitioning

The File Writer Handler and Event Handlers have added functionality for partitioning using templated strings. For more information, see Template Keywords in the Using Oracle GoldenGate for Big Data guide.

Enh 31174502 - Elasticsearch Handler - Remove support for Elasticsearch 5.x

The Elasticsearch Handler has removed connectivity support for Elasticsearch 5.x. Per the Elasticsearch documentation all 5.x versions are beyond the scheduled end of life date.

Enh 30493966 - Elasticsearch Handler - Remove support for Elasticsearch 2.x

The Elasticsearch Handler has removed connectivity support for Elasticsearch 2.x. Per the Elasticsearch documentation all 2.x versions are beyond the scheduled end of life date.

Enh 31113821 - Automatically convert char column to binary when replicat parameter SOURCECHARSET PASSTHRU is set.

Automatically convert char source columns to binary when replicat parameter SOURCECHARSET PASSTHRU is set. This will propagate char values including invalid characters as is. For more information about SOURCECHARSET with PASSTHROUGH option, see SOURCECHARSET in Oracle GoldenGate Reference for Oracle GoldenGate.

Enh 31003774 - Removing Velocity Libraries from OGGDB Installation

The Velocity libraries have been removed from the packaging. Velocity templates are still supported but users must obtain the Velocity libraries and provide pathing via the gg.classpath variable.

Enh 30892015 - Support Autonomous Data Warehouse LONG and RAW LONG data types.

Bug 30847910 - The OCI Event Handler is not correctly abending when it encounters an exception.

OCI Event Handler is not correctly abending on some failures. This issue has been fixed.

Enh 30823462 - File Writer Event handlers - end to end throughput stats

Bug 30652897 - replicat passes incorrect metadata date and timestamp binary length

JDBC metadata provider passes incorrect metadata date and timestamp binary length. This issue is fixed.

Enh 30652870 - Partial LOB support

Functionality changed to abend in the case where a partial LOB is encountered. Partial LOBs are not supported.

Enh 30652854 - Stage and Merge : Support Truncate operation

File Writer Handler add ability to roll before and after a truncate event.

Bug 30606368 - Kafka Adapter logs many OGG-03014 warning messages when the trail file encoding is UTF-16.

False warning of truncated data when source trail is UTF-16 encoded. This issue has been fixed.

Bug 30595252 - Kafka Connect Handler - Deprecate old way of configuring metacolumns

Kafka Connect Handler has deprecated the old way to configure metacolumns with individual properties. Instead use the property gg.handler.name.metacolumnsTemplate going forward.

Bug 30590585 - Avro Formatter - Deprecate old way of configuring metacolumns

Avro Formatter has deprecated the old way to configure metacolumns with individual properties. Instead use the property gg.handler.name.format.metacolumnsTemplate.

Bug 30576238 - JSON Formatter - Remove the old configuration properties to control metacolumns

JSON Formatter has deprecated the old way to configure metacolumns with individual properties. Instead use the property gg.handler.name.format.metacolumnsTemplate.

Bug 30558744 - Delimited Text Formatter - remove the old way of controlling metacolumns

Delimited Text Formatter has deprecated the old way to configure metacolumns with individual properties. Instead use the property gg.handler.name.format.metacolumnsTemplate.

Bug 30526878 - File Writer Handler and Event Handler precise throughput calculation

File Writer Handler logs throughput metrics for the event handlers to the log file.

Bug 30408287 - BigQuery Handler - Change how schemas and tables map into datasets and tables.

Schema name now maps to BigQuery datasets and table name maps to BigQuery table name.

Bug 30403408 - Enhance the template mapping features to allow regex functionality

The keyword ${regex} has been added to the template mapper to execute search and replace functionality.

Bug 30285088 - Kafka REST Handler incorrectly processes multibyte data when locale is not set to UTF-8.

Kafka REST Handler incorrectly handles multibyte characters when locale is not UTF-8. This issue has been fixed.

Enh 30283426 - Enable Oracle Wallet username and password encryption for JMS Handler.

For more information about ORACLEWALLETUSERNAME and ORACLEWALLETPASSWORD, see Configuring Properties to Access the Credential Store in the Using Oracle GoldenGate for Big Data guide.

Enh 29624678 Cassandra Handler - Support Datastax 4.0 and 4.x drivers

Cassandra Handler has been migrated to use version 4.0.0 and higher of the Datastax driver and 2.0.0 and higher of the Datastax Enterprise driver.

Enh 28813106 - Automatically enable metadata provider when JDBC Handler is selected.

Bug 27663118 - Improved error reporting when incorrect formatter configuration when using the Parquet Event Handler.

This issue has been fixed.

Bug 21299953 - Replicat error message on trail compatibility incorrectly refers to Flat File Writer

This issue has been fixed. Replicat error message has been corrected to adjust the trail compatibility setting on the extract process.

Bug 31297753 - Log4j version upgraded to 2.13.3.

Bug 32830352 - Commons IO upgraded from 2.6 to 2.8.

Bug 32423892 - Jackson-databind upgraded from 2.10.2 to 2.12.1