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.
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21586721