Decryption Issue

Help Studio
1

Hello team,
I have an SQL table with encrypted data and using a query decrytpitng and getting the data using Execute Query Activity.
When i run the code from studio the values are decrypting fine, but when if deploy it on orchestrator and run the code the value it is giving as System.Byte.

Can someone provide the reason for this weired behaviour.

2

Hi @Satya_Kishore

Could you share some more details around the activity packages versions used by your process and the query itself (as much as you can without sharing sensitive information)?

3

Activity Execute Query
Handled decryption using sqlquery
SELECT aes_decrypt(‘data_need_to_encrypt’,sha2(‘password’, 256))