My Oracle Support Banner

E1 : DB: GRID: OMW: SQL Blocking When Working with User Defined Objects (UDOs) (Ex. Saving a Grid Format) or When Working in OMW on Fat Client (OMW Hangs) (SQL Server DB Only) (Doc ID 2397503.1)

Last updated on NOVEMBER 16, 2023

Applies to:

JD Edwards EnterpriseOne Tools - Version 9.2 and later
Information in this document applies to any platform.
Specific to Microsoft SQL Server Database 2008 or higher


Scenario 1: Some users cannot save a Grid Format after upgrade to 9.2

In any path code, if the user attempts to save or delete a UDO (example a Grid Format), there is a Call Stack in the Call Object Kernel (COK) log and SQL blocking on the F98222 table is experienced in the SQL Server database.

The following statements can be seen in the COK jde.log:

Scenario 2: When working in OMW (P98220) on the fat client, OMW hangs. SQL Blocking is seen on SQL Server Database

When user is working in OMW on the fat client and tries to add, copy or delete an object, OMW hangs and CPU goes up. SQL Blocking is seen in the 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.