Campaign Classic v7 & Campaign v8

Here is sample of my schema which I will export data to <element autopk="true" autouuid="true" dataSource="nms:extAccount:bqExport" desc="bqtest" hybrid="false" img="xtk:bigquery.png" label="bqtest" labelSingular="bqtest" name="bqtest" sqltable="bqtest"> <attribute label="col1" name="col1" type="string"/> <attribute label="col2" name="col2" type="string"/> <attribute label="col3" name="col3" type="datetime"/> </element> In my workflow I am querying these 3 columns from campaign and then I have the update activity with operation type set to "Insert" as I only want to export deltas rather than syncing changes the gcp remote table, for this reason I had set the autopk="true" and autouuid="true" However, I am getting the following error 10/01/2025 03:05:27 writer2 WDB-200001 SQL statement 'UPDATE wkf5712550_85_1 SET uAutoPKey_1= WHERE iRecProcState >= 0 AND COALESCE(uPKey_1,NULL) IS NULL' could not be executed. 10/01/2025 03:05:

Marketing server and DB (Oracle) - In house in client premises.Data is getting loaded for multiple Business units.For better performance of database, client is looking for partitioning of database.What are the best practices that can be suggested to clients for partitioning.Would there be any change at Adobe Campaign application level (any changes to existing workflows or queries) if the database is partitioned? Please help with pointers.

Hello, I want to change the default delivery address domain from foobar.foo.com to foobar.comtherefore I also need to change the bounce addresses bounced-campaign@foobar.foo.com to bounced-campaign@foobar.com How and where can or must I do these changes for both?Cheers

Hello, I am trying to create a sFTP external account at the following location: Administration > Platform > External Accounts I do have the SSH Key for that account and can able to login there by using FileZilla and trying to use the same public SSH key at this external account.  Any idea or documentation how to create sFTP external account? Thanks! Ali

Hi Adobe team,Kindly help me to understand the Expiration tab in Scheduler activity , when and how we can used it. Thank you in advance. 

Hi All,I am getting 'SOP-330011 Error while executing the method 'Validation' of service 'nms:offer' while trying to approve content or eligibility of an offer, which working fine in another instance. Also the offer space listed in offer preview is not clickable as well. PFB the screenshots for reference.   Appreciate your valuable inputs. Thanks  

HiI am on Campaign Classic v7.I want to send an alert to different users depending on rules defined in the workflow.I have been able to select the relevant operators from the operators table, or to define the email address to be targeted in the workflow variables.However, referencing the variable in Alert : Assignment Type : Filter doesn't seem to work (is there a way to do this? do I need to include some script in Alert :  Advanced Tab : Initialization script to pass this through?), and I can't feed selected operators into the alert to target them like a delivery.I have one other idea which I am yet to test (selecting operators in the workflow, assigning them to a group in the workflow, targeting the group, then emptying the group before the workflow runs again) but wanted to check if there was an easier way.Many Thanks

Hi, we had to update the iOS certificate. I tested the connection and it was successfull. However now when I try to send I push I get that error: unable to get bundle id from certificate adobe campaignHow can I fix this? 

Hi everyone,I’m facing an issue with a Recurring Delivery in Adobe Campaign where the post-processing workflow doesn’t get triggered if the target contains 0 records.Here’s the context:I have two identical deliveries:One is launched using a Phone Delivery activity, which always triggers the post-processing workflow even if the target is empty. I get this log message:              The other is launched using a Recurring Delivery activity, which doesn’t trigger the post-processing workflow when the target is empty. Instead, it gets stuck with the log message: This behavior only occurs when the target contains 0 records.I would like to know:Why is this difference in behavior happening between Phone Delivery and Recurring Delivery?How can I ensure that the post-processing workflow is triggered for Recurring Delivery, even when the target is empty?I need a solution that works without adding extra activities or JavaScript code. Ideally, it should

Hi Adobe team,In read list activity, select list to use tab I can see three options1.Specified explicitly2.Name computed by a script3.Folder and name computed by a script  After clicking on Name computed by a script, not able to understand below options1.In  the folder2.Label (computed)3.List template- Similarly for folder and name computed by a script. I understand list update activity, but not able to understand what option 2 and 3 does in read list. I read the document but didn't understand.Kindly help Thank you.  

Hi All, I need to create sysfilter for schema where attribute type is boolean, Attribute<attribute advanced="true"  label="Flag" name="iFlag"notNull="true" sqlDefault="0" sqlname="iFlag" type="boolean"/> Now I need add condition for sysfilter in same schema if this FLAG VALUE IS TRUE THEN it should not be visible to non admin users, please help me with this syntax, I tried multiple combination but none of them is working, please help me here@parthasarathy @_manoj_kumar_ 

Hello, I would like to know if there is a way to trigger a wkf based on another wkf with for example one week delay.WKF1 starts at 19th december and when it is done the WKF2 starts automatically the 26th december.I've tried using javascript and signal activity but the JS node keeps running until the 7 days passed and I guess it is not good and can create performance issues if scaled to several campaigns.Another way is to create some logic with scheduler node but I was wondering if it is possible to achive this with signals.Thanks

Hi all,  I implemented a workflow that queries several KPIs from past deliveries (like delivery date, number of recipients, open rate etc) and creates a report, which is uploaded to an SFTP server. As we have 2 different unsubscription links in our newsletters, the number of optouts found in ACC delivery indicators is not sufficient (it fetches the sum of both links). I would like to add the number of clicks (and derived click rates) per each of the links to the report - and that's where I struggle. The label for the links is always the same, so I thought I can just add a field that counts the clicks per URL label for each of the deliveries, but I don't know how to fetch the data. I might need some count-function with a condition to only count the clicks on the URL with the according label, but don't know how to integrate it into my workflow. (also I am not particularly skilled with JavaScript, which might have limited my efforts) Grateful for an

If I want to export broadlogrcp data to gcp/bigquery using federated data access, do I need to create another custom table to store the data first? it isnt clear on the documentation.

Hello, I have a workflow that runs every 30min and collects the total # of recipients for a delivery. Currently, it queries the broadLogRcp table for recipients with an eventDate on or after the last time the workflow ran, with the purpose of not counting recipients for a delivery twice. However, whenever a recipients' status changes from 'Pending' to 'Sent', etc., their eventDate timestamp updates. This can result in double counting, as the workflow will count the recipient once when their status is 'Pending' and then again if their status changes to 'Sent' some time after the workflow has run. To fix this, I've changed the query to exclude recipients with a 'Pending' status. My question is - are there any other recipient statuses I need to exclude to prevent counting more than once? Or is 'Pending' the only status where the eventDate is not final? Thanks,Tyler

Hi there,  I’m trying to understand how the incremental query handles exclusions. Suppose there were 5 records created yesterday with values for EID, VIN, and FEATURE_NAME. Today, when the incremental query runs, 2 new records are created with the same EID and VIN but different FEATURE_NAME values. Would these be considered new records?The incremental query identifies new records based on the REC_CREATE_DATE and excludes records where the combination of EID, VIN, and FEATURE_NAME already exists. If the FEATURE_NAME is unique, will it be treated as a new record?

Hi All , while learning i got below 2 Questions , Can someone please give brief idea about these. 1) Let's say we have 2 JS codes (JS1 ,JS2 ) , how can we call JS2 from JS1 (can't use external signal as both JS are in  same workflow but in different transitions/part of workflow) , Do we have any function or method  to call another JS for above case. 2) what are Number of ways in which we can create schemas and how many different types of schema we can create in ACC. Thanks in Advance.

Hi @parthasarathy I am trying to create a report in which I want the details of email configuration.For a particular delivery name -xyzWhat is the1.Sender address2.Sender3.Reply address4.SubjectI am trying with using delivery logs by a query activity but not able to find above attributes, and it needs to be automated. 

Hi All , Willing to learn in depth working and functionality  of "External Signal" Activity , i have gone through official document link"https://experienceleague.adobe.com/en/docs/campaign-classic/using/automating-with-workflows/flow-control-activities/external-signal"Can someone please provide a link or reference where i can learn more.Thanks in advance.

Hi Adobe Community,I was in the process of taking my Adobe certification exam when my link unexpectedly broke. I was immediately redirected to a survey page, and I couldn’t return to the exam session. After checking my status, I saw it now shows as "missed." I’ve sent an email to adobe.psisupport, but no initiative has been taken yet. I also contacted Examity, and they replied that it’s not in their hands to resolve this issue.I’m unsure how to proceed from here and would appreciate any guidance. Has anyone faced a similar issue, or does someone know the next steps to reschedule or resolve this? I’ve put a lot of effort into preparing for this certification, so I hope there’s a way to sort this out soon.

Hi @parthasarathy I have a scenario where a recipient has opened a single delivery multiple times, and I need to fetch only the top records for each recipient. For example:Recipient | Date1 | 12/282 | 12/273 | 12/26I need to retrieve only the first two records for each recipient. I am trying to use the Split activity in Adobe Campaign Classic, but I am unable to achieve the desired results. Could you please help mewith this using split activity only, as I am trying to understand how split activity work?

Hi,I want to create a new delivery category for my delivery.How do I do that?

Hi, I want to send our club members an email on their birthday.How do I set up the formula so it would disregard the year and would only check the the day and month of the birthdate? ThanksMarie

Hi all,Is there any column in any of the workflow schema to distinguish execution? i mean unique field/identifier for workflow execution thanks, sankaravel n

Hi All, Length of string/varchar field equal to 0 condition check is not working in query filter activity? Is it product bug? Thanks, Sankaravel N