My Oracle Support Banner

RDF: Cannot Obtain a Write Lock on Database Error When Executing "dataprocess" Rule Group in Parallel (Doc ID 2495691.1)

Last updated on MARCH 11, 2019

Applies to:

Oracle Retail Demand Forecasting - Version 15.0 and later
Information in this document applies to any platform.

Symptoms

rdf_preprocess.ksh batch is failing with below lock contention errors when executing "dataprocess" rule group in parallel mode:

Errors:

 

Here is the config for dataprocess rule group:
======================Rule Groups===================
dataprocess:
      calc_todayindex
             PreTodayIndex=index([CLND].[WEEK],now )
      calc_prelastslswk
              PreLastSlsWk = if(Pre1stSlsWk > -1,PreTodayIndex-1,-1)
      calc_prepopslsnum
              PrePopSlsNum=if(Pre1stSlsWk > -1, PreTodayIndex-Pre1stSlsWk+1,0)

Changes

 

Cause

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.