My Oracle Support Banner

ODI Customized Reverse Engineering Hangs and Freezes ODI Designer When ODI Repositories Are Stored On Microsoft SQLServer (Doc ID 790999.1)

Last updated on JUNE 16, 2022

Applies to:

Oracle Data Integrator - Version and later
Information in this document applies to any platform.


In ODI Designer, customized Reverse Engineering ( for example using RKM Hyperion Planning to reverse Hyperion Planning Models, RKM File (from Excel)...) usually runs successfully.

However, sometimes the reverse Session starts and hangs or errors at the last step Set Metadata step. If it hangs, this in turn freezes ODI Designer, and you are obliged to kill ODI Designer from  the Windows Task Manager.

Note this issue is only observed with ODI Repositories created on Microsoft SQL Server Database.


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.