My Oracle Support Banner

Unhandled Oracle Connection Error Message Passed As Parameter To PROCESS_SALES. (Doc ID 2383435.1)

Last updated on SEPTEMBER 25, 2018

Applies to:

Oracle Retail Merchandising System - Version 14.1.3 and later
Information in this document applies to any platform.

Symptoms

In RMS 14.1.3, While running the Salesprocess.ksh it fails with error 

Unhandled oracle connection error message passed as parameter to PROCESS_SALES.


Steps To Reproduce the issue:

1. Load sales data into RMS but before running the salesprocess.ksh modify the connection string, to force an ORA error.
2. Notice that words that make up the ora error message are being used as $1/$2 parameters (instead of the process/chunk_id) in the call to the process sales function. This leads the process to abort and logs syntax errors in the error log.

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.