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.

Substitution Variables and Replacement Values do not resolve in Banner Login Override field

book

Article ID: 84691

calendar_today

Updated On:

Products

CA Automic Applications Manager (AM)

Issue/Introduction

Error Message :
ErrorMsg: AwE-5001 Database Query Error (1/1/17 12:00 AM)
Details: ORA-20035: Could not find "Db login [email protected]{agent}"
ORA-06512: at "APPMGR.AWAPI2", line 477

The RA Banner Login Override field accepts Substitution Variables and Replacement Values as noted in the documentation referenced below. The {agent} Replacement Variable is commonly used in this field to dynamically select the connection object. After upgrading to Applications Manager version 9.2.0, the RA Banner Login Override field no longer resolves Substitution Variables and Replacement Values.

Attempting to use an {agent} Replacement Variable will throw a Database Query Error stating that the login could not be found. The full error message below shows that the Replacement Value {agent} is not evaluated.

 
ErrorMsg: AwE-5001 Database Query Error (1/1/17 12:00 AM)
Details: ORA-20035: Could not find "Db login [email protected]{agent}"
ORA-06512: at "APPMGR.AWAPI2", line 477
ORA-06512: at "APPMGR.AWAPI2", line 450
ORA-06512: at "APPMGR.AWAPI", line 112
ORA-06512: at "APPMGR.AWAPI", line 1128
ORA-06512: at "APPMGR.AWAPI", line 1246
ORA-06512: at line 1

Reference

RA Banner – Agent Guide 3.6:
Working with Jobs > Introduction to Working with Jobs
 

Cause

Cause type:
Defect
Root Cause: Bug caused by another fix made in AM 9.2.0

Environment

OS Version: N/A

Resolution

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

Fix Status: Released

Fix Version(s):
Applications Manager 9.2.1 - Available

Additional Information

Workaround :
  1. Revert to Applications Manger 9.1.3 or below.
OR
  1. Avoid using Substitution Variables and Replacement Values in the Banner Login Override field.