Saviynt unveils its cutting-edge Intelligence Suite products to revolutionize Identity Security!
Click HERE to see how Saviynt Intelligence is transforming the industry.
Saviynt Copilot Icon

Enhanced Query Execution Failure

AT
New Contributor
New Contributor

Hello, 

We need to run an enhanced query execution job to update the AWS connection type. We've performed this change in our pre-production environment. This is due to the 'Encrypted Connection Attributes' field not containing all the attributes that need to be encrypted. The query we're attempting to run is:

 

SELECT
    EXTERNALCONNECTIONTYPEKEY externalconnectiontype__EXTERNALCONNECTIONTYPEKEY ,concat(ENCRYPTEDATTRIBUTES,',AWS_ACCESS_KEY,AWS_ACCESS_SECRET_PASSWORD') AS externalconnectiontype__ENCRYPTEDATTRIBUTES
FROM 
    externalconnectiontype 
WHERE 
    EXTERNALCONNECTIONTYPEKEY=<connection_type_key>

 

When we attempt to save this enhanced query execution job with the above query we see the following pop-up error:

AT_0-1729156388491.png

Can you advise? 

 

7 REPLIES 7

NM
Esteemed Contributor
Esteemed Contributor

@AT mostly likely the column is restricted you can update it via enhanced query.


If this helped you move forward, click 'Kudos'. If it solved your query, select 'Accept As Solution'

AT
New Contributor
New Contributor

@NM As I said above, we are trying to run the query via an enhanced query execution job. When we attempt to save the config of the job, we get the above pop-up.

NM
Esteemed Contributor
Esteemed Contributor

@AT sorry instead of can I was suppose to write can't 


If this helped you move forward, click 'Kudos'. If it solved your query, select 'Accept As Solution'

AT
New Contributor
New Contributor

@NM Ok, thanks for clarifying that however we have ran this query in pre-prod and it's been successful. Additionally this is a core requirement of our configuration as AWS_Access_Key should be encrypted. As such how can we perform this configuration?

 

NM
Esteemed Contributor
Esteemed Contributor

@AT prod and preprd version difference?


If this helped you move forward, click 'Kudos'. If it solved your query, select 'Accept As Solution'

Raghu
All-Star
All-Star

@AT  can you share youe table name and primarykey of table column, looks your query is not correct


Thanks,
Raghu
If this reply answered your question, Please Accept As Solution and hit Kudos.

rushikeshvartak
All-Star
All-Star

Use below query 

	SELECT
    EXTERNALCONNECTIONTYPEKEY externalconnectiontype__PRIMARYKEY ,concat(ENCRYPTEDATTRIBUTES,',AWS_ACCESS_KEY,AWS_ACCESS_SECRET_PASSWORD') AS externalconnectiontype__ENCRYPTEDATTRIBUTES
FROM 
    externalconnectiontype 
WHERE 
    EXTERNALCONNECTIONTYPEKEY=<connection_type_key>

rushikeshvartak_0-1729171757357.png

rushikeshvartak_1-1729171859890.png

 

Please note after upgrade this will be again removed , Please raise idea for this enhancement 

 


Regards,
Rushikesh Vartak
If this helped you move forward, click 'Kudos'. If it solved your query, select 'Accept As Solution'.