My Oracle Support Banner

Batch Process Failed: RPM_SFR_DATA_CONVERSION_JOB (Doc ID 2890672.1)

Last updated on OCTOBER 28, 2022

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version 22.1 and later
Information in this document applies to any platform.

Symptoms

Batch Process failed: RPM_SFR_DATA_CONVERSION_JOB

Executor - Run job process successfully started with PID [310] by user [oracle]
2022-06-08T16:48:47,251 [Thread-22] INFO ShellExecutor - ***********************************************************************************************
2022-06-08T16:48:47,251 [Thread-22] INFO ShellExecutor - ******* BEGIN SYSERR FOR PROGRAM: @RMSAlias
2022-06-08T16:48:47,251 [Thread-22] INFO ShellExecutor - ***********************************************************************************************
2022-06-08T16:48:47,609 [Thread-21] INFO ShellExecutor - EXT_PROG_SYS_OUT:@RMSAlias: Running dataConversionSeedFutureRetail Batch
2022-06-08T16:48:47,609 [Thread-21] INFO ShellExecutor - EXT_PROG_SYS_OUT:@RMSAlias: SLOTS= 4
2022-06-08T16:48:47,614 [Thread-21] INFO ShellExecutor - EXT_PROG_SYS_OUT:@RMSAlias: LOGFILE= /u01/retail/rpm/rpm-batch/batch/dataConversionSeedFutureRetail.Jun_08_2022.log
2022-06-08T16:48:47,614 [Thread-21] INFO ShellExecutor - EXT_PROG_SYS_OUT:@RMSAlias: ERRFILE= /u01/retail/rpm/rpm-batch/batch/err.dataConversionSeedFutureRetail.Jun_08_2022
2022-06-08T16:48:47,859 [Thread-21] INFO ShellExecutor - EXT_PROG_SYS_OUT:@RMSAlias: ORA Error while threading the staged data
2022-06-08T16:48:47,860 [Thread-21] INFO ShellExecutor - EXT_PROG_SYS_OUT:@RMSAlias: ERROR:
2022-06-08T16:48:47,860 [Thread-21] INFO ShellExecutor - EXT_PROG_SYS_OUT:@RMSAlias: ORA-12154: TNS:could not resolve the connect identifier specified
2022-06-08T16:48:47,861 [Thread-21] INFO ShellExecutor - EXT_PROG_SYS_OUT:@RMSAlias:
2022-06-08T16:48:47,861 [Thread-21] INFO ShellExecutor - EXT_PROG_SYS_OUT:@RMSAlias:
2022-06-08T16:48:47,861 [Thread-21] INFO ShellExecutor - EXT_PROG_SYS_OUT:@RMSAlias: SP2-0306: Invalid option.
2022-06-08T16:48:47,861 [Thread-21] INFO ShellExecutor - EXT_PROG_SYS_OUT:@RMSAlias: Usage: CONN[ECT] [{logon|/|proxy} [AS {SYSDBA|SYSOPER|SYSASM|SYSBACKUP|SYSDG|SYSKM|SYSRAC}] [edition=value]]
2022-06-08T16:48:47,861 [Thread-21] INFO ShellExecutor - EXT_PROG_SYS_OUT:@RMSAlias: where <logon> ::= <username>[/<password>][@<connect_identifier>]
2022-06-08T16:48:47,861 [Thread-21] INFO ShellExecutor - EXT_PROG_SYS_OUT:@RMSAlias: <proxy> ::= <proxyuser>[<username>][/<password>][@<connect_identifier>]
2022-06-08T16:48:47,861 [Thread-21] INFO ShellExecutor - EXT_PROG_SYS_OUT:@RMSAlias: SP2-0306: Invalid option.
2022-06-08T16:48:47,861 [Thread-21] INFO ShellExecutor - EXT_PROG_SYS_OUT:@RMSAlias: Usage: CONN[ECT] [{logon|/|proxy} [AS {SYSDBA|SYSOPER|SYSASM|SYSBACKUP|SYSDG|SYSKM|SYSRAC}] [edition=value]]
2022-06-08T16:48:47,861 [Thread-21] INFO ShellExecutor - EXT_PROG_SYS_OUT:@RMSAlias: where <logon> ::= <username>[/<password>][@<connect_identifier>]
2022-06-08T16:48:47,861 [Thread-21] INFO ShellExecutor - EXT_PROG_SYS_OUT:@RMSAlias: <proxy> ::= <proxyuser>[<username>][/<password>][@<connect_identifier>]
2022-06-08T16:48:47,861 [Thread-21] INFO ShellExecutor - EXT_PROG_SYS_OUT:@RMSAlias: SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
2022-06-08T16:48:47,863 [Thread-21] INFO ShellExecutor - ***********************************************************************************************

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!

In this Document
Symptoms
Cause
Solution
  
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.