“Update shared audience” Issues running workflow to Export Audiences

Description 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 resolution

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: Execution error: ‘the function name is not a recognized built-in function name’.

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

recommendation-more-help
3d58f420-19b5-47a0-a122-5c9dab55ec7f