By: Suraj Patra, Senior Consultant, Meijer
As a Senior Engineer and customer expert on Adobe Experience Cloud products for the past five years, I enable business users at Meijer, an American supercenter chain founded in 1934, to run complex marketing and transactional campaigns with ACS. A few projects that I’ve worked on include customized campaigns to store offers and order details for personalization, integrated with Adobe Audience Manager, and customer insight for segment ingestion.
In my time using ACS, I’ve run into errors which can be time consuming and frustrating to solve. Knowing the most common errors can help with faster problem-solving and boost your productivity. Below are my troubleshooting tips to help you effectively resolve similar errors as they occur.
PGS-220000 PostgreSQL error: ERROR: operator does not exist: character varying = bigint
These types of errors appear in a workflow when you try to reconcile using fields of different data types. For example, when you upload a file using load file which has a string field, and you try to reconcile the string field with a profile field that has data type of int.
Change the data type of the field in “Load file” activity to the one that you are matching with. Open the “Load File” activity. Move to the “COLUMN DEFINITION” tab and change the data type of the desired field.
The schema for profiles specified in the transition ('') is not compatible with the schema defined in the delivery template ('nms:recipient'). They should be identical.
This error appears when you are sending an email to an address, but the email or any other identifier is not reconciled with a profile. To send an email communication, the email or the identifier should be always linked to a profile.
A common ID must exist from the loaded file with the recipient table. This common key joins the load file to the recipient table within the reconciliation activity. Emails may not be sent to records that do not exist in the recipient table which requires this reconciliation step within the workflow. In doing so, you would reconcile the incoming load file activity with an identifier like email ID from the profile. The
nms:recipient schema refers to the profile table and reconciling the incoming records with profile makes it available during email preparation.
Refer to the screenshot for reconciliation activity as shown below.
Learn more about reconciliation.
The document types of inbound events (''and'') are incompatible (step 'Exclusion'). Unable to perform the operation.
This issue occurs while using the exclusion activity in ACS workflows, when performing an exclusion based on the ID, when the Primary set and the excluded set don’t have the same field names.
There are two ways to resolve this error:
Use the same field name in both the primary and excluded and use that field as ID
Use the JOINS exclusion method to select the field based on which you want to exclude the records.
XTK-170036 Unable to parse expression 'i__name'
Failure points may occur in an enrichment activity. One of the most common is displayed below.
This happens when you manually edit an expression name in the activity. The image shows that the expression was modified from
You can resolve this error in three ways:
Change the name back to the expression that was originally present.
If you want to use a new name, change the values in the enrichment activity.
If you don’t remember what has changed, your best bet would be to recreate the activity.
XTK-170024 The temporary schema "temp:deliveryEmail1" is not defined in the current context.
This is a common error in complicated workflows involving enrichment or other activity. It probably means some of the activity workflows are not correctly saved during multiple changes to the workflow.
There are many ways that this error can occur, so there is not a simple fix. If it is a simple workflow, then it would better to reconfigure the activity. In a complicated workflow, it is better to copy the workflow activities to a new workflow, save, and rerun it.