ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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


Article ID: 87975


Updated On:


CA Automic Workload Automation - Automation Engine


Error Message :

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 type:
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.


OS Version: N/A


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.


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 :