E1: 43: SQL Alerts Reporting Database Blocking Issues During PO Receipts (P4312) Processing (Doc ID 2551786.1)

Last updated on NOVEMBER 30, 2021

Applies to:

Symptoms

Purchase Order Receipts (P4312)

On May 7, 2019 at 8:48 while running PO Receipts (P4312) there were SQL Alerts sent reporting Database Blocking issues:
  - One SQL Update to the Location Capacity (F46L30) table is blocking another SQL Update statement to the same table.
  - One SQL Update to the Batch Header (F0011) table was blocking a SQL Delete from the Item Location Workfile (F41021WF)

This does not occur often (2-3 times per month) but when it does occur the system performance is degraded to the point where the system has to be shutdown and restarted.

The issue cannot be reproduced and the people reporting the issue are not familiar with the steps leading up to the failure, they are simply reacting to the SQL Alert log messages.

The issue occurs in the production (live) environment.

The client does not expect any SQL alerts reporting blocking issues when performing Purchase Order Receipts (P4312)
 
JDE.LOG messages include:
JDB9900401 - Failed to execute db request
JDB3500011 - Failed to delete for F0011
ODB0000027 - JDBODBC_DescribeTable failed. Table F41021TW
JDB9900168 - Failed to initialize db request
JDB3500011 - Failed to delete for F41021TW
JDB9900255 - Database connection to F4301 (Business Data - PROD) has been lost.
JDB9901232 - Canceling transaction because: TC045 DeleteTable: Delete failed
JDB9900256 - Database connection to (Business Data - PROD) has been re-established.

Cause

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