IBM Support

IBM Infosphere CDC : %USERFUNC issue when running same stored procedure name in multile subscripitons

Troubleshooting


Problem

Receiving error : IBM InfoSphere Change Data Capture encountered an error when the UserExit method was invoked. A SQL exception has occurred. The SQL error code is '0'. The SQL state is: HY000. The error message is: [CDC][Oracle JDBC Driver]Object has been closed.

Symptom

Receiving error :
IBM InfoSphere Change Data Capture encountered an error when the
UserExit method was invoked.
A SQL exception has occurred. The SQL error code is '0'. The SQL state
is: HY000. The error message is:
[CDC][Oracle JDBC Driver]Object has been closed.

Cause

Using same stored procedure name in multiple subscriptions

Resolving The Problem

The error is caused because CDC is executing derived columns with %USERFUNC
referring to the same stored procedure on different subscriptions.

The workaround that is suggested is to copy the Stored Procedure into
a different name for each subscription and then implement it in the
subscription.

[{"Product":{"code":"SSX3HK","label":"InfoSphere Change Data Capture"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"6.5.1;6.5","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 June 2018

UID

swg21586721

Page Feedback