Adobe Campaign Classic
When integrating AC and Audience Manager and running workflow to Export Audiences from AC to AAM using “Update shared audience” activity, the workflow fails with a similar error to this:
exportToAAM XTK-170016 You are not authorized to use SQL expressions. 'digest' cannot be processed.
This error often occurs when there is encryption set at AMC-datasource, or the encrypted-Identifier is using a reconciliation key.
You can check the AMC-datasource and make sure to check the encryption (setting it to none sometimes helps), and also the encrypted-Identifier can not be used as a reconciliation key.
The problem may come 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
The same solution has been provided in a Microsoft forum post: 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.