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

Description

Environment
Adobe Campaign Classic
Adobe Campaign

Issue
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.



 

 

Resolution

Solution

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 digest() directly.

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.

On this page