APAR status
Closed as program error.
Error description
When using the ChangeDataCapture Node (CDC Node) with a non-container database (non-CDB) the following error may be observed: 2024-05-17 20:33:29.680512: BIP10204E: The Debezium engine has thrown an exception 'org.apache.kafka.connect.errors.ConnectException: An exception occurred in the change event producer. This connector will be stopped. Caused by java.lang.RuntimeException: java.lang.RuntimeException: java.sql.SQLException: ORA-65090: operation only allowed in a container database Caused by java.lang.RuntimeException: java.sql.SQLException: ORA-65090: operation only allowed in a container database Caused by java.sql.SQLException: ORA-65090: operation only allowed in a container database Caused by Error : 65090, Position : 27, Sql = alter session set container=, OriginalSql = alter session set container=, Error Msg = ORA-65090: operation only allowed in a container database'.
Local fix
Problem summary
**************************************************************** USERS AFFECTED: All users of App Connect Enterprise V12 using the Change Data Capture node with an Oracle database using a non-CDB (an Oracle Partitioned Database) database. Platforms affected: AIX, Linux on x86-64 platform, Linux on zSeries platform, Linux on Power platform, Windows on x86-64 platform **************************************************************** PROBLEM DESCRIPTION: When using the ChangeDataCapture Node (CDC Node) with a non-container database (non-CDB) the following error may be observed: ORA-65090: Operation only allowed in a container database
Problem conclusion
App Connect Enterprise has been changed to correctly initialise its connection to Oracle to handle non-CDB connections when the policy setting for the PDB name is blank. --------------------------------------------------------------- The fix is targeted for delivery in the following PTFs: Version Maintenance Level v12.0 12.0.12.4 The latest available maintenance can be obtained from: http://www-01.ibm.com/support/docview.wss?rs=849&uid=swg27006041 If the maintenance level is not yet available,information on its planned availability can be found on: http://www-1.ibm.com/support/docview.wss?rs=849&uid=swg27006308 ---------------------------------------------------------------
Temporary fix
Comments
APAR Information
APAR number
IT46200
Reported component name
APP CONNECT ENT
Reported component ID
5724J0560
Reported release
C00
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2024-05-21
Closed date
2024-06-14
Last modified date
2024-06-14
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
APP CONNECT ENT
Fixed component ID
5724J0560
Applicable component levels
[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSDR5J","label":"IBM App Connect Enterprise"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"C00","Line of Business":{"code":"LOB67","label":"IT Automation \u0026 App Modernization"}}]
Document Information
Modified date:
14 June 2024