Cron_import.sh Fails If The Oracle DB Password Contains The # Character (Doc ID 2147402.1)

Last updated on JUNE 09, 2016

Applies to:

Oracle Retail Extract Tranform and Load - Version 14.1.2 and later
Information in this document applies to any platform.

Symptoms

On: Retail Extract Transform and Load (RETL) 14.1.2 version, RETL Interface - Schema File Format

The cron_import.sh Advanced Inventory Planning (AIP) batch job fails with the following error message in the sub-logs for hier_store_in and hier_sku_pk_in

We ran again the sqlldr command manually with the PARFILE parameter as specified in the log message and found that the command failed if the password contains a # but succeeds if the password does not contain #.

ERROR
-----------------------

 


Steps to Reproduce
-----------------------
The issue can be reproduced at will with the following steps:
1. Run AIP's cron_import.sh.



Cause

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 hundreds of Community platforms