Hello @god_prophet  I think, the error is in the SELECT clause. The STRING_AGG() function requires that you specify a delimiter for the concatenated string. In your query, you have not specified a delimiter, so PostgreSQL is throwing a syntax error.To fix the error, simply add a comma and a single q...

Hello @god_prophet , 1. First create a new field in the comunications_preference schema to store the recipient ID.To do this, open the Schema Editor and navigate to the comunications_preference schema. Then, add the following code to the schema:<attribute label="Recipient ID" name="RECIPIENTID" type...

Hello @rasiksj0311,  Please try the following code in HTML : <% var currentDateMinus30 = new Date(); currentDateMinus30.setDate(currentDateMinus30.getDate() - 30); %> <p><%= formatDate(currentDateMinus30, "%2D/%2M/%4Y") %> </p>  I tried this code and it is working. PFA Screenshot:  Kr,Parvesh 

Hello @acc_acs , The error message WKF-560029 in Adobe Campaign Classic means that there is some issue with the reconciliation key in the Update activity. 1. As I understood  first you used a query activity and read the data from source table.Notes: Just make sure you have a primary key in your sour...

Hello @Shruti1, The error message ODB-240000 ODBC error: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]There is insufficient system memory in resource pool 'default' to run this query. SQLState: 37000 indicates that the SQL Server server does not have enough memory to run the query that Adob...

Hello @god_prophet , It is also explained on the below documentation how index works.Data model best practices | Adobe Campaign  Hope it will be useful.  Kr, Parvesh 

Hello @mattiaslunden ,You mentioned that you have a load balancer, which means that you must have more than one Adobe Campaign server. Let's suppose you have two app servers: appServer1 and appServer2, connected to the same database. Your load balancer is named loadBalancer.If you want to use HTTPS ...

Hello @god_prophet, You need to create a field like below to store date time.  <attribute name="date" label="Subscription date" type="date"/>Value of type should be date.Then it will create a field in the backend with date time automatically.It mean you can store the date and time both the...

Hello @CampaignerForLife,  Can you please check what is the pkSequence name for this schema?For e.g. In the below example auto_custest01_seq is the sequence. <element autopk="true" label="Test01" name="test01" pkSequence="auto_custest01_seq"sqltable="CusTest01"> Now you need to check if this sequenc...

Hello @CampaignerForLife,  Can you please explain what is x there?is the primary key or something else?If x is not a primary key then autoincrement not going to work automatically. By default, autoincrement work only with primary key and where you define autoincrement flag true in the schema. Thanks...