Issues when running workflow to Export Audiences from AC to AAM using “Update shared audience” Activity

Description

We are integrating AC and Audience Manager in our system. We are running work flow to Export Audiences from AC to AAM using “Update shared audience” Activity. The workflow is failing in this step with the error 



“exportToAAM    XTK-170016 You are not authorized to use SQL expressions. ‘digest’ cannot be processed.”



Could you please let me know the cause of this error and how to resolve this ?


Resolution

This error often occurs when there is encryption set at amc datasource or encrypted identified is used a reconciliation key.

You can check the AMC-datasource and make sure to check the encryption (setting it to None sometimes helped), also the encrypted-Identifier can not be used as a recon-key).

I think the problem comes from the fact that the digest function is being used directly without the table name. Ideally the function should be referred to as nmsrecipient.digest() instead of digest() directly.

Same solution has been provided in : https://social.msdn.microsoft.com/Forums/sqlserver/en-US/66a6e3db-3ec6-4214-9d2f-a6a532a37db5/execution-error-the-function-name-is-not-a-recognized-builtin-function-name?forum=sqldatabaseengine

To resolve this , you need to select encryption method to none in the AMC data sources folder under Administrationplatform as mentioned above.

On this page