Campaign Classic v7 & Campaign v8

Hi Team, We are getting the above error (PGS-220000 PostgreSQL error: ERROR: relation "wkf<some_number>_7_1" does not exist) while executing a branched workflow made by Jump activity. There is a main workflow from which we call couple of sub-workflows to load profile, subscription data in their respective sub-workflows. While coming out of the sub-workflow 1 say profile workflow, the error in subject pops up and the workflow fails therein. Could you please let me know the reason for this error? Thanks,Rajesh.S.S.

Is there a way to manage the order of the columns when exporting using the Data extraction (file) node? I am exporting the same file from two schemas and want the same results since its the same fields essentially so that I can combine them in a macro afterwards.

Hi all experts, I need a suggestion from the great minds out here.I am trying to implement a way by which I can format content rendered from a third party source into my email delivery.For example, I use the following code<%@ include file="anyThirdPartyUrl" %> in my email delivery, which renders some content. But I want to format the content before it is displayed in the customer's inbox.What I tried was to call this "anyThirdPartyUrl" in a Jssp, format it the way I want and then call the Jssp URL in the email delivery like this<%@ include file="jsspInMyMktInstance" %> But this resulted in an error (failed to call/load directive). Not sure if this is at all possible, and I need some advice for the same. Some more info: The third party URL returns a JSON, which I need to format and display in an HTML block (as images, text and links), for which I tried to use a Jssp in the middle. Not all email clients/users have javascript enabled, that is why all format

Hi, How can I add restrictions in the schema - means I have created company operator group. If user doesn't have access to the company operator group, then it should not be able to access in the schema.How can I use sysFilter in schema to access group. Regards,Tejashri

I did not see a specific answer to this question.  I saw a few similar, but not exactly.  Please do not send me to adobe documentation because they don't cover this for adobe campaign classic and I've spent hours reading their sms documentation. We are sending short notification sms for home delivery updates and we are working with Netsize/Link Mobility on this implementation.  This is what a text looks like: Your Whirlpool delivery is on track for tomorrow between <%= rtEvent.ctx.deliveryStartTimeSH %> - <%= rtEvent.ctx.deliveryEndTimeSH %>. Track your delivery status <%= rtEvent.ctx.trackOrderLink %> The rtEvent.ctx.trackOrderLink is a very long link and has been configured to shorten the url with our short domain name.   So it will look something like this:   https:\\whirl.us\xyzxyz We want to tag this link so we can track the call to action (CTA).   1)  Can we add a _label at the end o

ACC build version 8795 (old version of Campaign), does oracle Database 19c supported

Has anyone successfully added an "Add to Calendar" button to their email deliveries allowing the recipient to click and apply the necessary info to their personal calendar? We provide a list of 3 to 6 available drives from which the recipient can choose to donate, so we'd like the button to register the information of the single drive they select. We believe we could do this by uploading a default or template ics file into the Public Resources folder which calls on the fields within the email delivery that has the necessary scripting for the button via JavaScript. Has anyone already accomplished this or something similar?

Hi All,I would like to know if there is a possibility of adding personalizations in the .ics file in Adobe Campaign Classic.Regards,Anushka

HI guys,My requirement is to upload a file extraracted using file extract activity in the workflow into a SFTP location which is mounted on same server where campaign server is located.I am able to download and process files from the SFTP location using file collector activity (I don't need here file transfer activity as SFTP location located on same server)Please suggest me if there is any solution available. ThanksBiranchi

Hi all, We are using Javascript code for sms delivery. The URL used in the script is different for development and production. So I am planning to save the URL in option and this will be called in JS code using getOption(). When triggering sms delivery using the Javascript Iam getting below error " getOption is not defined" Same code I tried in Workflow using javascript activity, I can able see the option value in logInfo(). Could you please tell me what will be the issue. Thanks,Ram 

Hello, the targeted audience going into the delivery activity has multiple segment codes. For example, 100 people with 50% segment code A and 50% segment code B. I'd like to have a control group of 20% for EACH segment. So of the 50 people labeled segment code A, we'd like to have 20% in control group (10 people), and of the 50 people labeled segment code B, we'd also like to have 20% in control group (10 people). Total send would be 80 recipients (40 from each segment code) and 20 recipients in the control group (10 from each segment code). Is this possible to do in one delivery? My only other thought is to do a split for each segment (random sample of 20%) and give them a label of "control" in the target data and then in the delivery control group configuration select anyone with the label of "control". I'm trying to avoid reworking the workflow to add in the splits for each segment and then union everything back together again to input into the delivery. Thank you in advance for any

Hi team, We are using on-premise ACC and we are using a frontal server for tracking and webform. And client want to track cta of url in each messages.  So when we send a message such as LMS channel, we turn on tracking mode. Because of this, all url have been changed to personalized url(or redir url?), email channel can be tracked all cta. But in LMS case, when we click the url, server can't find target URL and in webmdl.log of frontal server, I can see below log. 1.tracking url : https://t-xxx.xxx.co.kr/r/?id=f1839a,980fe,ab5 2. Browser message : Requested URL '/r/?id=f1839a,980fe,ab5' cannot be founded. 3. Error log : RED-520003 parameter 'id' is invalid for URl '/r/? In the frontal server, xml files for redir are located correctly. Nevertheless LMS channel can not be tracked. Have you ever been any experience related to this? Or please let me know how can I solve this problem. Thanks,Best Regards,Daeho

Hello All, We are experience issues when WKFXXXXX tables are joined with others. The reason is that optimizer has inaccurate statistics using default settings and chooses wrong join order. In we calculate statistics manually (kill DB process), recalculate statistics using database tools and rerun - everything is fine and much faster. Of course best will be to change settings from default on task level - but if we get improvements in overall performance then site wide settings will be helpful Thanks in advance 

Hi,According to the documentation, it must be possible to write to a linked table from the nms: recipient:https://docs.adobe.com/content/help/en/campaign-classic/using/configuring-campaign-classic/api/data-oriented-apis.html#example-on-links Here in the example I try to create a recipient and at the same time write in the table "Communication data" such as email and telephone number.The cus:Kommunikationsdaten data is linked to the nms: recipient via the customer number:  <element integrity="neutral" label="Recipient" name="Recipient" revIntegrity="neutral"revLabel="Kommunikationsdaten" target="nms:recipient" type="link"><join xpath-dst="@Kundennummer" xpath-src="@Kundennummer"/></element>  Why does it not work with this soap call: <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:urn="urn:xtk:session">   <soapenv:Header/>   <soapenv:Body>      <urn:Wr

Hi everyone We are planning to perform a full refresh of the Adobe Campaign database using an external file that will be loaded through a workflow. Several attributes of the Recipient schema will be updated, along with their subscriptions. Missing accounts will be created too. The ideas is to request a full back-up to be taken before we start and stop all the pipelines that feeds data in and out of Adobe Campaign. From the testing performed in staging for this bulk update, and some benchmarks of other similar updates we have done in the past, we know that the bulk upload workflow will take more than 10 hours to complete, probably around the 15 hour mark, which would effectively mean almost two days of interrupted operations for the various marketing teams.  Since all the pipelines will be stopped anyway, I was wondering if it is possible to proceed with the bulk update while the marketing teams send the campaigns. Will the delivery workflows lock the database and in

Hello,I am wondering how can I upload a file to the SFTP location of the current environment, for example in the subfolder /export could you tell me what I need to insert in place of "abc" ? The idea is to create a file during the workflow execution and attach it to a delivery as explained here:https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-standard/creating-a-calculated-attachment-where-file-name-is-computed-at/qaq-p/253991Thanks,Salvatore FYI @jonathon_wodnicki @jean-serge_biro @kapilkochar @anita_punmiya @milan_vucetic + @Adobe Campaign Community 

Hello everyone,we have 2 adobe campaign instances. Stage and production. In our production instance, we have an extra opt-out option which says "No longer contact by SMS/MMS" whereas in stage this option is not present.I searched the schema in stage and saw this field is present but it's not showing up in the recipient table.Production Stage How do I add "No longer contact by SMS/MMS" in the recipient table in my staging instance?Kind regards,Imran

I have activated delivery workflow in my campaign, but workflow is not executing, how to troubleshoot? 

Hi There, I am trying to set up an automated export from a workflow to a Google Drive and I wanted to know how I can do that ?Do I need to use a file transfer activity or a data load activity or something else ? Can you please explain how to do that?thanks in advance for your help

I wanted to enrich the MirrorPageURL for each recipient onto the workflow after the delivery has completed so I can save it in an external system. I've tried using GetMirrorURL from the database functions and that doesn't do anything (besides there being NO documentation on how it works)So I am trying using JS to reconstruct the MirrorPage URL but I cant seem to get the broadLog-id out of the post-delivery schema:This is the query I am using:  get: { records: function( recordsToFetchPerBatch,currentStartLine ) { var query = xtk.queryDef.create( <queryDef schema={vars.targetSchema} operation="select" lineCount={recordsToFetchPerBatch} startLine={currentStartLine}> <select> <node alias="broadLog-id" expr="@broadLog-id" /> </select> <where> <condition expr="@id IS NOT NULL" /> </where> </queryDef> ).ExecuteQuery(); return query;

Hi All, In monitoring watchdog is missing. could you please tell me how to solve this. Thanks,Ram.

Difference between Campaign standard and classic? Both have same features?

I just watched a presentation and the presenter was using Adobe Campaign v7. I presume that is Adobe Campaign Standard. I am using Adobe Campaign Classic. Please correct me if I am wrong.

Hi, I have created web application in ACC and added below code in script. var contactID = ctx.recipient.@contactId;/**Fetch Details from BroadLogRcp*/var query = NLWS.xtkQueryDef.create({queryDef: {schema: "nms:broadLogRcp", operation: "select",select: {node:[{expr: "[delivery/@messageType]"},{expr: "[@address]"},{expr: "[@status]"},{expr: "[delivery/@label]"}, {expr: "[recipient/@managerID]"},{expr: "[@employeeID]"},{expr: "[delivery/@lastModified]"},{expr: "[delivery/@id]"},{expr: "@eventDate"},{expr: "[@recipient-id]"}]},where: {condition:[{expr: "[@employeeID] = " + contactID} || {expr:"[recipient/@managerID] = " + contactID}]},orderBy: {node:{expr: "@eventDate", sortDesc: "true"}}}});  Here "OR" condition is not working. Please help me to solve this issue. Thanks,Tejashri

One of the Out of box workflow provided is Refresh for Deliverability.Need to understand its significance in adobe campaign and also is it really necessary to have it in project?Pros and Cons for it. Thanks in advance. Regards,Sonika dutta