My Oracle Support Banner

RSP: SPO_MASTER_ADHOC Job Fails at RSE_SRVC_MGR.batch_pre_process (Doc ID 2808915.1)

Last updated on SEPTEMBER 11, 2023

Applies to:

Oracle Retail Science Platform Cloud Service - Version 19.1 and later
Information in this document applies to any platform.

Symptoms

The SPO_MASTER_ADHOC job fails and log shows:

2021-09-17T14:46:42,132 [Thread-75] DEBUG BatchShellCommandRunnerBatchlet - EXT_PROG_SYS_OUT:/u01/retail/orase/retail_home/rse-home/common/scripts/bin/orase_adhoc_wrapper.ksh: Fri Sep 17 14:46:42 Program: spo_size_map_setup.ksh: PID=6717: Process started by rgbu_ris. MAIN function
2021-09-17T14:46:42,626 [Thread-75] DEBUG BatchShellCommandRunnerBatchlet - EXT_PROG_SYS_OUT:/u01/retail/orase/retail_home/rse-home/common/scripts/bin/orase_adhoc_wrapper.ksh: spo_size_map_setup.ksh~20210917144642~EXEC_SQL~ BEGIN
2021-09-17T14:46:42,627 [Thread-75] DEBUG BatchShellCommandRunnerBatchlet - EXT_PROG_SYS_OUT:/u01/retail/orase/retail_home/rse-home/common/scripts/bin/orase_adhoc_wrapper.ksh: *
2021-09-17T14:46:42,627 [Thread-75] DEBUG BatchShellCommandRunnerBatchlet - EXT_PROG_SYS_OUT:/u01/retail/orase/retail_home/rse-home/common/scripts/bin/orase_adhoc_wrapper.ksh: ERROR at line 1:
2021-09-17T14:46:42,627 [Thread-75] DEBUG BatchShellCommandRunnerBatchlet - EXT_PROG_SYS_OUT:/u01/retail/orase/retail_home/rse-home/common/scripts/bin/orase_adhoc_wrapper.ksh: ORA-20001: Error occurred in RSE_SRVC_MGR.batch_pre_process
2021-09-17T14:46:42,627 [Thread-75] DEBUG BatchShellCommandRunnerBatchlet - EXT_PROG_SYS_OUT:/u01/retail/orase/retail_home/rse-home/common/scripts/bin/orase_adhoc_wrapper.ksh: ORA-06512: at "RASE01.RSE_LOG_UTIL", line 230
2021-09-17T14:46:42,627 [Thread-75] DEBUG BatchShellCommandRunnerBatchlet - EXT_PROG_SYS_OUT:/u01/retail/orase/retail_home/rse-home/common/scripts/bin/orase_adhoc_wrapper.ksh: ORA-06512: at "RASE01.RSE_SRVC_MGR", line 106
2021-09-17T14:46:42,627 [Thread-75] DEBUG BatchShellCommandRunnerBatchlet - EXT_PROG_SYS_OUT:/u01/retail/orase/retail_home/rse-home/common/scripts/bin/orase_adhoc_wrapper.ksh: ORA-20001: Error occurred in RSE_SRVC_MGR.get_srvc
2021-09-17T14:46:42,627 [Thread-75] DEBUG BatchShellCommandRunnerBatchlet - EXT_PROG_SYS_OUT:/u01/retail/orase/retail_home/rse-home/common/scripts/bin/orase_adhoc_wrapper.ksh: ORA-06512: at "RASE01.RSE_LOG_UTIL", line 230
2021-09-17T14:46:42,627 [Thread-75] DEBUG BatchShellCommandRunnerBatchlet - EXT_PROG_SYS_OUT:/u01/retail/orase/retail_home/rse-home/common/scripts/bin/orase_adhoc_wrapper.ksh: ORA-06512: at "RASE01.RSE_SRVC_MGR", line 161
2021-09-17T14:46:42,627 [Thread-75] DEBUG BatchShellCommandRunnerBatchlet - EXT_PROG_SYS_OUT:/u01/retail/orase/retail_home/rse-home/common/scripts/bin/orase_adhoc_wrapper.ksh: ORA-20001: Error occurred in RSE_SRVC_MGR.get_srvc
2021-09-17T14:46:42,627 [Thread-75] DEBUG BatchShellCommandRunnerBatchlet - EXT_PROG_SYS_OUT:/u01/retail/orase/retail_home/rse-home/common/scripts/bin/orase_adhoc_wrapper.ksh: ORA-06512: at "RASE01.RSE_LOG_UTIL", line 230
2021-09-17T14:46:42,627 [Thread-75] DEBUG BatchShellCommandRunnerBatchlet - EXT_PROG_SYS_OUT:/u01/retail/orase/retail_home/rse-home/common/scripts/bin/orase_adhoc_wrapper.ksh: ORA-06512: at "RASE01.RSE_SRVC_MGR", line 210
2021-09-17T14:46:42,627 [Thread-75] DEBUG BatchShellCommandRunnerBatchlet - EXT_PROG_SYS_OUT:/u01/retail/orase/retail_home/rse-home/common/scripts/bin/orase_adhoc_wrapper.ksh: ORA-20001: Error occurred in RSE_SRVC_MGR.get_srvc - No service implementation
2021-09-17T14:46:42,628 [Thread-75] DEBUG BatchShellCommandRunnerBatchlet - EXT_PROG_SYS_OUT:/u01/retail/orase/retail_home/rse-home/common/scripts/bin/orase_adhoc_wrapper.ksh: was found for the provided id []
2021-09-17T14:46:42,628 [Thread-75] DEBUG BatchShellCommandRunnerBatchlet - EXT_PROG_SYS_OUT:/u01/retail/orase/retail_home/rse-home/common/scripts/bin/orase_adhoc_wrapper.ksh: ORA-06512: at line 9
2021-09-17T14:46:42,634 [Thread-75] DEBUG BatchShellCommandRunnerBatchlet - EXT_PROG_SYS_OUT:/u01/retail/orase/retail_home/rse-home/common/scripts/bin/orase_adhoc_wrapper.ksh: Fri Sep 17 14:46:42 Program: spo_size_map_setup.ksh: PID=: Aborted in EXEC_SQL
2021-09-17T14:46:42,641 [Thread-75] DEBUG BatchShellCommandRunnerBatchlet - EXT_PROG_SYS_OUT:/u01/retail/orase/retail_home/rse-home/common/scripts/bin/orase_adhoc_wrapper.ksh: Function call BATCH_PRE_PROCESS failed.
2021-09-17T14:46:42,655 [Thread-75] DEBUG BatchShellCommandRunnerBatchlet - ***********************************************************************************************
2021-09-17T14:46:42,655 [Thread-76] WARN BatchShellCommandRunnerBatchlet -
2021-09-17T14:46:42,655 [Thread-76] DEBUG BatchShellCommandRunnerBatchlet - ***********************************************************************************************
2021-09-17T14:46:42,655 [Thread-75] DEBUG BatchShellCommandRunnerBatchlet - ******* END SYSOUT FOR PROGRAM: /u01/retail/orase/retail_home/rse-home/common/scripts/bin/orase_adhoc_wrapper.ksh
2021-09-17T14:46:42,656 [Thread-76] DEBUG BatchShellCommandRunnerBatchlet - ******* END SYSERR FOR PROGRAM: /u01/retail/orase/retail_home/rse-home/common/scripts/bin/orase_adhoc_wrapper.ksh
2021-09-17T14:46:42,656 [Thread-75] DEBUG BatchShellCommandRunnerBatchlet - ***********************************************************************************************
2021-09-17T14:46:42,656 [Thread-76] DEBUG BatchShellCommandRunnerBatchlet - ***********************************************************************************************
2021-09-17T14:46:42,658 [[ACTIVE] ExecuteThread: '34' for queue: 'weblogic.kernel.Default (self-tuning)'] INFO BatchShellCommandRunnerBatchlet - Forked process(/u01/retail/orase/retail_home/rse-home/common/scripts/bin/orase_adhoc_wrapper.ksh /u01/retail/orase/retail_home/rse-home /u01/retail/orase/retail_home/rse-home/cdm/spo/scripts/bin/spo_master.ksh -A) exited.
2021-09-17T14:46:42,627 [Thread-75] DEBUG BatchShellCommandRunnerBatchlet - EXT_PROG_SYS_OUT:/u01/retail/orase/retail_home/rse-home/common/scripts/bin/orase_adhoc_wrapper.ksh: ERROR at line 1:
2021-09-17T14:46:42,627 [Thread-75] DEBUG BatchShellCommandRunnerBatchlet - EXT_PROG_SYS_OUT:/u01/retail/orase/retail_home/rse-home/common/scripts/bin/orase_adhoc_wrapper.ksh: ORA-20001: Error occurred in RSE_SRVC_MGR.batch_pre_process

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.