My Oracle Support Banner

"[FMWGEN][SQLServer JDBC Driver][SQLServer]Cannot create trigger 'ODI_STAGING.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 JANUARY 17, 2018

Applies to:

Oracle Data Integrator - Version 12.1.2.0.0 to 12.1.3.0.0 [Release 12c]
Information in this document applies to any platform.

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 'ODI_STAGING.UT$Class_00I' because its schema is different from the schema of the target table or view.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


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