My Oracle Support Banner

RI_SUPPORT_UTIL.CLEAR_RI_MCAL_TABLES Fails with "Error occurred in RSE_LOCK_MGR.wait_for_lock - Lock timeout occured while waiting for lock on W_RTL_COPR_HEAD_LC_DY_F" (Doc ID 3058381.1)

Last updated on NOVEMBER 13, 2024

Applies to:

Oracle Retail AI Foundation Cloud Service - Version 24.1 and later
Oracle Retail Lifecycle Pricing Optimization Cloud Service Advanced Edition - Version 24.1 and later
Oracle Retail Promotion and Markdown Optimization Cloud Service - Version 23.2 and later
Information in this document applies to any platform.

Goal

Executing the following script to clean the calendar returns an error.

DECLARE
SCHEMANAME VARCHAR2(200);
BEGIN
SCHEMANAME := 'RADM01';
RI_SUPPORT_UTIL.CLEAR_RI_MCAL_TABLES(
SCHEMANAME => SCHEMANAME
);
END;

ORA-20001: Error occurred in RI_SUPPORT_UTIL.clear_ri_mcal_tables
ORA-06512: at "RADM01.RI_LOG_UTIL", line 274
ORA-06512: at "RADM01.RI_SUPPORT_UTIL", line 364
ORA-20001: Error occurred in RI_SUPPORT_UTIL.clear_ri_table_partition
ORA-06512: at "RADM01.RI_LOG_UTIL", line 274
ORA-06512: at "RADM01.RI_SUPPORT_UTIL", line 329
ORA-20001: Error occurred in RI_SUPPORT_UTIL.remove_all_partitions - Error while removing partitions from W_RTL_COPR_HEAD_LC_DY_F
ORA-06512: at "RADM01.RI_LOG_UTIL", line 274
ORA-06512: at "RADM01.RI_SUPPORT_UTIL", line 295
ORA-20001: Error occurred in RSE_LOCK_MGR.lock_object
ORA-06512: at "RADM01.RSE_LOG_UTIL", line 294
ORA-06512: at "RADM01.RSE_LOG_UTIL", line 273
ORA-06512: at "RADM01.RSE_LOCK_MGR", line 41
ORA-20001: Error occurred in RSE_LOCK_MGR.wait_for_lock
ORA-06512: at "RADM01.RSE_LOG_UTIL", line 294
ORA-06512: at "RADM01.RSE_LOG_UTIL", line 273
ORA-06512: at "RADM01.RSE_LOCK_MGR", line 92
ORA-20001: Error occurred in RSE_LOCK_MGR.wait_for_lock - Lock timeout occured while waiting for lock on W_RTL_COPR_HEAD_LC_DY_F
ORA-06512: at "RADM01.RSE_LOG_UTIL", line 294
ORA-06512: at "RADM01.RSE_LOG_UTIL", line 273
ORA-06512: at "RADM01.RSE_LOCK_MGR", line 79
ORA-06512: at "RADM01.RSE_LOCK_MGR", line 34
ORA-06512: at "RADM01.RI_SUPPORT_UTIL", line 246
ORA-06512: at "RADM01.RI_SUPPORT_UTIL", line 320
ORA-06512: at "RADM01.RI_SUPPORT_UTIL", line 320
ORA-06512: at "RADM01.RI_SUPPORT_UTIL", line 357
ORA-06512: at line 5
 

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.