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 JUNE 16, 2022
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