GET_VAR behavior different between SQL Server and Oracle

book

Article ID: 87526

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine AUTOMIC WORKLOAD AUTOMATION

Issue/Introduction

Error Message :
N/A

When utilizing GET_VAR, the results appear different depending on the DB being referenced. GET_VAR calls against SQL Server will work regardless of case for Key or Column values but will not return results unless an exact case match against Oracle. 



 

Cause

Cause type:
By design
Root Cause: This is due to Oracle being a case sensitive DB - the results would be the same when searching directly on a DB level.

Environment

Release: AUTWAB99000-11.0-Automic Workload Automation-Base Edition
Component:

Resolution

This field was added on 30/03/2017. This article has not been updated yet. Refer to the "Description" or "Workaround" sections for solution information.

Fix Status: No Fix

Additional Information

Workaround :
Force case rules on a business level for all variable references.