My Oracle Support Banner

PRO_SEASON_PRODUCT_LOAD_JOB Fails with "Number of Validation Errors are more than the number of Maximum" (Doc ID 3030917.1)

Last updated on JUNE 25, 2024

Applies to:

Oracle Retail Science Platform Cloud Service - Version 23.1 and later
Oracle Retail AI Foundation Cloud Service - Version 24.1 and later
Information in this document applies to any platform.

Goal

PRO_SEASON_PRODUCT_LOAD_JOB fails and log shows:

pro_season_product_load.ksh: pro_season_product_load.ksh~20240624013723~EXEC_SQL~ BEGIN
pro_season_product_load.ksh: *
pro_season_product_load.ksh: ERROR at line 1:
pro_season_product_load.ksh: ORA-20001: Error occurred in RSE_LOAD_MGR.load
pro_season_product_load.ksh: ORA-06512: at line 7
pro_season_product_load.ksh: ORA-06512: at "RASE01.RSE_LOG_UTIL", line 294
pro_season_product_load.ksh: ORA-06512: at "RASE01.RSE_LOG_UTIL", line 273
pro_season_product_load.ksh: ORA-06512: at "RASE01.RSE_LOAD_MGR", line 58
pro_season_product_load.ksh: ORA-20001: Error occurred in RSE_LOAD_SRVC_T.load - ERROR : Load FAILED
pro_season_product_load.ksh: ORA-06512: at "RASE01.RSE_LOG_UTIL", line 294
pro_season_product_load.ksh: ORA-06512: at "RASE01.RSE_LOG_UTIL", line 273
pro_season_product_load.ksh: ORA-06512: at "RASE01.RSE_LOAD_SRVC_T", line 70
pro_season_product_load.ksh: ORA-20001: Error occurred in RSE_LOAD_SRVC_T.load - ERROR : PRO_SEASON_PRODUCT
pro_season_product_load.ksh: Load FAILED
pro_season_product_load.ksh: ORA-06512: at "RASE01.RSE_LOG_UTIL", line 294
pro_season_product_load.ksh: ORA-06512: at "RASE01.RSE_LOG_UTIL", line 273
pro_season_product_load.ksh: ORA-06512: at "RASE01.RSE_LOAD_SRVC_T", line 144
pro_season_product_load.ksh: ORA-20001: Error occurred in RSE_LOAD_SRVC_T.post_validate
pro_season_product_load.ksh: ORA-06512: at "RASE01.RSE_LOG_UTIL", line 294
pro_season_product_load.ksh: ORA-06512: at "RASE01.RSE_LOG_UTIL", line 273
pro_season_product_load.ksh: ORA-06512: at "RASE01.RSE_LOAD_SRVC_T", line 325
pro_season_product_load.ksh: ORA-20001: Error occurred in RSE_LOAD_SRVC_T.post_validate - ERROR : Validation
pro_season_product_load.ksh: FAILED. Number of Validation Errors are more than the number of Maximum
pro_season_product_load.ksh: Number/Percent of errors permitted. Review RSE_LOG_MSG

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.