AWA: Unable to import SQLI objects

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

When attempting to import SQLI objects into the system, the import will fail with:

You do not have the necessary rights to import a SQL internal variable. Object '<NAME>' will be skipped.

 

Environment

Release : 12.3

Component : AUTOMATION ENGINE

Cause

Insufficient privileges 

Internal SQL variables weren't setup in client 0.

Resolution

This is due to the missing user privilege 'Create and modify SQL-internal variables' for the user attempting to import the object. Please check the user/usergroup privileges and try again.

Internal SQL variables also need to be activated in client 0.

Folder DIV_VARIABLES --> UC_SYSTEM_SETTINGS --> SQLVAR_INTERNAL = YES