My Oracle Support Banner

RPASCE: Batch Rule Group 'Failed To Get Read Lock For '../../../..'Could Not Createfile With A Blank File Name' (Doc ID 2734321.1)

Last updated on APRIL 16, 2021

Applies to:

Oracle Retail Demand Forecasting Cloud Service Plus - Version 18.0 and later
Oracle Retail Merchandise Financial Planning Enterprise Edition Cloud Service - Version 18.0 and later
Oracle Retail Assortment & Item Planning Enterprise Edition Cloud Service - Version 18.0 and later
Oracle Retail Predictive Application Server Cloud Edition - Version 18.0 and later
Information in this document applies to any platform.

Goal

What would cause the following error when executing a rule group during batch process?

LockException with message 'Failed to get read lock for '../../../..'Could not createfile with a blank file name.'

Depending on the loglevel for which the batch was, one can see the problematic measure up above the failure measure, if they scroll back in the log.

E.g.

<D 2021Apr16 15:21:56.320> Database 'mfprcs/ldom021/data/drtynslsr', Read, 'drtynslsr'
<D 2021Apr16 15:21:56.320> Database 'mfprcs/ldom022/data/drtynslsr', Read, 'drtynslsr'
<D 2021Apr16 15:21:56.320> Database 'mfprcs/ldom023/data/drtynslsr', Read, 'drtynslsr'
<D 2021Apr16 15:21:56.320> Database 'mfprcs/ldom024/data/drtynslsr', Read, 'drtynslsr'
<D 2021Apr16 15:21:56.320> Database '', Read, 'ltwpgmrp'
<D 2021Apr16 15:21:56.320> Database 'mfprcs/data/add1chnlmapb', Write, 'add1chnlmapb'
<D 2021Apr16 15:21:56.320> Database 'mfprcs/data/add1lagl2t', Write, 'add1lagl2t'
<D 2021Apr16 15:21:56.320> Database 'mfprcs/data/add1laglyt', Write, 'add1laglyt'
<D 2021Apr16 15:21:56.320> Database 'mfprcs/data/add2lagl2t', Write, 'add2lagl2t'


Notice the line that in the middle of the log referencing 'ltwpgmrp'.  This measure is the problem.  It is being used as an input to a calculation in the rule group.  All measures in batch rules must have a database associated with them.

Solution

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.