My Oracle Support Banner

ODI 11g Studio Hangs On Opening a Duplicated Interface When Repositories Hosted In a Microsoft SQL Server Database (Doc ID 1936643.1)

Last updated on JUNE 16, 2022

Applies to:

Oracle Data Integrator - Version to [Release 11gR1]
Information in this document applies to any platform.


When an ODI User, assigned the NG Designer Profile, duplicates an Integration Interface and in the same session tries to open the duplicated interface, ODI Studio hangs indefinitely on Editor Creation....

At this point, when executing following SQL statement in SQL Server Management Studio, the query also hangs:

The only way to resolve this situation is to kill the ODI Studio process (for example, using Windows Task Manager).

Having killed ODI Studio the above SQL instruction returns successfully.

When logging in once again using the NG Designer User account, the User can now open the duplicated interface.




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

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