Adobe Campaign

Hello! Hoping someone can help. 😊   When I run the Database Update Wizard none of the schemas that I have created or have made updates to are being updated. The update script shows me every schema I've built with the "Synchronize" checkbox checked, but the SQL script shows every line of code commented out (see screenshot).    I noticed this occurred after I created an extension of the nms:recipients schema using the "cus" namespace, but then created a new extension of the nms:recipients schema using a different namespace (let's call the new namespace "xyz"). I subsequently deleted the extension with the "cus" namespace thinking the database structure update was affected due to having two extensions of the nms:recipients schema with different namespaces.   Summary of Steps Taken: 1. Created "cus" extension of nms:recipients schema 2. Added attributes to cus:recipients schema and updated the database structure successfully. (Verified new attributes were s

Hi, Is it possible to create an integration between ACS and Google Cloud Platform (GCP) or BigQuery? Anyone worked with such a connection to import data to ACS? Is there any documentation on this?  

Hi all,   In a workflow, we want to get the touchpoints of each profile to insert in a custom resource that we have created. We have tried creating a additional field in a query acivity, counting the delivery logs, with the following function "Count(logs)", but we get the following error "PGS-220000 PostgreSQL error: ERROR: INSERT has more target columns than expressions"   Do you know how can we do it?   Thanks

Hi All,   Is it possible to build a loop like construct in Adobe Campaign Workflow. I need to process the output of an enrichment, 1 record at a time, check for certain conditions after the processing step. If the condition fails, I loop back again.   Can somebody help me with the construct   Regards, DG        

Hello   When we running our campaign workflow, there is a split where the pre-defined filters query supposed to run usually it take 10 mn max but for some reason nowadays it takes 1 to 2 hours to run. I am not sure how to start the investigation, not sure if its related with pre defined filer or something else who affecting these.   Any hints?

Hi,   I have a product listing payload from real time communication. Below is the payload   {"email":"myprofile@adobe.com","ctx":{"TotalPrice":1234.123456789,"OrderID":"string127","ProfileNumber":"phone","ProfileEmailId":"myprofile@adobe.com","ProfileName":"string127","Content":[{"BrandName":"string127 #1","BrandPrice":1234.123456789},{"BrandName":"string127 #2","BrandPrice":1234.123456789}]}}   Trying to use Content Array into Content block so that it can be reused whether such kind of payload occur.   Tried to create content block with following information   <div class="acr-structure acd-loop" data-structure-id="1-1-column" data-structure-name="richtext.structure_1_1_column"><table class="structure__table" align="center" cellpadding="0" cellspacing="0" border="0" width="100%" style="width: 80%;border: 1px solid #000;"><tbody><tr><td style="color: blue; font-weight: Bold; border-bottom: 1px solid #000; border-right: 1px solid #000;

Hi Team   I am calling a Rebrandly API service to convert adobe generated WebApps link to short URLs. But after few calls (approx 1000 calls)/sometime (approx 12-15 mins) the workflow automatically runs into error as :- "IOB-090008 Failure while resolving address 'api.rebrandly.com' (errno=-11)"   Find the code below used  var startLine = 0; var limit = 9999; var loop= true; while (loop) { //Fetching the customerIDs dynamically var query = xtk.queryDef.create( <queryDef schema="temp:query" operation="select" startLine={startLine} limit={limit} > <select> <node expr="@SMS"/> </select> </queryDef>); var res = query.ExecuteQuery(); if (Object.keys(res).length>0) { for each (var rcp in res.query) { //Fetching the customerIDs dynamically whose shortURL is EMPTY var query2 = xtk.queryDef.create( <queryDef schema="dbSchema" operation="select"> <select> <node expr="@SMS"/> <node expr

I attempted to publish templates in message center, and then after activating the soap call, I always received this event type not covered error. Is there any possible way to resolve this.?

Hi Team,   We are facing an issue with V8 while using SMS (SMPP) the deliver-SM is not getting mapped to the delivey, the external identifier is getting cropped. attached screenshot for your refrence, please do help us out. we are unable to find if the SMS failed/sent. Thanks in advance.   Thanks, Shine v.v  

Hi, Is it possible to use the "Alert" activity in a workflow to send the alerts to non-operators or groups. I have few stakeholders who I'd like to send the alerts but they are not set as  operators in the AC. Unfortunately, the delivery template which Alert activity uses i.e "alertAssignee" is based on the xtk:operator schema and only accepts either "Operator" or "Operator group". How do I send Alert to someone who is not an operator? PS: I've already tried adding the email address as "Seed Address" in the "alertAssignee" delivery template thinking it would send a copy to the seed address and would solve my purpose. But, apparently, the delivery is getting failed with the error:30/01/2019 12:51:49        DLV-490006 Error while adding 2 message(s) out of 2 targeted.30/01/2019 12:51:49        color:#333333;          text-transform:uppercase;      '30/01/2019 12:51:49        XML-110018 Error while parsing XML string '<?xml version='1.0'?> <dataSource><id>91180</id&gt

Hello, When someone else wants to start my workflow (created by me under my operation), in the log part the user mentioned as starter is me. I would like to know if there is something to do to avoid this ? We should have the "real" starter and not the creator of the workflow/campaign as starter in this specific case. The execution login do not change. Thanks

I need to pass variable from webapp js to workflow js , we are using an external signal to trigger the workflow from webapp javascript.   when we use vars.variablename  xtk.workflow.PostEvent('calledWorkflow','signal','', <variables varName= {vars.xyz} />,false)   it shows an error in webapp as it does not allow vars.variablename.   we have also tried ctx variable but in the workflow it is coming as undefined.  

I want to import the .eml file which is created on the MTA server while creating email copies. the .eml file is created for the BCC (blind carbon copy) of an email.   I would like to import the .eml file into the adobe campaign. Is it possible to do so?   @shubham_goyal__  @_manoj_kumar_ 

Hello, i have to modify the delivery summary report by adding a column regarding the click-to-open rate for each email. Is it an existing metric on Adobe Campaign ?

We need to provide limit access to ACS reporting only. Is it possible with Campaign standard? If yes, how? Thanks for your help

We are currently adding the delivery name to the beginning of the Proof Subject Line manually for each campaign.  Is it possible to have the Delivery Name included in the Proof Subject Line at the Template Level and if so, how can this be accomplished?  thanks.

In Adobe Campaign Classic you could use alert activity to send an email to a group of operators. I want to do the same thing in ACS. Is it possible? If not, what workaround can I use?   Thanks,

Hi All,   We have a few contact history records to delete from ACS broadlog/trackinglog/exclusionLog is that possible? In Classic this was handled easily, I couldn't find any delete option for these OOTB tables. Anyone with similar experince.

Hi Adobe Campaign Community:   Is there a definitive guide to obtaining detailed Adobe Campaign Reports via API?   Michael

Dear Community, I am trying to use DBEngine query() command to select data from MSSQL database and I need to pass parameter/s to my query. I am following this tech spec - DBEngine.query() documentation.There is an example showing how to pass a param - to do this use $(l), $(sz) as a param-holder/s (depending on param type), then pass param value/s separated by comma. Easy.However, when I do so I get an exception: Error: SCR-160021 Function 'query': too many arguments (X instead of 1).Where X is 2 if I pass a single param. It's 3 if I pass two params. And so on. Only query text is possible to pass as a single allowed function argument.  This is my code lines:  var conn = application.getConnection(); result_Select = conn.query('SELECT 12345 as Col1, \'John Doe\') as Col2 WHERE 1 = $(l);', 1);  This is the exception:  Error: SCR-160021 Function 'query': too many arguments (2 instead of 1).   ACC v7.0 19.1 build 9032@d3b

Hello, The DM Delivery output script is consistently failing to compile when adding any type of variables to the output script (Ex: <%= vars.campaignId %>_<%= vars.workflowId %>_<%= vars.lastSync %>). I've also tried updating the script syntax in the DM template then echoing it to the recurring delivery in the campaign but still failing with errors below. One think I noticed is that whatever variable we add to the script output file, it’s always defaulting to <%= message.cellId %> in the output file external config. The following is the output name I want to achieve ==> DirectMail_2022-10-19_12-48-34-000_3262771_3453765_2210191231.txt. Any feedback would be greatly appreciated.   Screenshots:   Thanks, Soph

Hello All, ACC 7.2.2 build 9349@e319b6d of 02/28/2022 MSSQL is an external database <srcSchema> is (some values are masked/dotted): <srcSchema ... entitySchema="xtk:srcSchema" img="xtk:schema.png" label="TestKey" ... name="TestKey" ... view="true" xtkschema="xtk:srcSchema"> <createdBy _cs="..."/> <modifiedBy _cs="..."/> <element dataSource="..." label="TestKey" name="TestKey" sqltable="[dbo].[TestKey]"> <attribute advanced="false" label="col1" name="col1" sqlname="col1" type="long"/> <attribute advanced="false" label="col2" name="col2" sqlname="col2" type="long"/> <key clustered="true" name="PK_TestKey"> <keyfield xpath="@col1"/> <keyfield xpath="@col2"/> </key> </element> </srcSchema> Note, there is a <key> element defined in the schema! Two columns involved. It's important for later. MSSQL database table structure is: create table dbo.TestKey ( col1

I'm looking for a way to have a workflow starts when a file gets uploaded from FTP.    Is this possible? We have a file that randomly populates, and we can't control the timing of when it gets uploaded. 

Hi All,   I'm trying to extract SMS (every sms delivery sent until date) delivery logs for pending and failed states. Whch exact table contains this information in ACS ?   Thank you, Rutuja Kelkar

Hi, We were missing data in the dynamic reports for a period. Now it is back again from a week ago and data is showing from a specific time onwards. But the data, from the period when we had issues with the dynamic reports, is still missing.  For example when I check a delivery that was sent just a day before our problem was solved, then we have 0 sent emails but we have 7000 opens (which happened after the problem was solved and therefore shows in the reports). Is there anything I can check or do myself in order to get the numbers back in the dynamic reports for this period when the numbers are missing?