My Oracle Support Banner

計画マネージャ(MRCRLF)とWIP一括ロード(WICMLP)のデッドロック (Doc ID 2712072.1)

Last updated on SEPTEMBER 23, 2020

適用範囲:

Oracle Work in Process - バージョン 12.1.3 以降
この文書の内容はすべてのプラットフォームに適用されます。

現象

現象
計画マネージャ(MRCRLF)とWIP一括ロード(WICMLP)が警告で完了しました。
DB Alert logを確認すると、以下のデッドロック・メッセージが出ています。

エラー
Global Enqueue Services Deadlock detected. More info in file
 /trace-file-path/specific-trace-file-name.trc

SQL Traceファイルから、以下のSQL文にて、デッドロックが発生していました。
------------------------------------------------------------------------------------------
    application name: e:MRP:cp:mrp/MRCRLF, hash value=#########
    action name: MRP/SUPPLY_CHAIN_PLANNER, hash value=#########
  current SQL:
  SELECT JOBS.ROWID, JOBS.WIP_ENTITY_ID, JOBS.ORGANIZATION_ID FROM
WIP_REQUIREMENT_OPERATIONS OPS, WIP_DISCRETE_JOBS JOBS, MRP_RELIEF_INTERFACE
MRP WHERE OPS.WIP_ENTITY_ID (+) = JOBS.WIP_ENTITY_ID AND OPS.ORGANIZATION_ID
(+) = JOBS.ORGANIZATION_ID AND MRP.DISPOSITION_TYPE = :B7 AND MRP.RELIEF_TYPE
= :B6 AND MRP.REQUEST_ID = :B5 AND MRP.PROCESS_STATUS = :B4 AND
MRP.ERROR_MESSAGE IS NULL AND MRP.INVENTORY_ITEM_ID = DECODE(:B3 ,:B2 ,
MRP.INVENTORY_ITEM_ID, :B3 ) AND MRP.ORGANIZATION_ID = DECODE(:B1 ,:B2
,MRP.ORGANIZATION_ID, :B1 ) AND JOBS.PRIMARY_ITEM_ID = MRP.INVENTORY_ITEM_ID
AND JOBS.ORGANIZATION_ID = MRP.ORGANIZATION_ID AND JOBS.WIP_ENTITY_ID =
MRP.DISPOSITION_ID FOR UPDATE OF JOBS.MPS_NET_QUANTITY,
OPS.MPS_REQUIRED_QUANTITY ORDER BY JOBS.ORGANIZATION_ID, JOBS.WIP_ENTITY_ID
DUMP LOCAL BLOCKER: initiate state dump for DEADLOCK


    application name: e:WIP:cp:wip/WICMLP, hash value=#########
    action name: WIP/WIP_BATCH, hash value=#########
  current SQL:
  UPDATE WIP_DISCRETE_JOBS WDJ SET (LAST_UPDATED_BY, LAST_UPDATE_LOGIN,
REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE,
LAST_UPDATE_DATE, FIRM_PLANNED_FLAG, LOT_NUMBER, START_QUANTITY,
NET_QUANTITY, STATUS_TYPE, DATE_RELEASED, DATE_COMPLETED,
SCHEDULED_START_DATE, SCHEDULED_COMPLETION_DATE, SCHEDULE_GROUP_ID,
BUILD_SEQUENCE, LINE_ID, PROJECT_ID, TASK_ID, COMPLETION_SUBINVENTORY,
COMPLETION_LOCATOR_ID, DESCRIPTION, SOURCE_CODE, SOURCE_LINE_ID,
OVERCOMPLETION_TOLERANCE_TYPE, OVERCOMPLETION_TOLERANCE_VALUE,
END_ITEM_UNIT_NUMBER, PRIORITY, DUE_DATE, ATTRIBUTE_CATEGORY, ATTRIBUTE1,
ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7,
ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12, ATTRIBUTE13,
ATTRIBUTE14, ATTRIBUTE15, ROUTING_REVISION_DATE,
DUMP LOCAL BLOCKER: initiate state dump for DEADLOCK

再現手順

  1. 計画マネージャ(MRCRLF)は1秒間隔で実行
  2. オープンインタフェースから新規のジョブが連携されるとWIP一括ロード(WICMLP)を実行

 

変更点

 

原因

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


本書の内容
現象
変更点
原因
解決策
参照情報

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