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

Technote (troubleshooting)


Problem(Abstract)

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.


Rate this page:

(0 users)Average rating

Document information


More support for:

InfoSphere Change Data Capture

Software version:

6.5, 6.5.1

Operating system(s):

AIX, HP-UX, Linux, Solaris, Windows

Reference #:

1586721

Modified date:

2012-08-12

Translate my page

Machine Translation

Content navigation