"[FMWGEN][SQLServer JDBC Driver][SQLServer]Cannot create trigger '<SCHEMA_NAME>.UT$Class_00I' because its schema is different from the schema of the target table or view" Error Received while Trying to Deploy CDC on MS SQL Server Database Table in ODI (Doc ID 2341125.1)

Last updated on JUNE 16, 2022

Applies to:

Symptoms

Using Oracle Data Integrator (ODI) and attempting to deploy Changed Data Capture (CDC) on a MS SQL Server database table using the Microsoft SQL Server Datadirect Driver results in the following error:

ODI-1590: The execution of the script failed.
Caused By: org.apache.bsf.BSFException: exception from Jython:
Traceback (most recent call last):
  File "", line 266, in
  File "", line 225, in __init__
  File "", line 257, in _JMMMsSql__ExecSql
  at weblogic.jdbc.sqlserverbase.ddcw.b(Unknown Source)
  at weblogic.jdbc.sqlserverbase.ddcw.a(Unknown Source)
  at weblogic.jdbc.sqlserverbase.ddcv.b(Unknown Source)
  at weblogic.jdbc.sqlserverbase.ddcv.a(Unknown Source)
  at weblogic.jdbc.sqlserver.tds.ddr.v(Unknown Source)
  at weblogic.jdbc.sqlserver.tds.ddr.a(Unknown Source)
  at weblogic.jdbc.sqlserver.tds.ddr.a(Unknown Source)
  at weblogic.jdbc.sqlserver.dda3.m(Unknown Source)
  at weblogic.jdbc.sqlserverbase.dde7.e(Unknown Source)
  at weblogic.jdbc.sqlserverbase.dde7.a(Unknown Source)
  at weblogic.jdbc.sqlserverbase.dde7.v(Unknown Source)
  at weblogic.jdbc.sqlserverbase.dde7.r(Unknown Source)
  at weblogic.jdbc.sqlserverbase.dde7.execute(Unknown Source)
  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  at java.lang.reflect.Method.invoke(Method.java:606)

java.sql.SQLException: java.sql.SQLException: [FMWGEN][SQLServer JDBC Driver][SQLServer]Cannot create trigger '<SCHEMA_NAME>.UT$Class_00I' because its schema is different from the schema of the target table or view.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.