SQL-Vara (Oracle) within Multi-Vara impossible to start
Article ID: 84420
Updated On:
Products
CA Automic Workload Automation - Automation Engine
Issue/Introduction
Error Message :
Error: Query could not be executed: 'Non supported SQL92 token at position: 1 (Client: '0100', PREVIEW, Variable: 'VARA.EKIP.FONCLOPER_IST')'
When a SQL-VARA uses a connection object to an Oracle database using db service, it cannot be used within a multi vara object. When clicking preview an error message pops up. The SQL-VARA object does not have an error when ran on its own. Trying to preview the variable results in the error message.
Error: Query could not be executed: 'Non supported SQL92 token at position: 1 (Client: '0100', PREVIEW, Variable: 'VARA.EKIP.FONCLOPER_IST')'
When a SQL-VARA uses a connection object to an Oracle database using db service, it cannot be used within a multi vara object. When clicking preview an error message pops up. The SQL-VARA object does not have an error when ran on its own. Trying to preview the variable results in the error message.
Cause
Cause type:
By design
Root Cause: The VAR_SECURITY_LEVEL is incorrectly set, resulting in the VARA object being wrongly evaluated.
By design
Root Cause: The VAR_SECURITY_LEVEL is incorrectly set, resulting in the VARA object being wrongly evaluated.
Environment
Release: AUTWAB99000-12.0-Automic Workload Automation-Base Edition
Component:
Component:
Resolution
In UC_CLIENT_SETTINGS in Client 0, change the value of VAR_SECURITY_LEVEL to 3.
Fix Status: No Fix
Fix Status: No Fix
Feedback
Yes
No
Powered by
