No script called "aw_retail_recovery.sql" found in Agent distribution files

book

Article ID: 87975

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine AUTOMIC WORKLOAD AUTOMATION

Issue/Introduction

Error Message :
N/A

The RA Oracle Retail version 2.0 manual states: 

"Run the aw_retail_recovery.sql script in the Oracle Retail database as the Oracle Retail user. The aw_retail_recovery.sql script is provided as part of the Oracle Retail agent distribution." 

There is no script called aw_retail_recovery.sql included in the distribution, instead the script that should be included is called Retail_recovery_proc.sql.  However, Retail_recovery_proc.sql was omitted in version 2.0.0 and is not part of the Agent's distribution package.

Cause

Cause type:
Defect
Root Cause: 1) Documentation references a script called aw_retail_recovery.sql which does not exist, this should reference Retail_recovery_proc.sql.
2) The Retail_recovery_proc.sql script not included in version 2.0.0's distribution package.

Environment

OS Version: N/A

Resolution

Update to a fix version listed below or a newer version if available.

The Oracle Retail Agent documentation has been corrected in the fix versions and above and now refers to the correct script, Retail_recovery_proc.sql and the file is available in the Agent's distribution package.

Reference

RA Oracle Retail – Agent Guide:
 

Fix Status: Released

Fix Version(s):
Component(s): RA Oracle Retail Agent Guide and RA Oracle Retail Solution

RA Oracle Retail 2.0.1 - Available

Additional Information

Workaround :
N/A