Perform the following task after Data Ingestion and Replication is upgraded to the July 2024 release.
Upgrade consideration for Google BigQuery using third-party jars
After the July 2024 upgrade, application ingestion and replication jobs and database ingestion and replication jobs might fail if you previously copied the Google BigQuery jar files, including jackson-databind-2.x.x.jar, jackson-core-2.x.x.jar, and jackson-annotations-2.x.x.jar, to the following location:
<INFA_HOME>/apps/Database_Ingestion/ext/
The jobs fail with the following error because the versions of the earlier jackson-databind-2.x.x.jar, jackson-core-2.x.x.jar, and jackson-annotations-2.x.x.jar files differ from the current 2.17.1 version of the .jar files that Application Ingestion and Replication and Database Ingestion and Replication use:
[DBMIP_20009] The process [CDC_COMBINED-SSLRCDCReader-CDC_COMBINED PWX Reader(63)-main] encountered an unexpected error. Error: [PWX session start failed with StartSession({host=localhost,port=44991,sl=true,sslTrustStore=}) failed. Caused by: Failed to open a socket. Error:Connection refused (Connection refused)].]
You must delete the older jackson-databind-2.x.x.jar, jackson-core-2.x.x.jar, and jackson-annotations-2.x.x.jar files and replace them with the current jackson-databind-2.17.1.jar, jackson-core-2.17.1.jar, and jackson-annotations-2.17.1.jar files from the following location:
Then restart the Secure Agent and resume your jobs.
Upgrade consideration for database ingestion and replication jobs that have Db2 for LUW sources
If a database ingestion and replication job that has a Db2 for LUW source tables with LOB columns was running during the upgrade to the July 2024 release and a Drop Column operation occurred on a source table, perform the following steps to ensure that the source and target definitions are still consistent in structure:
1Stop the job.
2Edit the associated task to select the Include LOBs option for the source.